/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 vote188 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote187 views1 answer
Oracle db create new schema
SQL
0 vote270 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote201 views1 answer
Select distinct after join
SQL
1 vote238 views1 answer
Postgresql append array
SQL
0 vote218 views1 answer
How to check default value of column in sql server
SQL
1 vote200 views1 answer
Quit mysql
SQL
0 vote225 views1 answer
Sql insert from excel
SQL
1 vote210 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote214 views1 answer
Delete dublicate rows sql
SQL