/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 vote291 views1 answer
SQL add a totals of differemt rows of the same id
SQL
7 votes344 views1 answer
Buy forge mods server hosting
SQL
32 votes308 views6 answers
Sql count where
SQL
0 vote247 views1 answer
Connection error in mysql workbench
SQL
4 votes312 views1 answer
Conda install sqlalchemy
SQL
0 vote306 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote310 views1 answer
Ansi sql count duplicate rows
SQL
0 vote304 views1 answer
Sqlalchemy query sql compiled
SQL
-1 vote278 views1 answer
How to use update trigger in sql
SQL
0 vote312 views1 answer
SQL column name Oracle
SQL