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.

Re: Problem with MySQL and SMP?

2002-01-11 Thread Thibaut Allender
(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 ~ dev:network. @ magic:sq. .tel. : +32 2

Re: Disable case sensitivity

2002-01-10 Thread Thibaut Allender
-- .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.com/ (the list archive

RE: scheduling tasks within MySQL

2002-01-10 Thread Thibaut Allender
/unsubscribe.php -- .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.com

Re: Spam

2002-01-10 Thread Thibaut Allender
you must include one of the following words in your message: database,sql,query,table Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... i won't be there to watch it too long... -- .thibaut allender

RE: 4416 Great Growth Potential 185528

2002-01-10 Thread Thibaut Allender
/ (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 ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be

order by count

2002-01-09 Thread Thibaut Allender
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 / 209 83 71 ~ http://magicsquare.be