Answers for "merge multiple tables into single table mysql"

SQL
0

how to combine 2 tables in MySQL

create table yourTableName
(
   select *from yourTableName1
)
UNION
(
   select *from yourTableName2
);
Posted by: Guest on October-20-2020
0

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;
Posted by: Guest on July-03-2020

Code answers related to "merge multiple tables into single table mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language