The battle has been fought before - and the list administrator has given
his reasons why he has not made the requested change. The way the list
currently behaves is not an accident or omission, but a deliberate
decision. I do not recall the grounds for that decision - maybe RFCs or
the behaviou
DESC is a reserved word in MySQL: it is short for DESCENDING and is used
to reverse the sort order in SELECTs. You an create a field with that name
by enclosing it in backticks: `desc` whenever you need it. However, this
would be regarded by many as very bad practice. It would be better to
chan
Zachary Kessin <[EMAIL PROTECTED]> wrote on 22/06/2005 09:12:22:
> Martijn van den Burg wrote:
> > Stephane,
> >
> >
> >>I've was wondering if anyone is using MySql as their main ERP
> >>production database, if so how stable and reliable is it?
> >
> >
> > SAP and MySQL have teamed up to cert
[EMAIL PROTECTED] wrote on 27/06/2005 16:33:44:
> Are you actually saying that you have a database with more than 1.8e+19
> records in it? I don't think you do.
If you were to add records at the rate of a million a second, which is, I
think, beyond the capabilities of any foreseeable future h
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 28/06/2005 14:36:37:
> Hello,
> I am reading the docs, but I am slightly confused.
>
> I have a table with a varchar(50) column (not a primary column)
> where I do not want duplicates. It is a properties column, and I am
> getting duplicates inserted
David Kagiri <[EMAIL PROTECTED]> wrote on 30/06/2005 09:44:11:
> Hi
> I our database there is one table that will grow into tetrabytes
> within a short time.
>
> I would like to know how i can reduce full table scans.
>
> I have used separate tables as per region for now but the problem is
> if
news <[EMAIL PROTECTED]> wrote on 30/06/2005 16:47:43:
> I'm designing a simple family tree db which is at present just a flat
table
> In which each record everyone has a father & mother, a variable
> number of wives,and variable number
> of children.
> The links to other family tree members is
"Haisam K. Ido" <[EMAIL PROTECTED]> wrote on 01/07/2005 15:04:01:
>
> I've created the following table (server 4.1 in win2k)
>
> CREATE TABLE `os` (
>`id` tinyint(10) NOT NULL auto_increment,
>`name` varchar(255) NOT NULL default '',
>`description` varchar(255) default NULL,
>PRI
Andrea Gangini <[EMAIL PROTECTED]> wrote on 22/07/2005 10:17:34:
> I have a column in one of my table, which:
> - must be unique
> - must be indexed because almost all queries are "SELECT .. WHERE
> COLUMN LIKE "
>
> I created two indexes this column, one of type UNIQUE and a normal one
The system cannot used the index on field2 because it is the second half
of the index in both cases, and it can only use indexes in order. It
cannot use the separate indexes on field 1 and field 2 because the are
ORred together.
If you rephrase your query
SELECT * from table
WHERE field2 LI
Nico Grubert <[EMAIL PROTECTED]> wrote on 22/07/2005 09:06:25:
>
> Hi there,
>
> I have a MySQL 4.1 DB running including a database whose character set
> is set to utf8.
> In the database I have a table "tblmembers" with some records containing
> german umlauts.
> How do I sort results with germ
Bob Rea <[EMAIL PROTECTED]> wrote on 28/07/2005 18:19:34:
> I am learning MySQL from an older book, and some of the examples it give
do
> not work in MySQL, so I am going to ask for help on those.
>
> select cust_contact from Customers where cust_contact like '[JM]%';
> returns Empty set (0.0
Just in the spirit of refining my own skills, here is how I would tackle
the problem. It parses, but I haven't populated the tables so I don't know
if it works:
SELECT s.dateshipped, COUNT(r.type="undelivered"), COUNT(r.type =
"customer"), COUNT(r.status="open")
FROM shipments s JOIN returns r
Sorry - I think you need a LEFT JOIN or it won't count shipments which are
not returned.
Alec
[EMAIL PROTECTED]
12/08/2005 16:38
To
[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
Re: Complex query. (It's killing me)
Just in the spirit of refining my own skills, here is how I w
"Blue Wave Software" <[EMAIL PROTECTED]> wrote on 18/08/2005
15:57:34:
> I'm having one of those slow brain days.
>
>
>
> I want a partial filter egg. All records where field1 begins with "ABC"
any
> body know the where clause to do this.
>
> In Access it's where field1 = 'ABC*' but I can'
The insert will only be bounced where you specify the columns as unique.
Thus you need either separate UNIQUE indexes on Name and Value, if you
want them to be individually unique, or a single joint UNIQUE index if you
want them to be jointly unique but separately duplicable. The INSERT
command
Yui Hiroaki <[EMAIL PROTECTED]> wrote on 24/08/2005 10:57:20:
> I created table for fulltext. I publish SQL:
>
> sql>create table (test title longtext)TYPE=MyISAM;
> sql>alter table test add fulltext title (4);
>
>
> But title is so small to insert text.
> what biggest text I can insert tit
Hal Vaughan <[EMAIL PROTECTED]> wrote on 24/08/2005 17:41:36:
#>
> Okay, so INSERT IGNORE only works if I am avoiding duplicate keys. Is
there
> any way to use INSERT the way I thought INSERT IGNORE worked -- in other
> words is there any keyword for the INSERT command to keep it from
dupli
m i l e s <[EMAIL PROTECTED]> wrote on 30/08/2005 15:28:31:
> Hi,
>
> Ive noticed that my ALL my databases and tables have
> "latin1_swedish_ci" as the collation...h that wouldn't be so bad
> except that I didn't set it that way by default, and I don't speak
> swedish. Not that swedish is
insensitive throughout, so do as you will.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that platform is marketed by a company who many of us
find totally repulsive. If you let yourself be hyped into dropping MySQL,
you will be harming a company that is, in my opinion, a model of how to
provide full commercial quality software (or better) with an Open Source
licence, while not
"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 08/09/2005 10:33:25:
> Talking limit (in select query), does it "limit" the search result
> after ordering according to relevancy and the likes, or before?
> thanks
LIMIT operates after ORDER BY.
Alec
--
MySQL General Mailing List
For l
Scott Haneda <[EMAIL PROTECTED]> wrote on 15/09/2005 10:31:48:
> I have moved my data from mysql 3 to 4, across various updates, over the
> past few years. I use phpmyadmin generally, and it defaults to making
tables
> myisam.
>
> I can not seem to find a really clear answer as to why I want to
Sid Lane <[EMAIL PROTECTED]> wrote on 19/09/2005 15:02:58:
> stupid ?:
>
> what keeps them from getting caught in a write loop? turning off
> log_slave_updates?
>
> I had never thought of this but is has intriging possibilities...
Each update is marked with the unique server id of the server w
Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13:
> I am creating an application in Visual Basic 6.0 which will require a
> centralised database server. All this while I had been planning to use
> MS-Access. But then I found out that MS-Access is ok to be a desktop
> rdbms but
Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 11:28:51:
> [EMAIL PROTECTED] wrote:
>
> >Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13:
> >
> >
> >
> >>I am creating an application in Visual Basic 6.0 which will require a
> >>centralised database server. All this
Yannick Warnier <[EMAIL PROTECTED]> wrote on 03/10/2005 11:18:05:
> Hi all,
>
> Using PhpMyAdmin, I seldom get the warning message:
> PRIMARY and INDEX keys should not both be set for column `ID`
>
> I understand its meaning, but I was wondering to what extent having a
> field indexed AND being
is only one index even though it is over
two fields (the order in the telephone directory). You would only need
another index if you wanted to search over GivenName,FamilyName. This
would then require an extra index, which would have to be put in the back.
Alec Cawley
--
M
gt;
>> I like to hear from you.
>
> I think you are wrong in your presumption that there are individual
> indexes. Consider a telephone directory: this may be regarded as indexed
> on FamilyName, GivenName. There is only one index even though it is over
> two fields (th
Hugh Sasse <[EMAIL PROTECTED]> wrote on 13/10/2005 16:27:44:
> I'm fairly new to MySQL and am getting an error messages like:
>
> ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for
> the right syntax to use near
"Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote on 14/10/2005
03:28:15:
> Hi Listers,
>
> Does anybody know if the MyISAM engine (apart from InnoDB) allows the
> use of raw disk space rather than having cooked files? If not, is this
> feature likely to be included in a future release?
news <[EMAIL PROTECTED]> wrote on 17/10/2005 15:45:15:
> I need it some info to help a client defend against a legal challenge.
> Is there a MySQL function that will allow me to ascertain the date and
> time that a particular field's value was last updated. I can't find
> anything in the MySQL
[EMAIL PROTECTED] wrote on 21/10/2005 12:28:18:
> Hi,
>
> I had installed a free version of mysql database software in one of the
> servers that are available to me. I had installed the mysql in the c:/
> folder, is it possible for me to change the data storage location from
> C:\mysql\data\
Andreas Steichardt <[EMAIL PROTECTED]> wrote on 24/10/2005 10:34:08:
> Hi!
>
> I just hit something really strange which is either a bug in MySQL or a
> dumbness bug of me.
>
> I am trying to insert a string ending with a simple space and i really
want
> this space at the end of my string ;).
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/11/2005 20:28:38:
> Hi, all
>
> I have a question like this:
>
> There's a field in table_A, date_time, if I say this in Mysql:
>
> select min(date_time), max(date_time) from table_A;
>
> it returned something like this:
>
> +-
Brian Dunning <[EMAIL PROTECTED]> wrote on 02/11/2005 16:22:29:
> I'm trying to find a list of customers including a count of all their
> invoices, but it's not including customers who have no invoices - and
> it should. What's broken?
>
> SELECT customers.company, count(invoices.id) as invcoun
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 17:48:29:
> Dear list,
>
> I'm considering programming a simple "Search Engine" for a website,
> to find Arabic/Persian data within a MySQL database.
> This database contains a huge amount of data, encoded with
Unicode(UTF-8).
>
>
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 18:36:25:
> On 24/11/2005, Alec worte:
>
> > I think this is your problem: MySQL does not properly support
Unicode
> > until version 4.1. I am successfully using FullText with MySQL
> 4.1 to sort
> > UTF-8 encoded Japanese text.
To reply to this, I think we have to understand why you have chosen to
split the tables at all. It seems to me that this, by introducing a
two-level lookup, is certain to be slower than any possible single table
lookup. Generally, Log A + log B is bound to be larger than log (A*B).
It appears
"David T. Ashley" <[EMAIL PROTECTED]> wrote on 07/02/2006 14:03:04:
> Hi,
>
> I have several tables linked in various ways so that an inner join is
> possible. However, at the same time and in the same SQL query, I'd also
> like to query by some field values in one of the tables.
>
> Two quick
Patrick Duda <[EMAIL PROTECTED]> wrote on 10/02/2006 16:28:56:
> I guess I don't understand this locking stuff. I have a InnoDB table
that
> has one thing in it, a counter. All I want to do is have multiple
> instances of the code read this counter and increment it. I want to
make
> sure t
Al Sparks <[EMAIL PROTECTED]> wrote on 13/02/2006 16:11:49:
> Basically, I'm new to mysql (or to any database for that matter).
>
> I have an old version installed on my linux machine. I thought, as a
> learning exercise I'd take 2 files (tab separated tables) load them
> into mysql and then mer
Ronan <[EMAIL PROTECTED]> wrote on 16/02/2006 11:56:18:
> Im trying to set up a primary key of server(text), date (date), hour
> (small int) but when i try to include the server field in the key it
> replies with
>
> ALTER TABLE `exim` DROP PRIMARY KEY ,
> ADD PRIMARY KEY ( `date` , `hour` , `s
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 14/03/2006 11:32:10:
> Hello Paul,
>
> I suggest you reply to the mailinglist :-) ...
>
> > The developer insists that for scalability issues, this was the
> > answer. It is likely, for example in my deployment, that these tables
> > would see upward
"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10:
> As an example:
>
> There was a table called event.
>
> This table is now broken up like this:
>
> event __.
>
> So for every sensor, and every day, there is now a new table. So if I
> have 20 sensors, every day I will have 20
nigel wood <[EMAIL PROTECTED]> wrote on 14/03/2006 13:09:08:
> [EMAIL PROTECTED] wrote:
>
> >"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10:
> >
> >
> >
> >
> >>As an example:
> >>
> >>There was a table called event.
> >>
> >>This table is now broken up like this:
> >>
> >>even
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 16/03/2006 11:02:32:
> Well, the question still is if you should store "unknown" at all ;)
>
> Not according to Date: you should store what is known. See the remarks
> about the "true propositions", from which relational databases are
derived
> (but
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 16/03/2006 11:32:45:
> From: <[EMAIL PROTECTED]>
> > "Martijn Tonies" <[EMAIL PROTECTED]> wrote on 16/03/2006 11:02:32:
> >
> > > Well, the question still is if you should store "unknown" at all ;)
> > >
> > > Not according to Date: you should store wh
"Rhino" <[EMAIL PROTECTED]> wrote on 21/03/2006 13:41:49:
>
> - Original Message -
> From: "Zsolt" <[EMAIL PROTECTED]>
> To: "MySql Mailing List"
> Sent: Tuesday, March 21, 2006 2:58 AM
> Subject: How to shutdown mysql from Java
>
>
> > Hi,
> >
> > my application starts mysqld (via Ru
[EMAIL PROTECTED] (saf) wrote on 23/03/2006 16:10:04:
> On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
> >
> > The short answer is "no". The Record #2 already existed. It's current
> > status is "deleted". If you h
news <[EMAIL PROTECTED]> wrote on 06/04/2006 14:39:33:
> IF I have a table like this:
> id int not null,
> field2 int not null,
> ..,
> primary key (id),
> key (field2)
> ) ENGINE=MyISAM;
>
> The primary key is id only or (id, field2)?
> If this is the case which constraint are aplied on fiel
al variable ft_min_word_len to 3 to achieve what
you want. As shipped, it is set to 4, which means that words of three or
less letters are ignored. After changing the variable, you need to rebuild
the index.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
used on. In simple
performance tests, it appears that named pipe access is between 30%-50%
faster than the standard TCP/IP access."
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"Denis Gerasimov" <[EMAIL PROTECTED]> wrote on 10/02/2005 10:59:11:
>
> Hello,
>
> One simple question... AFAIK I can specify value for an autoincrement
> primary key (int) when inserting a record like this:
>
> INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test')
>
> But it doesn't work
e (on the Updates side at least) Raid 0 does not
help you, because there are no overlapping reads to get from alternate
disks.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"mel list_php" <[EMAIL PROTECTED]> wrote on 14/02/2005 13:54:35:
> additional test,
> it is always bugging at the key 127...
> I put a backup online, with until 106.
> Added few test records, from key 127 it just doesn't want to increment
the
> auto-increment field anymore.
> I'm completly lost
"mel list_php" <[EMAIL PROTECTED]> wrote on 15/02/2005 10:18:55:
> Hi!
>
> I have a database where several users can connect and input data.
>
> I managed to have my insert queries as atomic, but I was wondering about
one
> special case: I make one insert, and retrieve the last id inserted by
"Jesper Andersson" <[EMAIL PROTECTED]> wrote on 15/02/2005 13:15:43:
> Hello,
>
> I relly new with databases and writing sql-questions.
>
> But in my db want I to check what have new rows have come the last hour.
>
> the db have I as follow:
>
> ID email created upd
"Kevin A. Burton" <[EMAIL PROTECTED]> wrote on 28/02/2005 17:41:07:
> Right now one of the only reasons we can't put our entire config for our
> slaves in CVSup is that the config *requires* the ability to set a
> server-id for each machine.
>
> Seems like it would be pretty trivial to support
cords,
the commands suggested by David will certainly free space and probably
improve performance.
Alec Cawley
"Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote on 08/03/2005
22:58:12:
> Hi Chris,
>
> For MyISAM/BDB tables use OPTIMIZE TABLE ;
> For In
Ted Toporkov <[EMAIL PROTECTED]> wrote on 15/03/2005 11:04:09:
> List,
>
> I'm trying to create tables that will store data temporarily, if a php
> page generates data to fill the table, then any number of queries could
> be run on the table, and then be automatically be deleted if it's not
>
"Andy Hall" <[EMAIL PROTECTED]> wrote on 18/03/2005 12:06:30:
> Hi,
>
> I have tried the following process in order to try and replicate a
database
> with InnoDB files:
>
> 1. created a new database in PHPMyAdmin
> 2. via command line, copied all the .frm files from the old database
> directory
Eko Budiharto <[EMAIL PROTECTED]> wrote on 18/03/2005 16:54:09:
>
> Hi,
> I am trying to to update one field with multiple value.
> I tried with regulare "update" command syntax does not work. How to
> update a field with multiple value.
>
> regular update syntax is this, UPDATE variableInfo S
"mel list_php" <[EMAIL PROTECTED]> wrote on 23/03/2005 10:14:07:
> Hi list,
>
> I would like to search for something into one or several tables.
> My first idea was to retrieve the tables' names, then for each of them
> retrieve the columns' name and have a look in each of this column.
> Is ther
I am not quite sure I understand your question, then: you would have to
make your table structure a little clearer. Generally, however, puristic
database design would say that you do not have the same "class" of data in
different tables. Instead, you have one "master" table with all the
"simila
select l.b, r.a = l.b from tab l join tab r on l.a = r.b where l.a = 1 ;
seems to produce the result you want
"Gabriel B." <[EMAIL PROTECTED]>
29/03/2005 09:30
Please respond to
"Gabriel B." <[EMAIL PROTECTED]>
To
mysql@lists.mysql.com
cc
Subject
help with a mutuality check (good query e
Du?an Pavlica <[EMAIL PROTECTED]> wrote on 30/03/2005 16:35:40:
> Hello,
>
> maybe this is a silly question but how useful it is to create
> indexes on columns containing only values 0 and 1 (true and false)?
Since I believe that MySQL ignores indexes if it expects to get more than
30% hits, i
"Christopher Vaughan" <[EMAIL PROTECTED]> wrote on 30/03/2005 16:48:47:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
> I want to break each part of the data into different parts based on
> the ':' to separate them. Then I want to take that data and sum it.
The command you need is
source ;
Alternatively, if you are outside the mysql clined
mysql <
Alec
"Joppe A" <[EMAIL PROTECTED]>
04/04/2005 09:59
To
mysql@lists.mysql.com
cc
Subject
how to run a file in MySQL
Hello all,
This is probably really basic for all of you but I have
Micha Berdichevsky <[EMAIL PROTECTED]> wrote on 14/04/2005 12:53:31:
> Hi group.
> I have a table with a varchar(250) column in it (let's call it c)
> I want to select values that contain a number of given words in them
> (three or more), in any words order
> I currently use
> SELECT * FROM table
[EMAIL PROTECTED] wrote on 26/04/2005 14:46:37:
> Hello,
>
> I have a big problem, I only want to check if it's the minute 45
> currently.
>
> I want to make a virtual SELECT without tables:
>
> mysql> SELECT MINUTE(CURRENT_TIMESTAMP()) WHERE
> MINUTE(CURRENT_TIMESTAMP()) = 45;
> ERROR 1064 (
"Ron McKeever" <[EMAIL PROTECTED]> wrote on 29/04/2005 14:09:38:
> I have a TEXT field in my db (4.0) that has lists of IP numbers; can a
> full-text search be done for IP numbers?
Unfortunately not, because Fulltext regards the dots as terminators. The
IP address 192.168.32.2 will therefore be
"jatwood" <[EMAIL PROTECTED]> wrote on 28/04/2005 22:35:45:
> I am new to MySQL. Please excuse my ignorance if this question has been
> previously discussed. I was not able to
>
> find an answer to my question by searching the archives.
>
>
>
> I have MySQL installed on a dedicated AMD-64 c
MY first guess is that you simply need an ORDER BY field in yout (later,
ad you put it) SELECT.
However, the whole point of using a database such as MySQL is that you do
not worry about how exactly your data is stored. there are many different
tricks that a database can use to optimise both sto
news <[EMAIL PROTECTED]> wrote on 10/05/2005 15:13:49:
> In article <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] writes:
>
> > Hi,
> > Have you forgotten what's a primary key ?
>
> > Using order by will sort data, and if it's already sorted, it willbe
sorted
> > again. Time, memory and maybe disk i
"Scott M. Grim" <[EMAIL PROTECTED]> wrote on 12/05/2005 16:42:00:
> I've fairly extensively (although not necessarily scientifically) tested
> SATA 150 vs. SCSI U320 and find that if you're doing a lot of random
reads
> and writes (such as with a database server), SCSI provides nearly 5x the
Dan Salzer <[EMAIL PROTECTED]> wrote on 16/05/2005 14:36:41:
> I have the following table:
>
> > CREATE TABLE `Article_Search` (
> > `ArticleID` int(11) NOT NULL default '0',
> > `Content` text NOT NULL,
> > PRIMARY KEY (`ArticleID`),
> > FULLTEXT KEY `Content` (`Content`)
> > ) ENGINE=MyISAM DE
Digvijoy Chatterjee <[EMAIL PROTECTED]> wrote on 01/06/2005
17:13:25:
> Hello all,
> My question is if unix Epoch time started on January 1st 1970 ,and
> mysql uses
> the same implementation of time , what is the logic mysql developers
have
> used to offset it by 30 odd years that is the max
Angelo Zanetti <[EMAIL PROTECTED]> wrote on 08/06/2005 17:06:51:
> Hi guys.
>
> I'm having a problem deciding whether a left join is suitable for what i
> want to do.
>
> I have two tables
>
> A Users
> -userID
> -isactive
>
> B BuddyList
> -userID
> -buddyID
>
> what i want to do is to get a
Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
> I need to speed up a search, big time.
>
> I have an application that searches for records on a date field. If it
> doesn't find an exact date match, it keeps searching adjacent days until
it
> finds a certain amount of records.
>
[EMAIL PROTECTED] wrote on 16/06/2005 16:29:46:
>
>
> [EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
>
> > Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
>
> > > I need to speed up a search, big time.
> > >
> > > I have an application that searches for records on a date field
"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 17/06/2005 09:40:39:
> Hi all,
> just want to know if there is a specific number of concorent users
> dat can query from a mysql databasee at d same time.
MySQL has a configurable limit to the number of simultaneous connections
that it can support. Se
Bhartendu Maheshwari <[EMAIL PROTECTED]> wrote on 06/12/2003
14:40:29:
> I know at the time of table creation mysql creates 3 file .frm, .MYD,
> .MYI and is stored in the path given by --datadir=, I want to know
> when I call insert row then where is this data goes I mean in which file
Bhartendu Maheshwari <[EMAIL PROTECTED]> wrote on 07/12/2003
07:56:26:
> I am doing some work in High Availabilty. We have two real servers(just
> 2 PC's) and we want the both PC to run MySQL but uses one common
> database data file. We have one NAS server, we will keep all the data
> file
Matthew Stuart <[EMAIL PROTECTED]> wrote on 05/01/2004 12:49:03:
> I am trying to create a couple of columns (one createddate and one
> updateddate) in a MySQL table that are DATETIME or TIMESTAMP values,
> but I am having trouble understanding how it works. I want both columns
> to auto a
2:34:56:01 into the dictionary as "words". Also, people, for reasons
outside our control, put reference strings into title information which may
contain dashes and underscores, which they would like to search on.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://l
nner. To some extent, it depends uponn your application which is
right: engineering vs. finance.
Your system appears to be showing Windows behaviour. You could, I suppose,
try rebuilding MySQL under Cygwin to get Unis-style behaviour. But this
seems a sledgehammer to crack a nut.
Mike Tuller <[EMAIL PROTECTED]> wrote on 09/02/2004 16:53:00:
> I have posted this question a few times, and have not seen the answer
that I
> need.
>
> I have a shell script, that gathers information from systems, and I want
> that info to be entered into a database. I want it to check fir
Jack Lauman <[EMAIL PROTECTED]> wrote on 11/02/2004 11:47:20:
> I have a table containing information about different businesses. I
> want to randomly select a single row from the table using a prepared
> statement in a java bean.
>
> What is the most eficient way to do this?
Try SELECT
Mark Russell <[EMAIL PROTECTED]> wrote on 16/02/2004 13:41:52:
> What began as a test database server for a web
> developer in one department, has now become a tangled
> web of production databases, test databases, and
> abandoned databases for multiple departments. Of
> course, the only d
I think count(*) is a special case: MyISAM holds a record count which it
can access instantly, InnoDB has to count rows. Does the time difference
persist for real queries?
Alec
Jiří Matějka <[EMAIL PROTECTED]> wrote on 18/02/2004 10:38:13:
> Hi all,
> I'm using mysql 4.0.17 and I ha
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
> I am new to most aspects of MySQL administration so I was wondering
> if someone can help me figure out what GRANTs I need for a
> particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that
> create
"Tim Hayes" <[EMAIL PROTECTED]> wrote on 23/02/2004 16:15:36:
> Can anyone offer advice?
>
> I have come across a MySQL database on Linux with duplicate table
> names - "Accounts" and "accounts". This seems fine on Linux, but
> does not transfer to the Windows environment - it is rejected
>
"Gregorio" <[EMAIL PROTECTED]> wrote on 25/02/2004 15:19:43:
> This is the query i want to run but i doesn't work.
>
> select id from c_table where users_id in (select id from users where
> locations_id=3) order by data_ora
>
> But it gives me this error:
>
> You have an error in your SQL s
Anand Buddhdev <[EMAIL PROTECTED]> wrote on 27/02/2004 11:26:41:
> The problem with first doing a select, and then an insert, is that
> there exists a race condition. Between the select and insert, someone
> else could insert a row which might cause a duplication.
>
> I have another soluti
I have a requirement for a system that is of the order of 8-10 times the
size of my current system. Unfortunately (a) I don't know how many times
larger it actually is, and (b) my current system, while very happy, even
relaxed, on its current hardware, has not yet been subjected to the full
rig
Mark Maggelet <[EMAIL PROTECTED]> wrote on 02/03/2004 19:08:02:
>
> > Scanning a PC manufacturer's website, it seems easy to get 4x2.5GHz
> > Xeon, 1Mb L3, 8Gb ram, dual 15000 rpm Scsi with Raid 1 (for
> > performance as well as reliability).
> >
> > Does this sound balanced for a MySQL eng
> My advice is that in the end, hardware does not matter that much. If
> it solves a
> problem, it solves it until your data outgrows it again, and
> eventually you hit
> your budget limitations and cannot afford an upgrade. Of course, there
are
> certain common sense rules that need to be
"Ranetbauer, Michael" <[EMAIL PROTECTED]> wrote on 03/03/2004
13:40:00:
> I have a table, that has a primary key with two columns and want to add a
> third column to this primary key.
>
> Is this possible and when yes: Do I have to delete all tables, that
It is possible, and you do not have
How about
SELECT * FROM book WHERE book_prg IN (1, 4, 6) ;
Dies that make any difference?
|-+>
| | "Anthony Ward" |
| | <[EMAIL PROTECTED]|
| | r> |
| |
1 - 100 of 298 matches
Mail list logo
