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 vote300 views1 answer
How to set up a trigger in sql
SQL
0 vote266 views1 answer
Denormalise SQL command
SQL
0 vote265 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote296 views3 answers
How to create a table structure from another table in mysql
SQL
7 votes274 views1 answer
Sql server convert string to date
SQL
22 votes258 views6 answers
Create sql table
SQL
6 votes270 views1 answer
Phpmyadmin password root
SQL
0 vote292 views1 answer
Const pool = mysql.createpool()
SQL
0 vote288 views1 answer
Running percentage of total postgres
SQL
0 vote287 views1 answer
Limit in access query
SQL