MySQL Forums
Forum List  »  Newbie

Re: SQL statement directly in tables
Posted by: Andrew Gilfrin
Date: August 16, 2005 07:43AM

Felix is correct, the point is that you need to look at a database in a slightly different way.

It's really in 2 parts, the data which is stored in the tables in basically a raw format. And then the SQL you use to view that data, it's the SQL layer that you need to be doing these sort of things (mainly because thats the most efficient way to do it).

Many developers "select * from " to be the only SQL statement available, you need to be a little more elegant than that. Just do the calculation in the SQL statement when you need it.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Written By
Posted
August 16, 2005 02:45AM
Re: SQL statement directly in tables
August 16, 2005 07:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.