Use of declared variable in select statment

Question

I am trying to execute below query but mysql says Syntax error: unexpected '@my_var' (at text suffix)

SET @my_var = 1;
INSERT INTO table1(id, myvar)
SELECT * FROM (LAST_INSERT_ID(), @my_var) AS tmp

How can I use declared variable in above query?

The syntax of your SELECT statement appears to be off. There is no table name after the FROM keyword. — Tim Biegeleisen
– Tim Biegeleisen, Commented Dec 10, 2015 at 5:46
@TimBiegeleisen It is valid. If I feed static value instead of @my_var it works. e.g. SELECT * FROM (LAST_INSERT_ID(), 1) AS tmp but I need to feed dynamic value using variable. — Nitesh Virani
– Nitesh Virani, Commented Dec 10, 2015 at 5:49

Ganesh Wankhedkar · Accepted Answer · 2015-12-10 05:51:51Z

1

What you want to select, that you have putted in FROM.

In FROM there must be a table_name and not a column_name or function call.

answered Dec 10, 2015 at 5:51

Ganesh Wankhedkar

363 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I just forgot to put SELECT, so the correct way is like this SELECT * FROM (SELECT LAST_INSERT_ID(), @my_var) AS tmp silly me!