I am new to MySQL. My question is similar to this one, but the answer given over there is based on a subquery. As a Microsoft Access user I'd like to know if you can have query definitions in your database that you can use in the joins of an sql statement, just the way you are using tables. My provider mentioned stored procedures, but after some quick research I wonder if this is the same thing. Isn't a stored procedure more like a user defined function that you can use in your sql statement?
Asked
Active
Viewed 46 times
0
-
4What you're looking for is views. https://dev.mysql.com/doc/refman/8.0/en/views.html – Barmar Nov 04 '19 at 22:12
-
That is probably just what I was looking for! – esims Nov 04 '19 at 22:29
-
It is. It's just different terminology but the same concept – ADyson Nov 04 '19 at 23:18
-
If Barmar's comment had been given as an answer, I could mark it as answer and close this question. – esims Nov 05 '19 at 00:47
1 Answers
0
Barmar's comment here was just what I needed:
What you're looking for is views. dev.mysql.com/doc/refman/8.0/en/views.html
Wai Ha Lee
- 8,598
- 83
- 57
- 92
esims
- 327
- 3
- 18