/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

2 votes321 views1 answer
Oracle generated column
SQL
-1 vote372 views5 answers
Left join sql
SQL
1 vote353 views1 answer
Sql server set variable if exists
SQL
3 votes307 views1 answer
Sql replace character in string in all records
SQL
0 vote330 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote307 views1 answer
Get create sql of hibernqte entity
SQL
0 vote280 views1 answer
Full syntax inner join
SQL
0 vote309 views1 answer
User defined variables in sql
SQL
0 vote295 views1 answer
2020 new year
SQL
0 vote338 views1 answer
Cartesian product sql
SQL