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 vote222 views2 answers
Sql if empty then
SQL
0 vote235 views1 answer
Connect by query in oracle
SQL
3 votes267 views2 answers
Truncate table
SQL
1 vote236 views1 answer
Get table column names sql ssms
SQL
0 vote236 views1 answer
Setval in postgres
SQL
5 votes218 views2 answers
Oracle tables with column name
SQL
0 vote268 views1 answer
Traccar mysql
SQL
3 votes220 views1 answer
MySQL DELETE JOIN
SQL
1 vote240 views1 answer
Top 10 rows in mysql
SQL
0 vote232 views1 answer
If column value is null then in mysql
SQL