您可以通过使用“删除”查询删除表中的所有行。

You can delete all rows in a table by using a delete query.

youdao

如果没有包括任何where子句，则删除表中的所有行。

If no WHERE clause is included, all rows in the table are deleted.

youdao

但是，一般地，您不希望删除表中的所有行；而是有选择地删除行。

In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.

youdao

delete语句从指定表中删除满足可选where子句的所有行。

The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.

youdao

为此，首先删除刚才在目标数据库mysample中的sales表中导入的所有行，见清单16。

To do so, you start with deleting all the rows that you have just imported in table SALES in the target database MYSAMPLE as Listing 16 shows.

youdao

在把sales表中的所有行成功地复制到SALES _ tmp表之后，可以删除源表(DROPtable语句)。

After copying all rows in table SALES successfully to table SALES_TMP, the source table SALES can be dropped (drop table statement).

youdao

在数据加载操作开始之前，选择truncate表操作删除orders表中的所有已有行。

Select the Truncate table action to delete all the existing rows in the Orders table before the data load operation starts.

youdao

在数据加载操作开始之前，选择truncate表操作删除orders表中的所有已有行。

Select the Truncate table action to delete all the existing rows in the Orders table before the data load operation starts.

youdao