how do i handle

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mak1084
    New Member
    • Jul 2007
    • 44

    how do i handle

    hey friends...

    i'm creating a web application for college atandance. In this application after every semester student have to postponed to a new new semester...so how do i change the coulmn of the student table to there respective semester....

    if i use a update query then it will over write all the previous data...

    how do backup all the data so that they can be accesable in the database till the student is pass out from the college.

    thank you.
  • Shashi Sadasivan
    Recognized Expert Top Contributor
    • Aug 2007
    • 1435

    #2
    How many columns of data do you want to backup?

    You could create another table which studentID, Semseter_number , Semester_startd ate, Semester_Enddat e, count

    and before you update the main table, back the data to this table where you just have to copy certain columns.

    If you wish you could add these columns to your existing tables. but that ould increase the number of columns depending upon the number of semesters

    Comment

    • mak1084
      New Member
      • Jul 2007
      • 44

      #3
      Originally posted by Shashi Sadasivan
      How many columns of data do you want to backup?

      You could create another table which studentID, Semseter_number , Semester_startd ate, Semester_Enddat e, count

      and before you update the main table, back the data to this table where you just have to copy certain columns.

      thanks...

      but i here some more query i wan t a data to be backed some where out side of the working database how could i achieve this. i mean how can i back up a data in non working data base.



      thanks

      Comment

      Working...