i want insert multiple queries in mysql using php form, in different tables.
like if possible use insert command or this.
provide me best path problem
if mean bulk insert, please follow example given below.
create table example ( example_id int not null, name varchar( 50 ) not null, value varchar( 50 ) not null, other_value varchar( 50 ) not null ) insert example values (100, 'name 1', 'value 1', 'other 1'), (101, 'name 2', 'value 2', 'other 2'), (102, 'name 3', 'value 3', 'other 3'), (103, 'name 4', 'value 4', 'other 4'); or
if want insert data multiple table, solution given below right, write queries each table.
note: insert statement written once, repeating value.
Comments
Post a Comment