On Thu, 31 Jan 2002, Charitha wrote: > > I want to know how to create a table with an autoincrement field in that > along with a name field with the varchar datatype. >
create table MySimpleTable ( id integer not null primary key auto_increment, name varchar(32) not null ); See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.html --------------------------------------------------------------------- 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