Answers for "how to insert data in multiple tables in single query in mysql having foreign keys"

SQL
0

mysql insert into multiple tables

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 November-22-2020
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 in multiple tables in single query in mysql having foreign keys"

Code answers related to "SQL"

Browse Popular Code Answers by Language