Copying data into differently named columns in another SQL table

Question

I want to copy data from one table into another table where the columns have different names, and am trying to use the following

SELECT `content` AS `name`, `id` AS `orig_id` 
INTO `songs`
FROM `items` 
WHERE `categories` LIKE "%30%"

It doesn't work. How should I go about achieving this?

What does "it doesn't work" mean, exactly? Were there error messages? Was there unexpected output? — , Oct 21 '11 at 18:24

score 4 · Accepted Answer · answered Oct 21 '11 at 18:24

4

You can specify the columns of the destination table as part of the INSERT syntax as shown below.

INSERT INTO songs
    (name, orig_id)
    SELECT content, id
        FROM items
        WHERE categories LIKE '%30%'

answered Oct 21 '11 at 18:24

Joe Stefanelli

score 0 · Answer 2 · edited Jul 19 '12 at 07:45

0

For SQL :

select 
    name as cus, activator as act 
into dbo.pc1
from dbo.Pc

edited Jul 19 '12 at 07:45

Taz

answered Oct 21 '11 at 19:35

user009

score 0 · Answer 3 · answered Oct 21 '11 at 20:37

0

SELECT INTO is T-SQL syntax.

For MySQL you'd use:

CREATE TABLE songs 
SELECT 
  content AS name
  , id AS orig_id 
FROM items 
WHERE categories LIKE '%30%'

answered Oct 21 '11 at 20:37

Johan

3 Answers3