Home > Database > Mysql Tutorial > 请问:mysql delete 很少的数据,用时要比TRUNCATE TABLE快呢?

请问:mysql delete 很少的数据,用时要比TRUNCATE TABLE快呢?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 09:33:02
Original
967 people have browsed it

mysql数据

如题;
TRUNCATE TABLE 0.3S
DELETE TABLE XX ;//数据量越少越快。100条不到100毫秒。

Related labels:
source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template