The manual is your friend.
You cannot execute the SQL statement you provided because mysql specifically disallows it:
Same reference, your presumption about auto-increment columns is also wrong.
blackwater dev wrote:
I want to create a new row in the db by copying an existing one. My
db has an auto incrementing id so I can't simply do insert into cars
select * from cars where id=$id as this throws the primary key error. How can I do this with out specifying each column?
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php