DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
mysql copy table1 to table2
INSERT
INTO
TARGET_TABLE
(
`
col1_
`
,
`
col2_
`
)
SELECT
`
col1
`
,
`
col2
`
FROM
SOURCE_TABLE
WHERE
`
foo
`
=
1
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#mysql
#copy
ADD COMMENT
Topic
COMMENT
Name
3+8 =
Submit