/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

1 vote100 views1 answer
Clear screen command in psql
SQL
0 vote55 views1 answer
Finish transaction sql
SQL
1 vote102 views2 answers
Install mysqldump ubuntu
SQL
0 vote215 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote102 views1 answer
Mariadb datetime change to microseconds
SQL
20 votes106 views5 answers
Mysql reset auto increment to 1
SQL
4 votes113 views2 answers
How to insert ip address in mysql using php
SQL
0 vote96 views1 answer
Mql5 list all available symbols
SQL
0 vote99 views1 answer
Stored function in sql
SQL
0 vote105 views1 answer
Load data from text file to mysql database on mac terminal
SQL