Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
mysql copy table1 to table2
samaryan
Programming language:
SQL
2021-04-18 23:11:06
0
Q:
mysql copy table1 to table2
Gabriel
Code:
SQL
2021-06-27 07:47:27
INSERT
INTO
TARGET_TABLE (
`col1_`
,
`col2_`
)
SELECT
`col1`
,
`col2`
FROM
SOURCE_TABLE
WHERE
`foo`
=
1
0
Tags
table
mysql
tab
sql
Related
mysql backup table
mysql alter table add column
mysql alter table column nullable
mysql copy table with new name
alter table add foreign key mysql
mysql dump specific tables
Mysql table variables
mysql update two tables at once
mysql update table from select on another table
alter table add column forigen key mysql
mysql show table structure
create table in mysql mariadb primary key foreign key
mysql show tables in database
get rows from 1 table with other table empty mysql
alter table engine mysql
alter table add column and foreign key mysql
New to Communities?
Join the community