/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 vote294 views2 answers
Jupyter notebook connect to database
SQL
1 vote334 views1 answer
Metada in sql
SQL
4 votes354 views1 answer
Sql quote in string
SQL
0 vote347 views2 answers
Sql max count
SQL
3 votes358 views2 answers
Mysql user permission database
SQL
0 vote372 views1 answer
Sql quary stuf
SQL
0 vote348 views1 answer
Insert array into mysql column
SQL
0 vote364 views1 answer
Bidirectional outer join sql
SQL
0 vote339 views1 answer
Groupby error in mysql
SQL
1 vote380 views1 answer
Where not in array sql
SQL