I have a list of states in a column and I am wondering if there is a way to upload that file in to phpmyadmin and place them in and use auto_increment so they all wont have the same ID.
Anyway to do this? Instead of entering each one.
Here is what i have in my table:
CREATE TABLE `states` (
`state_name` char(15) default NULL,
`id` int(5) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;