how can I use mysql variable for my sql?

Question

how can I use mysql variable for my sql? sometimes I have to write some very long sql joining several tables to get results. I want to set some vars to shorter my main sql, how to set vars in mysql?

// this is the normal sql
select 
    a.name,a.money,b.mail
from
    (select name, sum(money) from moneys group by name) as a  
    left join (select name ,email from persons) as b on a.name = b.name


// I want to using variable to make my sql shorter and easy to understand, how to write?
select 
    a.name,a.money,b.mail
from
    var_a  
    left join var_b

Try reading on using SQL Views for your problem. You can parse your select query into a view and use the view to join as a normal table — ReubenTellis
– ReubenTellis, Commented Nov 13, 2013 at 2:33

user1932079 · Accepted Answer · 2013-11-13 02:26:05Z

1

Not to be rude, but this one comes up pretty easily from some searches... all leading to the MySQL manual page: http://dev.mysql.com/doc/refman/5.7/en/user-variables.html

Not sure what you were searching on, but hope that helps... it has examples and all.

answered Nov 13, 2013 at 2:26

user1932079

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

Collectives™ on Stack Overflow

how can I use mysql variable for my sql?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related