How to copy an auto-increment id to another field of an inserted record?

Question

MySQL

records are displayed on the page sorted by `cat_order`
users can change `cat_order` of neighboring records in order to set the desired order of output it is
necessary that when creating a new record `cat_order` contain the same number as in the auto-increment field `cat_id`
copy in the insert query and not after if not clear

Answer 1

RTFM https://dev.mysql.com/doc/refman/5.7/en/informatio...