Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Snapshot in MySQL

mwaqasbadarmwaqasbadar Member Posts: 1
I have to take snap shot based on some criteria. e.g. consider there is a table having column salary. i want to take the snapshot of table which contain only those rows whose salary is greater than 20000.

Can any body tell me how can i take snapshot in mysql based on some criteria?

Comments

  • quotientquotient Member Posts: 62
    Using the WHERE clause. Example:
    [code]SELECT * FROM myTable WHERE salary>20000[/code]

    F

    : I have to take snap shot based on some criteria. e.g. consider there is a table having column salary. i want to take the snapshot of table which contain only those rows whose salary is greater than 20000.
    :
    : Can any body tell me how can i take snapshot in mysql based on some criteria?
    :

Sign In or Register to comment.