/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

8 votes160 views5 answers
Grant permission in postgres
SQL
0 vote203 views1 answer
Check command
SQL
0 vote163 views2 answers
Create new table plsql
SQL
0 vote168 views1 answer
Dbms_output sql developer
SQL
21 votes167 views6 answers
Change column in mysql
SQL
4 votes158 views1 answer
Oracle session date format
SQL
0 vote179 views1 answer
Oracle table privileges
SQL
11 votes164 views3 answers
Sqlite3 create table from another table
SQL
7 votes137 views1 answer
Alter table add key sql
SQL
6 votes178 views2 answers
Foreign key sqlite3 python
SQL