/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 vote157 views1 answer
Time in sql server
SQL
0 vote151 views3 answers
Constraint sql
SQL
1 vote148 views2 answers
Drop table with constraints
SQL
0 vote94 views1 answer
Finish transaction sql
SQL
3 votes135 views1 answer
Pl sql escape &
SQL
0 vote137 views2 answers
Identity column in sql server
SQL
1 vote136 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote147 views1 answer
Postgres format date in select
SQL
4 votes140 views3 answers
Count with where
SQL
0 vote132 views2 answers
Sql server select first day of previous year
SQL