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

5 votes296 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote323 views1 answer
Delete from inner join sql
SQL
0 vote322 views1 answer
Set column in all row mysql
SQL
2 votes308 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
10 votes318 views1 answer
Oracle dba_dependencies
SQL
2 votes298 views1 answer
Import large .sql files into lampp
SQL
0 vote283 views1 answer
Dump only schema
SQL
0 vote340 views2 answers
Insert data mysql with cmd
SQL
8 votes301 views1 answer
Unique vs primary key
SQL
1 vote308 views1 answer
Cannot drop database because it is currently in use
SQL