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
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
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.
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