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

1 vote221 views1 answer
Mysql show database size in mb
SQL
0 vote219 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote210 views1 answer
What is the use of index in mysql table
SQL
0 vote243 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote219 views1 answer
Sql server isnull function nor working count
SQL
3 votes220 views2 answers
How to load files in mysql
SQL
0 vote203 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
1 vote225 views2 answers
Oracle list service names
SQL
6 votes231 views3 answers
How to delete table sqlite
SQL
1 vote224 views2 answers
Postgresql remote connect
SQL