/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 vote112 views1 answer
Date in where on datetime column clause mysql
SQL
1 vote110 views1 answer
Truncate left characters mysql
SQL
0 vote70 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote121 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote100 views1 answer
Add plugins to mysql workbench
SQL
19 votes107 views5 answers
Date between in mysql
SQL
15 votes227 views2 answers
Sql order by alphabetical
SQL
1 vote112 views1 answer
Timestamp in sqlite
SQL
2 votes111 views1 answer
Oracle list duplicates
SQL
7 votes120 views5 answers
Max 3 salary in sql
SQL