/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

2 votes191 views1 answer
How to delete view in sql
SQL
0 vote158 views1 answer
Copy data from cell to cell mysql
SQL
1 vote212 views1 answer
Sql select whole row max column
SQL
0 vote222 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote219 views1 answer
Oracle string length
SQL
0 vote226 views1 answer
Flask sqlalchemy session delete
SQL
-1 vote227 views2 answers
Sql truncate number
SQL
0 vote182 views2 answers
Get top 1 row of each group
SQL
0 vote192 views1 answer
Mysql create table columns with spaces
SQL
1 vote185 views1 answer
How to delete a record from sqlite in android
SQL