Hello,
When I submit data it will not submit data into the
database unless I put some kind of number in the ID
field. This is not supose to be. Here is what my
schema looks like.
CREATE TABLE Parts(
PartNumber INT(6) NOT NULL,
QtyOnHand INT(2) NOT NULL,
QtyOnOrder INT(2) NOT NULL,
DateNextQtyComplete VARCHAR(10) NOT NULL,
StatusQtyWorked VARCHAR(10) NOT NULL,
ID INT(5) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ID)
);
Does anyone know why the auto_increment doesn't work?
I'm using mysql Ver 8.0 Distrib 3.22.32, for
pc-linux-gnu on i686
Thanks you
--Mike
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
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
