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. However, you should
>first review the text of the message to make sure it has something to do
>with MySQL. Just typing the word MySQL once will be sufficient, for example.
>
>You have written the following:
>
>insert into equipment (id,description) values (null,'test data');
>
>returns the error message in the subject line. I've tried the obvious stuff
>like deleting the record with id=127 in. The id field is auto_increment,
>btw. I'm sure it's something obvious...
>--
>Gary Smith - [EMAIL PROTECTED]
>Web: http://www.l33t-d00d.co.uk
>Pics: http://photos.l33t-d00d.co.uk
>Webcam: http://webcam.l33t-d00d.co.uk
>
>--
>Gary Smith - [EMAIL PROTECTED]
>Web: http://www.l33t-d00d.co.uk
>Pics: http://photos.l33t-d00d.co.uk
>Webcam: http://webcam.l33t-d00d.co.uk
>
>---------------------------------------------------------------------
>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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>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 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