Undeclared variable error

Question

Undeclared variable error

penguinspeaks (TechnicalUser)

(OP)

10 Feb 19 19:23

Hello. I am hoping is a simple answer to this because I have not come across it before.
I have run similar code many times but now getting an error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.6.33-log]Undeclared variable: BRACKET16_73

/start1.asp, line 51

CODE -->

SQL = "SELECT * INTO BRACKET16_"&IDT&" FROM BRACKET16_TEMP"
CONN.EXECUTE(SQL)

When I run response.write it displays perfectly.

CODE -->

SELECT * INTO BRACKET16_73 FROM BRACKET16_TEMP

Please help me understand what variable could be undeclared or why I am seeing this error.

Thanks,
Penguin

Olaf Doschke (Programmer) · Answer 1 · 2019-02-10 19:57:58

Well, MySQL is telling what it doesn't interpret as a table name: BRACKET16_73

If you want to create a new table look at this:
https://stackoverflow.com/questions/16809393/selec...
or more direct in the MySQL reference:
https://dev.mysql.com/doc/refman/8.0/en/create-tab...

In short, the syntax in MySQL is

CODE

CREATE TABLE BRACKET16_73 AS SELECT * FROM BRACKET16_TEMP;

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

penguinspeaks (TechnicalUser) · Answer 2 · 2019-02-10 22:18:44

I was under the impression that a select into created the table.
Is this not correct??

Thanks,
Penguin

penguinspeaks (TechnicalUser) · Answer 3 · 2019-02-10 22:50:19

I did use your suggestion and it now works perfectly.
Thanks for the help and reply.

Thanks,
Penguin

Olaf Doschke (Programmer) · Answer 4 · 2019-02-10 23:05:13

Well, SQL isn't SQL and within MySQL just look at the reference about SELECT INTO:
https://dev.mysql.com/doc/refman/8.0/en/select-int...

The target is never a new table, it's a variable list, a file (TXT/CSV) or a dumpfile, but not a new table.

And if you have an existing table the command also is vice versa, the overall is an INSERT INTO then, and the SELECT as the source of data still comes afterwards:

CODE

INSERT INTO BRACKET16_73 SELECT * FROM BRACKET16_TEMP;

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

Come Join Us!

Posting Guidelines

Undeclared variable error