/SQL/Insert data into multiple tables mysql

Insert data into multiple tables mysql

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 vote351 views1 answer
How to fetch data from database in sql
SQL
1 vote295 views1 answer
Python escape string for sql
SQL
5 votes331 views1 answer
Oracle list days between two dates
SQL
-1 vote311 views1 answer
Su: Authentication failure mysql
SQL
0 vote324 views1 answer
Java nosql sort
SQL
1 vote321 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote306 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote307 views1 answer
Get server date mysql
SQL
2 votes327 views2 answers
Sql query to copy data from one column to another
SQL
0 vote302 views2 answers
How to save result of sqlite query in a table
SQL