how do i handle

[mak1084]

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]

How many columns of data do you want to backup?

You could create another table which studentID, Semseter_number, Semester_startdate, Semester_Enddate, 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

[mak1084]

How many columns of data do you want to backup?

You could create another table which studentID, Semseter_number, Semester_startdate, Semester_Enddate, 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