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?

Improve company productivity with a Business Account.Sign Up

x
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.