/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

4 votes165 views2 answers
How to insert ip address in mysql using php
SQL
0 vote178 views1 answer
Reset keys in sql
SQL
1 vote160 views2 answers
Sql convert datetime to year month
SQL
0 vote171 views2 answers
Mysql unique two columns
SQL
0 vote169 views1 answer
How to find username and password in oracle 18c
SQL
0 vote198 views1 answer
Mysql range of dates overlap
SQL
0 vote167 views3 answers
Group_concat sql server
SQL
0 vote198 views1 answer
Sql cursor example multiple columns
SQL
0 vote166 views1 answer
Install ms sql server management studio
SQL
-1 vote167 views1 answer
How to check table exists or not in postgresql
SQL