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
Post a Comment