/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 vote305 views1 answer
Reindex mssql table
SQL
0 vote292 views1 answer
Sql server create constraint
SQL
1 vote281 views1 answer
How to run parallel queries in sql server with entity framework
SQL
13 votes276 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote292 views2 answers
Jsonb
SQL
1 vote297 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
11 votes274 views2 answers
Import sql file laravel cmd
SQL
2 votes270 views1 answer
Import database in mysql command line xampp
SQL
2 votes480 views5 answers
Unique in sql server
SQL
2 votes273 views1 answer
Oracle cpu per session
SQL