Possible Duplicate:
Mysql mulitple row insert-select statement with last_insert_id()
Is there a possibility to get the last_inserted_ids ?
mysql> CREATE TABLE employee (
    ->      id MEDIUMINT NOT NULL AUTO_INCREMENT,
    ->      name CHAR(30) NOT NULL,
    ->      PRIMARY KEY (id)
    ->  );
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> INSERT INTO employee (name) VALUES ('A'),
    ->                                    ('B'),
    ->                                    ('C'),
    ->                                    ('D'),
    ->                                    ('E'),
    ->                                    ('F');
Now how can I get the ids of 'A', 'B', 'C' ... ? Does MySQL offer me a simple way to do this ? like it does with one row
SELECT LAST_INSERT_ID();
 
    