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 vote181 views1 answer
Postgresql filter on
SQL
0 vote167 views1 answer
Not between mysql
SQL
0 vote177 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
12 votes160 views3 answers
Duplicate a column in sql
SQL
0 vote169 views1 answer
Flexible search query delete table
SQL
2 votes164 views1 answer
Change primary key sql
SQL
3 votes181 views1 answer
Select table column in sql
SQL
0 vote189 views1 answer
Datagrip go to line
SQL
0 vote166 views1 answer
Ffeathers express mysql application users login
SQL
0 vote155 views2 answers
Mysql regexp match word
SQL