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 vote205 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
2 votes241 views1 answer
Coalesce sql
SQL
0 vote191 views1 answer
Mysql percentage of total
SQL
0 vote198 views1 answer
Sql select inside select sub query
SQL
0 vote222 views1 answer
Find how many tables in database sql query
SQL
2 votes222 views1 answer
Show max_allowed_packet mysql
SQL
8 votes206 views1 answer
Script to add datafile to tablespace
SQL
3 votes202 views1 answer
Mysql load sql from file
SQL
10 votes213 views1 answer
Oracle view dependencies
SQL
0 vote194 views1 answer
What alter does in db
SQL