Re: Error 1062: Duplicate entry '127' for Key 1

2002-01-17 Thread Thibaut Allender
an index cannot be null you should do this : insert into equipment (id,description) values ('','test data'); regards At 14:27 17/01/2002, you wrote: >database,sql,query,table > >If you just reply to this message, and include the entire text of it in the >reply, your reply will go through. How

Re: Problem with MySQL and SMP?

2002-01-11 Thread Thibaut Allender
> >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be --

RE: 4416 Great Growth Potential 185528

2002-01-10 Thread Thibaut Allender
TED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list a

Re: Spam

2002-01-10 Thread Thibaut Allender
, and watch the fun begin... i won't be there to watch it too long... -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - Before posting, please check: http://www.mysql.com/

RE: scheduling tasks within MySQL

2002-01-10 Thread Thibaut Allender
hp (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- .thibaut allender ~ de

Re: Disable case sensitivity

2002-01-10 Thread Thibaut Allender
. neither TEXT/LONGTEXT -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

order by count

2002-01-09 Thread Thibaut Allender
y" doesn't affect the record set), but keep this order... sort of "order by count(field_to_count grouped)" is this possible ? thanks PS : i'm using mysql 3.23 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2