/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

36 votes153 views6 answers
Delete from where sql
SQL
1 vote190 views1 answer
Is sql fast
SQL
0 vote177 views1 answer
Oracle insert single quote in string
SQL
0 vote161 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote129 views1 answer
Sql table to store status
SQL
0 vote171 views1 answer
Mysql error 1251
SQL
0 vote160 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote206 views1 answer
Generate random & unique mysql string
SQL
0 vote153 views1 answer
Suse status MySQL
SQL
0 vote156 views1 answer
Mysql 8 geo to json
SQL