mysql overhead

2003-02-11 Thread Ciprian I. Acatrinei
Hi, I am using PhpMyAdmin and today I got a red message saying that one table has overhead and I need to optimize the table. This is the first time I got this message, I looked online and I understood why it shows. But my question is: can I do something to avoid it? What effects daoe the

group multiple queries.. if one fails all fail

2003-01-23 Thread Ciprian I. Acatrinei
be run? Thank you, -- Ciprian I. Acatrinei [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

group multiple queries.. if one fails all fail

2003-01-23 Thread Ciprian I. Acatrinei
be run? Thank you, -- Ciprian I. Acatrinei [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

unique

2002-10-22 Thread Ciprian I. Acatrinei
Hi, I am having a hard time removing the unique property from a field... I set up a field as unique now I need to allow multiple values in that field. How do I take out the unique property of that field... PS: I couldn't figure it out from http://www.mysql.com/doc/en/ALTER_TABLE.html Thank

Not unique table/alias

2002-10-22 Thread Ciprian I. Acatrinei
Hi, mysql INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1 FROM f_baldai_seq LIMIT 1; ERROR 1066: Not unique table/alias: 'f_baldai_seq' Please help. Thank's. - Before posting, please check:

Relations between tables....

2002-05-21 Thread Ciprian I. Acatrinei
How can I set up mysql so as if the id of an entry from table 1 is inserted in table 2 it will not allow me to delete the information in table 1? EX: table1 holds the description of the products (table1_id is the primary key of the table); table2 holds the information about all the purchased

Re: MySQL vs Microsoft SQL

2001-03-23 Thread Ciprian I. Acatrinei
Is there something that you can do with MS SQL and you can not do with MySQL? At 04:01 PM 3/23/2001, Jeremy D . Zawodny wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote: *This message