Let's say you have this table, pseudo-coded:

TABLE table
   tableid int auto_increment,
   value text
;

You could run this query on it:

insert into table values ('','value');

And the id will be auto generated. Same would apply with:

inert into table (value) values ('value');

Mike


Phil Schwarzmann wrote:
> Okay, so when I INSERT a row of information into a MySQL database, I
> don't want it to place it at the first empty row it finds....I want it
> to put it after the very last exsisting row.
> 
> One of the fields of the database is an AUTO_INCREMENT type, so Im
> assuming Im gonna use that in the query.
> 
> How would I write a query to do this??
> 
> THANKS!!!!!!!!!!!!!!!!!!!!!!
> 
> 


-- 
At no time is freedom of speech more precious than when a man hits his
thumb with a hammer.
                -- Marshall Lumsden


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to