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 vote161 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote145 views1 answer
How to use sqlcommand
SQL
1 vote139 views1 answer
How to get mysql db size
SQL
1 vote159 views1 answer
Sqlite3 read only
SQL
6 votes136 views1 answer
Rank function in oracle with example
SQL
0 vote176 views1 answer
Order child below the parent in mysqli
SQL
16 votes181 views3 answers
Order by sql query
SQL
13 votes144 views4 answers
Mysql select last 10 rows
SQL
0 vote196 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote170 views1 answer
Sql tablo sp
SQL