Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

Update statistics for a table in the database

大家讲道理
Release： 2016-11-12 10:55:19
Original
1928 people have browsed it

IF EXISTS(SELECT name FROM sys.databases WHERE name=N'Test')
BEGIN
USE Test
EXEC sp_updatestats
END
GO
Copy after login

Related labels：
代码片段，代码分享，PHP代码分享，Java代码分享 Ruby代码分享，Python代码分享，HTML代码分享，CSS代
source：php.cn
Previous article：Execute dynamic SQL statements in MySQL stored procedures Next article：Data consistency verification and repair procedures in MySQL non-master-slave environment
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Parent's padding ignored by sticky positioned child How to prevent sticky elements from going behind the header? The current code snippet uses...
From 2024-04-06 11:42:51
0
1
338
How to know when a Vue component is fully initialized? So, in my Vue component, I have an async created method and several variables with async w...
From 2024-04-05 14:20:24
0
1
1442
The restated title is: The English translation of Stripe Connect Subscription Split Fees is "Stripe Connect Subscription Split Fees" Hi, I'm building a platform for clients using StripePHPAPI that sells subscriptions on a m...
From 2024-04-02 20:15:22
0
1
418
How to align images using CSS grid? I'm trying to build part of a website using CSS grid. I'm trying to get the list and image...
From 2024-04-01 22:08:31
0
1
338
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template