/SQL/Insert data into multiple tables mysql

Insert data into multiple tables mysql

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;

Source: stackoverflow.com

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;

Source: stackoverflow.com

Similar codes

5 votes240 views1 answer
Oracle asynchronous procedure
SQL
0 vote286 views1 answer
What is delimiter in mysql
SQL
0 vote252 views1 answer
Sql server remove enter from string
SQL
0 vote278 views1 answer
How to define a non primary composite key in sql
SQL
0 vote252 views1 answer
Set mysql socket file docker windows
SQL
2 votes278 views1 answer
Mysql id of inserted row
SQL
1 vote249 views1 answer
How to check the mysql version mac
SQL
9 votes273 views5 answers
Laravel to sql
SQL
0 vote268 views2 answers
Dbms interview questions
SQL
25 votes269 views3 answers
How to use a database to see tables mysql
SQL