/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

1 vote172 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
25 votes198 views6 answers
How to change column name in mysql
SQL
8 votes171 views1 answer
Oracle find text in functions
SQL
0 vote171 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote167 views1 answer
C# mysql update statement set value to null
SQL
1 vote224 views1 answer
Select not matching data with join table
SQL
2 votes225 views1 answer
Mariadb json select
SQL
0 vote173 views1 answer
How to insert a uniqueidentifier in sql
SQL
15 votes178 views2 answers
How to know the username of postgresql
SQL
2 votes162 views1 answer
Postgresql left join distinct on
SQL