MySQL Forums
Forum List  »  Newbie

Re: Need Help W/ Query
Posted by: Peter Brawley
Date: May 23, 2012 03:43PM

> There's GOT to be a for statement or something that can do what I need.

No, in SQL there has not got to be such a 'for' statement. SQL is not meant to be a complete computer language. It's just a set-based query language for data that follows the design rules set out by EF Codd about forty years ago.

If you want to keep that un-normalised design, you will have to write procedural code, either in MySQL stored procedures (awkward and slow) or in an application language.

PB



Edited 1 time(s). Last edit at 05/23/2012 04:11PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
May 22, 2012 03:15AM
May 22, 2012 03:47AM
May 22, 2012 07:36AM
May 22, 2012 06:08AM
May 23, 2012 02:37PM
Re: Need Help W/ Query
May 23, 2012 03:43PM
May 23, 2012 05:35PM
May 26, 2012 11:26PM


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.