Total members 11797 |It is currently Sat Sep 21, 2019 9:19 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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




Author:
Newbie
User avatar Posts: 4
Have thanks: 0 time

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



Author:
Mastermind
User avatar Posts: 2707
Have thanks: 74 time

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.


Author:
Newbie
User avatar Posts: 1
Have thanks: 0 time
Post new topic Reply to topic  [ 3 posts ] 

  Related Posts  to : DYNAMIC DATES IN MYSQL
 Formatting dates in mysql     -  
 Dynamic Domain Name System (Dynamic DNS )     -  
 find the difference between dates in asp.net     -  
 Comparing Dates in Java     -  
 Get Difference in days between two dates as a number     -  
 How do you 301 redirect a dynamic URL?     -  
 How to generate dynamic 3d pie chart in php???     -  
 Dynamic Array Allocation     -  
 make Dynamic Bar Chart by php     -  
 how to implement Dynamic DDS (Domain Name System)     -  



cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com