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

4 votes181 views2 answers
Truncate oracle
SQL
8 votes200 views3 answers
SQL column name
SQL
0 vote184 views1 answer
Create a table from one field of another table
SQL
4 votes210 views1 answer
List tables sqlite
SQL
0 vote197 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote197 views1 answer
Mysql root permission denied lost
SQL
0 vote191 views1 answer
Pl sql join 3 tables
SQL
3 votes198 views3 answers
Stop mysql service ubuntu
SQL
0 vote194 views1 answer
FIND most frequent word in sql server
SQL
0 vote195 views1 answer
Implicit inner join table alias with id values
SQL