> I have to check to MySQL is able to support our requirements
>and I would
>like to view a return of n columns like only one register, thats is posible
>with MySQL?
> For example i have 2 tables , 1 table have products and this
>table habe 3
>colums ID , name, Id_price and the other table (prices) have 2 columns
>Id_price , price , can i return for the 'x' product their prices like
>price1,price2,...priceN
>
>
>______________________________
>Un Saludo
>Jaume Rubio
>Depto. Informática
>[EMAIL PROTECTED]
>http://www.epel-ind.com
>______________________________
Yes sir, you can return the data in that format, but whether it's a
good idea is another question. SQL was intended to return data in the
format
x, price1
x, price2
x, price3
With most RDBMSs, including MySQL, it is possible to force the data
into your format, but it is complicated and slows things down. You
would be better off having your query return data in the usual format
and then have a client program parse the output and reformat it.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
