Database IDs

2005-11-10 Thread Robert Crowell
Hello, If I am relying on MySQL's AUTO_INCREMENT feature for the id for a table, how can I reliably retrieve the ID of an item I just entered into the database? For instance, I have a table that stores first names, and has an id field that is generated via AUTO_INCREMENT. However, this id will

NULL and database size

2005-08-19 Thread Robert Crowell
I have data from two different sources that I would like to store in a mysql database. Dataset_1 has pieces of information A, B, and C (let's say first, middle, and last name) and Dataset_2 has pieces of information A, B, C, and D (first, middle, last names and a DOUBLE value). Dataset_1 has 9.5