/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 vote331 views2 answers
Mysql dump structure only
SQL
2 votes344 views1 answer
Oracle sql merge
SQL
4 votes281 views1 answer
Oracle sleep
SQL
0 vote323 views1 answer
Procedures sql insert mysql
SQL
0 vote330 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote339 views1 answer
Mariadb current date plus 1 day
SQL
2 votes349 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote313 views1 answer
Oracle start job
SQL
0 vote330 views1 answer
Horizontal join sqlite
SQL
0 vote362 views1 answer
How to check database engine in mysql
SQL