By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

how do i handle

P: 44
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.
Feb 5 '08 #1
Share this Question
Share on Google+
2 Replies


Shashi Sadasivan
Expert 100+
P: 1,435
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
Feb 6 '08 #2

P: 44
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
Feb 6 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.