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 vote178 views2 answers
One to one and one to many relationship
SQL
0 vote185 views1 answer
Update database collation in postgresql
SQL
1 vote181 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote186 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote171 views1 answer
Load data from text file to mysql database on mac terminal
SQL
-2 votes174 views3 answers
Oracle tablespace usage
SQL
4 votes156 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
7 votes186 views2 answers
Html to react converter
SQL
3 votes184 views2 answers
Mysql select database
SQL
3 votes175 views1 answer
Oracle list dates without weekends
SQL