/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

3 votes360 views1 answer
Laravel paginate raw sql
SQL
4 votes301 views2 answers
How to delete row in sql
SQL
0 vote317 views1 answer
Mysql jdbc timezone
SQL
1 vote318 views1 answer
Mysql show long running queries
SQL
0 vote419 views1 answer
Run docker container with database as rds metabase
SQL
0 vote336 views1 answer
Transaction database with php
SQL
4 votes321 views2 answers
Postgresql reset sequence
SQL
45 votes398 views5 answers
Grant all privileges mysql
SQL
3 votes309 views2 answers
Mysql time
SQL
0 vote316 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL