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 vote284 views1 answer
Oracle stop
SQL
0 vote276 views1 answer
Postgresql not in alternative
SQL
4 votes357 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote276 views1 answer
Postgress append string in select
SQL
3 votes251 views1 answer
Get all elements sql
SQL
0 vote292 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote288 views1 answer
Oracle current timestamp insert statement
SQL
4 votes285 views4 answers
Oracle tablespace tables list
SQL
0 vote292 views1 answer
Top 3 salary in sql
SQL
0 vote247 views1 answer
Mysql sleep connections
SQL