SQL: Using CONCAT to merge 2 columns, then putting the result into a temp table & column

Question

INSERT INTO #TempTable (Name) 
SELECT CONCAT(FirstName, ' ', LastName) As Name from tbl_name

I've tried to do this in a number of different variations and can't get it to work. Please can somebody assist?

What RDBMS are you using? `CONCAT` is a MySQL function, but `#TempTable` isn't a way to name temporary tables in MySQL. — Barmar, Mar 01 '15 at 22:18
@Barmar Could be [SQL Server](https://msdn.microsoft.com/en-us/library/hh231515.aspx), but you're right, it needs to be clear. — Joachim Isaksson, Mar 01 '15 at 22:20

score 1 · Answer 1 · edited May 23 '17 at 12:03

1

Duplicate of: How SQL query result insert in temp table?

Correct way in mssql:

    DROP TABLE #TempTable;

    SELECT CONCAT(FirstName, ' ', LastName) As Name
    INTO #TempTable
      FROM tbl_name;

    SELECT * FROM #TempTable

[mssql]

Same in mysql:

    DROP TABLE IF EXISTS TempTable;
    CREATE TEMPORARY TABLE TempTable AS (
    SELECT CONCAT(FirstName, ' ', LastName) As Name
    FROM tbl_name);
    SELECT * FROM TempTable;

[mysql] - the "AS" seems to be optional in mysql becase the selection goes automatically to temptable

edited May 23 '17 at 12:03

Community

1
1

answered Mar 01 '15 at 22:24

Tõnu

11
3

Thanks but I need mysql. Any ideas? – helpme Mar 01 '15 at 22:46

score 0 · Answer 2 · answered Mar 01 '15 at 22:47

0

In MySQL, you don't create temporary tables by using #TempTable as the table name, you use CREATE TEMPORARY TABLE

CREATE TEMPORARY TABLE TempTable
SELECT CONCAT(FIrstName, ' ', LastName) AS Name
FROM tbl_name

answered Mar 01 '15 at 22:47

Barmar

596,455
48
393
495

Thanks. How do I get the list of names into the TempTable? – helpme Mar 01 '15 at 23:09
The `SELECT` does that. – Barmar Mar 02 '15 at 01:26

SQL: Using CONCAT to merge 2 columns, then putting the result into a temp table & column

2 Answers2