/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 votes131 views2 answers
Sqlserver docker
SQL
11 votes249 views2 answers
Import mysql dump command line windows
SQL
0 vote144 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote122 views1 answer
Myswql show full processlist
SQL
0 vote121 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
1 vote127 views2 answers
Oracle create synonym
SQL
52 votes299 views6 answers
Rename column sql
SQL
0 vote120 views1 answer
Oracle simple quote
SQL
0 vote127 views1 answer
Datagrip exec
SQL
0 vote115 views1 answer
Materialized view redshift
SQL