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 vote251 views1 answer
Influxdb clone measurement
SQL
12 votes264 views1 answer
Run mysql instance in docker
SQL
0 vote222 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote245 views3 answers
Sql drop all tables
SQL
0 vote260 views1 answer
Sql multiple into
SQL
0 vote258 views1 answer
Example database query
SQL
0 vote267 views1 answer
Sql date with year
SQL
0 vote231 views1 answer
Sql find leading space
SQL
0 vote236 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote240 views1 answer
Drop column from table if exist on live server mysql
SQL