How to insert multiple auto-increment lists into MySQL db?

[tangrisser]

Hello.

I'm a PHP n MySQL n00b learning..so if you don't understand what I'm trying to do..
Ask me again, so I can try to explain in more clear manner. Thank you for your help, in advance.

i would like to have a set of list within a table like this:


list a
-1
-2
-3
-4

list b
-1
-2
-3
-4


with the numbers on auto_increment, or is this not possible?

[Spock]

While I cannot answer your question for you, I was able to change the topic title so others will have a better idea what you wish to know before opening the topic. Hope you get the help you desire soon. :)