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 vote363 views1 answer
Query builder doctrien return sql
SQL
2 votes334 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote348 views1 answer
Oracle 11g forget password
SQL
5 votes332 views1 answer
Commentaire table oracle
SQL
0 vote330 views1 answer
Mysql find missing values
SQL
0 vote309 views1 answer
Create column that already exists mysql
SQL
0 vote340 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote340 views1 answer
Psql attribute cannot login
SQL
0 vote339 views1 answer
Oracle date winter time
SQL
2 votes325 views1 answer
Merge two columns in sql oracle
SQL