It's probably a tinyint field which won't go higher than 127.
Fred.
On Thu, Jan 17, 2002 at 02:40:54PM +0100, Thibaut Allender wrote:
>
> 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
>
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
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
