Hi list,
I'm using php/mysql, I was updating a table through phpmyadmin then I saw that to update all the columns which type is declared to float the developper of phpmyadmin have added a concat.
Something like:
UPDATE `tableInduction` SET `inductionType` = 'screening' AND CONCAT( `volume` ) = '1' AND `growthVessel` = '24-96 well plates' AND CONCAT( `pH_start` ) = '2'.....
the column volume and pH_start are of type float, and it's the same for all the columns I declare as float.
I suppose that this has some purpose, but I don't understand.
concat is an operator to "merge" 2 strings, for example concat ('string1','string2') should return string1string2.
What's the point of doing that for column's name?Is it a kind of cast because '1' is considered as string because of the quotes?
In the manual I saw:
select concat(14.3) gives as a result '14.3'.
Is that the same kind of "cast"?
Why isn't that done for integers?
Additionally, I want to store 1 or 2 decimals floating point number, what is the best?float?double?
I saw that "using float may give you some unexpected problems, as all calculations in MySQL are done with double-precision."
Thanks for your advice, Melanie
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
