Reset a huge MySQL table values to 0

I can help with SQL script development in a most effective way because I am highly experienced database developer having more than 10 years length of time professionally worked in implementation of complex database solutions.

8 years of experience in Linux server management and cloud systems which includes Installation, Monitoring, and Optimization. I can handle the installation of applications on Linux. I do web hosting support, Website migration, and Automation on server platform.

Namaste! Are you looking for a SQL Server Expert for your project? I would like to know more about the database and the total number of tables that have to reset to zero. About me: I'm SQL Server Performance and Emergency Expert; with 6+ years of professional experience in 5 high performance OLTP system and some freelance projects. About SQL Server Performance: It's hard to make our server 100x faster - but it's really easy to make our database design and queries suddenly 100x more efficient. Fixing queries and tables and indexes is indeed hard work - but it's totally worth it. Warm regards, Kundan (Your remote consultant)

Hi. I have expertise in C#,MSSQL,MySQL,Oracle,Acces with more than 10 year of experience. I can handle any kind of task and assure you that you will get good quality of work. I am interested in working with you on this project and I am willing to proceed further with the discussion. Please send me a message and we can have a quick chat right away. because i have few questions about your query I am waiting for your positive response. Best Regards, Alphatech

Hi, im an experienced system admin. I can help you reset/truncate the table if thats what you need. Lets chat about it. Thanks

Hello; How are you ? I hope you are doing well. I am IT Administrator with over 10 years of professional experience. I read the description of your project and I would like to offer you my service to complete this task asap. Please contact me so we can start working on it, I am available right now. I can start now if you want just contact me by chat. I am looking forward to working with you soon. si vou sparlez francais c'est un plus. Thanks

Hello, Where is the screenshot ? By the way, if you have to reset all values to 0 (or equivalent), there is not much you can do then just writing a basic command and let it complete on its own :) Your Processors speed will play the key role here :) Other alternatives can be :- 1. Deletion and Recreation of whole table. 2. Deletion of all rows all at once. Note - All of them will consume some time, after all there are 100+ million rows. :) Thank you.

Hi, I have read your requirement and I am confident that I can resolve your query as per your requirement I have expertise in C# MySQL, MSSQL and oracle, access, excel with more than 10 years of experience. But unfortunately I am new on this platform for further discussion please DM me. I am waiting for your positive response Thanks Regard Rao Mubashir

Hello, Nice to meet you. You have confirmed the details of the project you ordered. I am an expert in web server and database management (Mysql, SQL, MS ACCESS). Also, database optimization is my basic skill. Please see my portfolio entry. Let's talk about the issues raised through conversation. I will be a faithful helper. Thank you. regards.

Hi I have read your post and I offer my services to reset mysql db values. I am experienced and have done similar work. I am unable to find screenshoot. Kindly provide me details. I am looking forward for your response. Thanks

Sir, We have understood your issue as well as the requirement for the SQL script. We provide you the script do this process faster and smoother for you. Looking forward to discuss more about the project. Thanks.

hello, i am mysql expert. maybe i can help you. can you give me more details? ........................................................... . ...................