Increment date in script

Shell Programming and Scripting
1

Hi,
Iam new to scripting language.:o
can someone help me out solving this thread?hopingly ya....:slight_smile:
I want to write a script which connects to db and searches the count in a table which has date column and id column.
If the count is not equal to 0 then it should increment the date with the one which is in the table.
suppose the table has date as 12-12-2009 then the script should increment the date to 13-12-2009.

Thanks and Regards,
Jyothi:)

2

First question which db - oracle, sybase...?

3

Iam using Mysql database.

4 
mysql> SELECT ADDDATE('2009-01-02', 1);
        -> '2009-01-03'
5

Thanks a lot....