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 overhea

group multiple queries.. if one fails all fail

2003-01-23 Thread Ciprian I. Acatrinei
ld 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 thr

group multiple queries.. if one fails all fail

2003-01-23 Thread Ciprian I. Acatrinei
ld 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 thr

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: http://www.mysql.

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 you,

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 p

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: > > *

MySQL vs Microsoft SQL

2001-03-23 Thread Ciprian I. Acatrinei
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I would need some reasons for choosing MySQL instead of Microsoft SQL. (beside the fact that MySQL is free). (not for me but for my boss). It may sound silly but trust me I really need these reasons. So please help