TRUNCATETABLE

网络表格名

TRUNCATETABLE

网络释义

TRUNCATETABLE

表格名

MYSQL基本知识... ... DROPTABLE 表格名 ——删除表格 TRUNCATETABLE 表格名 ——清楚表格数据 /***********VIEW 视图*…

例句：

Membership of a group that has sufficient authority to issue TRUNCATE TABLE statements and have CREATE TABLE statement privileges .

一组成员，拥有足够的授权来发出 TRUNCATETABLE 语句且拥有 CREATETABLE 语句权限。

Individual deletions of rows are not entered into the transaction log , so the TRUNCATE TABLE operation is not replicated .

各行删除操作不记入事务日志，因此不复制 TRUNCATETABLE 操作。

The TRUNCATE TABLE statement is entered into the transaction log as a single statement , like data definition statements .

与数据定义语句一样，TRUNCATETABLE 语句作为单个语句记入事务日志。

You can use the TRUNCATE TABLE statement as a fast method of deleting all the rows in a table .

您可以使用 TRUNCATETABLE 语句作为快速删除表中所有行的方法。

The TRUNCATE TABLE statement is not executed within a trigger .

TRUNCATETABLE 语句不在触发器内执行。

The TRUNCATE TABLE statement is not executed within an atomic statement .

TRUNCATETABLE 语句不在原子语句内执行。

To execute TRUNCATE TABLE , the user must have ALTER permissions on the specified table .

若要执行 TRUNCATETABLE ，用户必须对指定表具有 ALTER 权限。

TRUNCATE TABLE is a non-logged operation that does not fire triggers .

TRUNCATETABLE 是不会激发触发器的日志未记录的操作。

A TRUNCATE TABLE statement is not caught by a DELETE trigger .

DELETE 触发器不能捕获 TRUNCATETABLE 语句。

SELECT statements are included before and after the TRUNCATE TABLE statement to compare results .

SELECT 语句放在 TRUNCATETABLE 语句之前和之后以比较结果。

In UltraLite embedded SQL applications , use DELETE instead of TRUNCATE TABLE to delete all the rows in a table .

在 UltraLite 嵌入式 SQL 应用程序中，使用 DELETE 而不是 TRUNCATETABLE 来删除表中的所有行。

TRUNCATE TABLE is faster than DELETE and uses fewer system and transaction log resources .

TRUNCATETABLE 比 DELETE 速度快，且使用的系统和事务日志资源少。

After a TRUNCATE TABLE statement , the table structure and all of the indexes continue to exist until you issue a DROP TABLE statement .

执行 TRUNCATETABLE 语句后，表结构及所有索引仍然存在，直到发出 DROPTABLE 语句。

Delete triggers are not fired by the TRUNCATE TABLE statement .

TRUNCATETABLE 语句不触发删除触发器。

A TRUNCATE TABLE statement does not fire triggers defined on the table .

TRUNCATETABLE 语句不触发在该表上定义的触发器。

Use TRUNCATE TABLE if all rows are to be deleted from the table .

如果要从表中删除所有行，请使用 TRUNCATETABLE 。

The TRUNCATE TABLE statement deletes all rows from a table .

TRUNCATETABLE 语句删除表中的所有行。

TRUNCATE TABLE removes all rows from a table, but the table structure and its columns , constraints, indexes, and so on remain .

TRUNCATETABLE 删除表中的所有行，但表结构及其列、约束、索引等保持不变。

Why can't I run TRUNCATE TABLE on a published table ?

为什么无法对已发布的表运行 TRUNCATETABLE ？

TRUNCATETABLE

TRUNCATETABLE

表格名

热词推荐

大家在看