mysql - Set SQL field value equal to other field value on insert -


i want insert table structure this:

id | client_id | name | description | … 

id auto increment primary. client_id can appear multiple times multiple versions.

how can set client_id on insert statement same - in statement - auto generated primary id?

something this:

insert clients set client_id=id, name='test', description='yada' 

use insert .. select from construct below (better use where condition)

insert clients (client_id , name , description) select id, 'test', 'yada' your_table id = 1234; 

Comments