/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 vote352 views1 answer
Hue hive UploadingTextFiletoHive
SQL
4 votes209 views2 answers
Postgresql default value
SQL
8 votes206 views2 answers
Alert table name mysql
SQL
0 vote258 views1 answer
Check database restore status sql script
SQL
0 vote257 views2 answers
Mysql cast to varchar
SQL
0 vote184 views1 answer
Import sql file in mysql linux
SQL
0 vote204 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
5 votes211 views2 answers
To date oracle
SQL
0 vote216 views1 answer
Postgresql linux password
SQL
0 vote203 views1 answer
SAP Return
SQL