/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

9 votes130 views3 answers
Show table columns mysql command line
SQL
0 vote127 views1 answer
Mysql with
SQL
0 vote142 views1 answer
Mysql select inside sum
SQL
0 vote151 views2 answers
What is the default password for sql server sa
SQL
15 votes140 views2 answers
Select Options
SQL
7 votes132 views1 answer
Sql server convert string to date
SQL
0 vote88 views1 answer
'0000-00-00' for column '
SQL
0 vote145 views1 answer
Empty table sqlite
SQL
0 vote139 views1 answer
Sql add calculated column
SQL
3 votes144 views1 answer
Sql multi column index performance
SQL