I have a table that I want to insert many rows of information into however it has anautonumber as the primary key. How can I insert 3 columns of data and 20 rows of information into this table in using sql.
Thank you
I have a table that I want to insert many rows of information into however it has anautonumber as the primary key. How can I insert 3 columns of data and 20 rows of information into this table in using sql.
Thank you
INSERT
INTO daTable
( column9
, column3
, column7 )
VALUES
( 'asdf' , 'qwer' , 4567 )
, ( 'fghj' , 'tyui' , 5678 )
, ...
, ( 'vbnm' , 'ghjk' , 0937 )
thanks