Inserting auto_number another column

Asked Mar 17 '14 at 20:21

Active Mar 17 '14 at 20:21

Viewed 36 times

I have a table like this

MessageID (autonumber), ParentMessageID, Message, User

I would like to create a SQL INSERT query that will populate ParentMessageID with the same result as MessageID.

Can this be done in one query instead of using server side coding to insert the first row and then update the record with the ParentMessageID.

asked Mar 17 '14 at 20:21

InvalidSyntax

By `auto_number` I assume you mean `auto_increment` – Mike Dinescu Mar 17 '14 at 20:24
1

Please see http://stackoverflow.com/questions/7344587/making-another-mysql-auto-increment-colomn – Justin E Mar 17 '14 at 20:27
You can also use a [Trigger](http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html) to update the ParentMessageID and set it equal to MessageID – Justin E Mar 17 '14 at 20:30
1

From the MySQl forum: `http://forums.mysql.com/read.php?99,186171,186171` a Trigger was used – Sourav 'Abhi' Mitra Mar 17 '14 at 20:31
possible duplicate of [MySQL trigger to update a field to the value of id](http://stackoverflow.com/questions/1211792/mysql-trigger-to-update-a-field-to-the-value-of-id) – Bill Karwin Mar 17 '14 at 20:37

0 Answers0