Oops, forgot ',' at the end of the 3rd line. > Try this: > > CREATE TABLE tablename ( > `id` mediumint(9) NOT NULL auto_increment, > `name` varchar(50) NOT NULL default '' > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1; > >> Greetings, >> >> I have a bunch of names and addresses that I am adding to MySql >> database. I would like to automatically assign a unique sequence >> number to each person. Is there a way to do this easily? >> >> id name >> 1 bob jones >> 2 larry smith >> 3 henry rogers >> >> >> >> >> Thanks for you help, >> >> Joe. >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> > > > -- > Master of Applied Computer Science > Faculty of Computer Science > Dalhousie University > Halifax, Nova Scotia > Canada > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
-- Master of Applied Computer Science Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
