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

0 vote131 views1 answer
How to install postgresql on wsl
SQL
0 vote131 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
10 votes137 views2 answers
Sql rtrim
SQL
3 votes81 views2 answers
Mysql sum with condition
SQL
0 vote131 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote125 views1 answer
Sql database connectivity
SQL
0 vote181 views1 answer
T-sql delete view if exists
SQL
0 vote132 views1 answer
Get week day name sql server
SQL
0 vote157 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
5 votes135 views1 answer
Ascending order and where in sql
SQL