MySQL Forums
Forum List  »  Stored Procedures

Re: insert extra rows(s) in a SELECT statement
Posted by: Mike Cook
Date: February 17, 2012 05:12AM

Thanks for your suggestion Irek. That's sort of what I had in my own mind for handling this. I was hoping there might be a more "dynamic" option that didn't involve creating a secondary table though. While my example was simple, in reality the table is quite large (~20k records inserted per day).

Also, to refer back to my example, technically the value "b" for "2012-02-15 02:00:00" isn't real - so while I want to show it temporarily in some queries, I'd rather not have it stored in the DB itself so as to not confuse the fact that it doesn't really exist.

Perhaps the easiest solution is to manipulate the data outside of the database (say via PHP/ASP for a web-based display) rather than through the query itself

Options: ReplyQuote


Subject
Views
Written By
Posted
2200
February 15, 2012 10:43AM
Re: insert extra rows(s) in a SELECT statement
877
February 17, 2012 05:12AM


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.