/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 vote181 views1 answer
Vowels in sql
SQL
0 vote184 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote193 views1 answer
Delete record by id sql
SQL
1 vote179 views1 answer
How to delete record sql delphi
SQL
0 vote202 views3 answers
Insert query in ci
SQL
7 votes228 views5 answers
Sql remove spaces
SQL
0 vote213 views1 answer
Remove mysql from centos 7
SQL
0 vote189 views1 answer
Sql remove first character from string
SQL
-2 votes191 views1 answer
Create trigger syntax
SQL
13 votes186 views1 answer
Fetch first 5 rows in oracle sql developer
SQL