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

0 vote375 views1 answer
Tinydb add table
SQL
0 vote364 views3 answers
How to run sql query
SQL
2 votes346 views3 answers
Postgresql reset auto increment
SQL
3 votes375 views2 answers
Laravel tosql with bindings
SQL
0 vote342 views1 answer
Learn sqlite dart
SQL
4 votes333 views2 answers
Xampp mysql database server is not starting mac m1
SQL
12 votes352 views2 answers
Update column data type postgres
SQL
0 vote321 views1 answer
Sql min
SQL
0 vote339 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote356 views2 answers
How do I install microsoft SQL on my Mac?
SQL