Re: MySQL Query

2002-09-04 Thread abhilas
Hi Jed, Though this works,when I tried to insert an inner query in that,it is giving an error in syntax.Can u please help me in thi matter?I gave the query as follows: select TO_DAYS(CURDATE()) - TO_DAYS(select dates from userregistration where userid like 'ab

MySQL Query

2002-09-02 Thread abhilas
Hi, My intention is to get the datedifference(in no of days) between the current date and a previously entered date which is in a table(of course this date is lower in value than the current date).When I used this query: select FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30')); Here

Query

2002-07-18 Thread abhilas
Hi, I am retrieving the values of some positions of a table in MySQL dynamically.The position has null(automatically database insert that null value),1,2 values.I have to retrieve that values to a java prog and to check whether the retrieved value is 1,2 or null.This I am doing like this.

Query

2002-07-17 Thread abhilas
Sir, I am a PG student of Indian Institute Of Information techology And Management Kerala.I had been using your product.I would like to get an information. I would like to know the maximum number of rows and columns which can be inserted into a table in MYSQL. I hope you will reply to me