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 vote107 views1 answer
SQL division of an integer by another integer get float CAST
SQL
2 votes120 views2 answers
Oracle no data found error code
SQL
0 vote126 views1 answer
Gcloud check sql
SQL
3 votes119 views1 answer
Postgresql cast
SQL
-1 vote115 views1 answer
Add column alter table default value
SQL
0 vote116 views1 answer
Oracle free up space in tablespace
SQL
1 vote123 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote155 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote113 views1 answer
Dnsmasq.conf location macos
SQL
1 vote130 views2 answers
Oracle list service names
SQL