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

5 votes103 views1 answer
Oracle ora-00054 causes
SQL
4 votes128 views4 answers
Remove duplicate old value in mysql
SQL
0 vote124 views1 answer
Selecting all columns from table sql database
SQL
11 votes113 views1 answer
Creating tables in sql with python
SQL
0 vote115 views1 answer
How to install Firebird
SQL
0 vote103 views1 answer
Null column as zero in mysql
SQL
0 vote122 views2 answers
PostgreSQL having
SQL
0 vote111 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote103 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote94 views1 answer
List mysql tables and views
SQL