MySQL Forums
Forum List  »  Views

Re: variable rows to columns in a dynamic view
Posted by: Devart Team
Date: June 17, 2011 12:40AM

Check generated SELECT statement, e.g. -

...
SET @sql = CONCAT('SELECT muestras.*, muestrasbase.*', pcols, ' ',...
...

SELECT @sql;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: variable rows to columns in a dynamic view
1740
June 17, 2011 12:40AM


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.