/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

1 vote207 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote204 views1 answer
Oracle stop job
SQL
0 vote197 views1 answer
Mysqlimport
SQL
0 vote207 views1 answer
Sql select lowest value row
SQL
7 votes202 views2 answers
N highest salary in sql
SQL
0 vote215 views1 answer
Name '_mysql' is not defined
SQL
3 votes186 views3 answers
Stop mysql service ubuntu
SQL
13 votes206 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote198 views1 answer
Create table if not exist with exceptions
SQL
0 vote238 views1 answer
How to make sure two tables have same exact data in sql
SQL