I have a table, and I want to insert the data:
Name Type (so that's Name, then two spaces, then type)
However, my table has more than two kinds of data (such as id auto increment, location, etc) ... but I want it to autoincrement for id, and leave the other values blank. What's the best way to do this? here's an example:
CREATE TABLE `people` (
`id` int(3) NOT NULL auto_increment,
`name` var(50) NOT NULL.
`type` varchar(100) NOT NULL,
`location` varchar(500) NOT NULL,
And I have the following data:
Albert Cool
Joanne Lazy
Jim Bored
So: insert into `people` (x, albert, cool, blank) ... etc. So in the end, I want to convert Albert Cool into the insert into, then process it into the database with x increasing everytime for the person, however leaving location blank. I'm sorry if it confuses you. How would I do this? Thanks.