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