Array data type

Hello, How to store multiple values in a single field? Is there any array data type concept in mysql? Regards, Samrat Kar FRD, BARC Tel: 022-25597295 Alternate Email: esam...@yahoo.com

RE: Decimal points

SELECT IF((col1+col2) = FLOOR(col1+col2),FLOOR(col1+col2), col1+col2) EXAMPLE>>> SELECT IF((1+1.1) = FLOOR(1+1.1),FLOOR(1+1.1),1+1.1) Results 2.1 SELECT IF((1+1.0) = FLOOR(1+1.0),FLOOR(1+1.0),1+1.0) Results 2 Regards, Samrat Kar -Original Message- From: Ashley M. Kirchner [m

Execute 3 Queries in Single Command

I want to execute three sql statements in single query which will perform following task... 1. select a particular row 2. insert that row to another table 3. delete that row from 1st table in short, i want to move one row from table 1 to table 2 with single query.. thanks in advance for any sug