DYNAMIC DATES IN MYSQL

surya

Hai,
i want to design a database with fields name,currentdate and nextdate. This currendate and nextdate should be the actual date. It should be dyanmic also. I'm working in JSP and MySql. Is that possible to create such a database??? I don't want to store the dates into my table. I want the dates to be my fields in my table. Is that possible?? If anyone knows the answer, plz help me.....

DrRakha

Code:

CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
      species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

thouf222

I am a relative newbie for php/MySQL, and most of what
I am doing is based on being self-taught using someone else's
well-written code, and my own googling the answers to my questions.

I'm doing a php/MySQL page that reads data out of a MySQL database.
Longer term, I'll do a data-entry screen allowing me to modify the
database or add new records. For now, I'm just using phpmyadmin to data
enter stuff.

Is there a way to set up a date field, Last_Update, that would
automatically update to today's date any time a record was added or
changed using phpmyadmin?

Not sure if I'm asking the question clearly. What I want would be that,
let's say that I add a new record today, April 23. The Last_Update
field for the record would automatically be April 23. If I go in and
modify and part of that record on April 29, Last_Update automatically
changes to April 29 for that record.

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

DYNAMIC DATES IN MYSQL