auto increment field type
Posted 05 May 2003 - 08:01 AM
I know this is a very simple question but I could not find (or just didn\'t look long enough) the answer. when creating a table, what is the column type for a field that is automaticaly incremented when not explcitly named in an insert statement? I plan to use this field as a primary key. Thanks for your help!! Yes, I am new to mysql!
Posted 05 May 2003 - 08:15 AM
sometimes BIGINT if you need a lot of records...
Posted 05 May 2003 - 08:36 AM
Posted 06 May 2003 - 07:42 AM
Here is a table for files:
CREATE TABLE files ( ID int(15) NOT NULL auto_increment, path varchar(255) NOT NULL default \'\', filename varchar(255) NOT NULL default \'\', contents blob NOT NULL, PRIMARY KEY (ID) ) TYPE=MyISAM;
ID is auto incrementing...
Posted 06 May 2003 - 09:05 AM
Posted 08 May 2003 - 08:36 AM
refers to the last inserted ID in the auto_increment field.... It\'s thread specific, meaning that if 15 users are connected at the same time, mysql_insert_id will return the correct value to each user (or rather the script he is running (or she)).
Look in the php manual for help on this, it\'s quite easy.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users