/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 vote235 views1 answer
Oracle table free space
SQL
12 votes233 views4 answers
Mysql get date difference in hours
SQL
0 vote232 views1 answer
Php get closest location by latitude longitude
SQL
1 vote237 views2 answers
Mysql between
SQL
2 votes228 views1 answer
While loop sql
SQL
1 vote237 views3 answers
Get all tables postgres
SQL
0 vote215 views2 answers
Find Overlapping sql
SQL
0 vote257 views1 answer
Psql initialization
SQL
0 vote239 views1 answer
Search mysql database for column
SQL
0 vote237 views1 answer
Migrations.RunSQL
SQL