/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 vote274 views1 answer
Mariadb search columns
SQL
0 vote313 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote286 views1 answer
How to select only a certain date sql
SQL
0 vote258 views1 answer
Oracle index hint
SQL
2 votes257 views1 answer
Create table with primary key
SQL
0 vote287 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote307 views1 answer
Wordpress make wp user in db
SQL
4 votes252 views2 answers
DB::transaction
SQL
2 votes266 views4 answers
Duplicate record mysql
SQL
17 votes248 views6 answers
Sql current date
SQL