/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 vote135 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote224 views1 answer
Add user mysql wordpress
SQL
2 votes136 views2 answers
Created at and updated at in mysql
SQL
0 vote141 views1 answer
Null column as zero in mysql
SQL
0 vote140 views1 answer
Sql if else in select
SQL
5 votes133 views1 answer
Mysql select greater than yesterday
SQL
1 vote145 views1 answer
Age postgres
SQL
6 votes151 views3 answers
Date_trunc postgres
SQL
1 vote137 views1 answer
Oracle stop job
SQL
1 vote159 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL