Re: Query a mySQL View?
Works fine for me. --Ferg Rick Root wrote: Les Mizzell wrote: Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW That's the way it's supposed to work. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? Thanks, On 2/3/06, Ken Ferguson [EMAIL PROTECTED] wrote: Works fine for me. --Ferg Rick Root wrote: Les Mizzell wrote: Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW That's the way it's supposed to work. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? A view is sort of like a table, except that is is actually a query. You sometimes use views to simplify complex joins. Like if you commonly join 5 tables, your sql query might get exceptionally complicated. But you could create a view, and query it as if it were one table instead of 5... create view myView as SELECT A.field1, A.field2, B.field3, B.field4 FROM table1 A inner join table2 B on A.id=b.id; select * from myView where field1 = 3 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root [EMAIL PROTECTED] wrote: Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? A view is sort of like a table, except that is is actually a query. You sometimes use views to simplify complex joins. Like if you commonly join 5 tables, your sql query might get exceptionally complicated. But you could create a view, and query it as if it were one table instead of 5... create view myView as SELECT A.field1, A.field2, B.field3, B.field4 FROM table1 A inner join table2 B on A.id=b.id; select * from myView where field1 = 3 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query a mySQL View?
Be honest. The mySQL website is a piece of crap. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:29 PM To: CF-Talk Subject: Re: Query a mySQL View? Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root [EMAIL PROTECTED] wrote: Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? A view is sort of like a table, except that is is actually a query. You sometimes use views to simplify complex joins. Like if you commonly join 5 tables, your sql query might get exceptionally complicated. But you could create a view, and query it as if it were one table instead of 5... create view myView as SELECT A.field1, A.field2, B.field3, B.field4 FROM table1 A inner join table2 B on A.id=b.id; select * from myView where field1 = 3 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
LOL, I didnt want to be that blunt. But yeah, it sucks. On 2/3/06, Andy Matthews [EMAIL PROTECTED] wrote: Be honest. The mySQL website is a piece of crap. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:29 PM To: CF-Talk Subject: Re: Query a mySQL View? Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query a mySQL View?
The best thing to do with the MySQL site is search it through google: views site:http://dev.mysql.com/doc/refman/5.1 Then it becomes awesome again ;-) Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Les Mizzell wrote: Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW That's the way it's supposed to work. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54