Mysql database - RESET or FLUSH command help, urgent question

I have an urgent question.
How do I reset the data in a Mysql database table. I need to reset the values of a certain field to Zero. I have a PTR site and need the clicks reset to zero. Can anyone help? I think I should use the Reset or Flush command but I'm not sure how to do this correctly.

Thanks in advance!
Pat
plovell66Asked:
Who is Participating?
 
LordSilkConnect With a Mentor Commented:
Hi,

Why don't you just update the field in the table?

update <tablename>
set <fieldname> = 0

This will set all values of the column <fieldname>  in the table <tablename> to zero.
For more info on the update statement : http://dev.mysql.com/doc/mysql/en/UPDATE.html

The Flush and Reset commands are used to clear the cache of the MySQL server, not the data...



0
All Courses

From novice to tech pro — start learning today.