Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Query a mySQL View?
Author: Baz
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231288
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
Author: Ryan Guill
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231284
LOL, I didnt want to be that blunt. But yeah, it sucks.
----- Excess quoted text cut - see Original Post for more -----
--
Ryan Guill
BlueEyesDevelopment
ryanguill@gmail.com
www.ryanguill.com
(270) 217.2399
got google talk? Chat me at ryanguill@gmail.com
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/
Author: Andy Matthews
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231280
Be honest. The mySQL website is a piece of crap.
<!----------------//------
andy matthews
web developer
ICGLink, Inc.
andy@icglink.com
615.370.1530 x737
--------------//--------->
Ah, awesome. Do you know where I could get more information on them?
The MySql website is hard to navigate sometimes...
----- Excess quoted text cut - see Original Post for more -----
Author: Ryan Guill
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231278
Ah, awesome. Do you know where I could get more information on them?
The MySql website is hard to navigate sometimes...
----- Excess quoted text cut - see Original Post for more -----
Author: Rick Root
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231276
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
Author: Ryan Guill
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231274
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,
----- Excess quoted text cut - see Original Post for more -----
Author: Ken Ferguson
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231270
Works fine for me.
--Ferg
Rick Root wrote:
----- Excess quoted text cut - see Original Post for more -----
Author: Rick Root
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231228
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
Author: Les Mizzell
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44461#231224
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
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
