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

2 votes296 views1 answer
Sql get the name of user pc
SQL
3 votes313 views3 answers
1396(hy00) mysql error
SQL
0 vote298 views1 answer
Replace content value from old to new sql
SQL
8 votes305 views1 answer
How to check mysql version in xampp
SQL
2 votes303 views1 answer
Sql server case sensitive search
SQL
0 vote336 views1 answer
Insert query return id mysql
SQL
0 vote320 views1 answer
Postgresql list extensions
SQL
0 vote263 views1 answer
SQL server select to get sum of hours
SQL
0 vote320 views2 answers
Sql day from datetime
SQL
6 votes318 views4 answers
Mysql update set
SQL