/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 vote110 views1 answer
Oracle free up space in tablespace
SQL
23 votes124 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote117 views1 answer
Pl sql round
SQL
3 votes143 views1 answer
Apex set debug level
SQL
15 votes141 views4 answers
Mysql export database command line
SQL
1 vote111 views1 answer
Mysql select row with max value group by
SQL
8 votes117 views3 answers
Oracle auto_increment
SQL
0 vote245 views1 answer
Sql change a colum to unique
SQL
0 vote129 views3 answers
Magento 2 order delete from db
SQL
4 votes116 views2 answers
Oracle set date format
SQL