/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 vote274 views2 answers
Sql join on comma separated field
SQL
0 vote284 views1 answer
Insert output identity
SQL
0 vote232 views1 answer
Sql select rows with simlar names
SQL
0 vote265 views2 answers
How to find max and min salary in sql
SQL
1 vote275 views1 answer
Sql avg group by
SQL
11 votes712 views4 answers
Reset identity column values in sql server
SQL
4 votes263 views2 answers
Dbms_scheduler stop job
SQL
4 votes277 views2 answers
Oracle sql group by date year
SQL
0 vote286 views1 answer
Mysql c commands
SQL
0 vote271 views1 answer
Equi joins in oracle
SQL