Answers for "how to insert data into multiple tables with usign id using single query in mysql"

SQL
0

insert data into multiple tables mysql

BEGIN;
INSERT INTO users (username, password)
  VALUES('test', 'test');
INSERT INTO profiles (userid, bio, homepage) 
  VALUES(LAST_INSERT_ID(),'Hello world!', 'http://www.stackoverflow.com');
COMMIT;
Posted by: Guest on July-03-2020

Code answers related to "how to insert data into multiple tables with usign id using single query in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language