/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 vote184 views1 answer
How to access to mysql without root
SQL
0 vote198 views1 answer
T sql less than date
SQL
0 vote222 views1 answer
Oracle plsql sleep
SQL
12 votes191 views1 answer
Docker mysql random root password
SQL
14 votes204 views4 answers
Online sql compiler
SQL
3 votes236 views1 answer
Oracle nextval insert
SQL
0 vote230 views1 answer
Mysql case when on date
SQL
3 votes230 views2 answers
Truncate table
SQL
7 votes198 views2 answers
Sql empty table
SQL
20 votes221 views4 answers
Sql count if
SQL