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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]