Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011

    Talking Unanswered: MYSQL calculate age from dob and save it to the table

    has the title say, i wonder if anyone of you out there, can help me with a query,, to calculate the age from dob and added to my table, that has already a column called 'AGE'

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    don't store something such as age in a table, its derived data, and should be derived as and when required.

    Age is a particularly good example of why you don't store derived data, as effectively you would have to run this query every night to keep the value of age up to date

    mysql calculate age - Google Search

    mysql calculate age - Google Search
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts