Delete from table where col is null;
这样写不行，删除不掉；
Sometimes an application needs to delete all records from a given table to clean up a log or reload sales data for a new month.
有时候应用程序需要从给定表中删除所有的记录，以便清空日志记录或者装入新的一个月的销售数据。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
如果从一个带有10个索引的表删除一行，DB 2必须删除与被删除的行关联的所有索引条目。
The simple answer is to delete the table from the database and, if necessary, create a replacement table.
简单的答案是从数据库中删除表。而且，如果必要，再创建一个替代表。
A delete operation could remove a record from a parent table, leaving records in an associated child table that no longer have a matching record in the parent table.
一个删除操作可以从一个父表中删除一条记录，使得相关子表中的记录在父表中没有与之匹配的记录。
It is a good practice to delete any pruned rows from the table that you loaded in order to ensure that you do not load duplicate rows into the table at a later time.
从您装载的表中删除被修剪过的行，确保以后不会将重复的行装载到表中，这是一种很好的做法。
Data delete specifies the interval at which data from this table is deleted.
“数据删除”指定从此表中删除数据的时间间隔。
In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.
但是，一般地，您不希望删除表中的所有行；而是有选择地删除行。
A simple delete command causes DB2 to remove the data from the current table and maintain an old version in the history table, including the end time of the deleted data.
一个简单的DELETE命令导致DB 2从当前表移除数据，并在历史表中维护一个旧版本，包括已删除数据的结束时间。
DML commands are used to add, modify, delete, or select data from a table in the database.
DML命令用来在数据库表中添加、修改、删除或选择数据。
You could manually delete the HTML table tags from source, or you could configure the Faces Library Definition so that it can use this configuration on other pages and in other projects.
您可以从源中手动地删除HTML表格编辑，或者您可以配置FacesLibraryDefinition，这样它就可以在其他的页面上及其他的项目中使用该配置了。
To avoid analyzing duplicate records, you delete rows from the CHECKING table with a timestamp greater than the one you pruned the pruned the audit log with.
为了避免分析重复的记录，从checking表中删除时间戳大于一个指定的、用于修剪日志的时间戳的行。
Note: you can delete the existing records in the product table that you imported from the old database to test out the code.
注意：可以删除product表中从原数据库导入的现有记录，从而测试此代码。
Switch to the report Design perspective and delete the table from the work items report that you created in the previous article.
切换至Reportdesign视角，并从您在前文中所创建的工作项报表中删除掉表格。
Otherwise, the deleted row is moved from replication table to the associated delete table, which might cause problems for the subsequent alter operation on the replicated table.
否则，被删除的行将被从复制表转移到相关的删除表，这样会给随后对复制表的alter操作带来问题。
Delete the columns named begin and end from the Result columns table.
从Resultcolumns表中删除begin和end列。
To delete tables from the Server Explorer tree, right-click on the appropriate table node in the tree, and choose the delete option.
要从Serverexplorer树中删除表，右键单击树中相应的表节点，然后选择Delete选项。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁，以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如，使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
When rows associated by package IDs are not required, SAP needs a quick and efficient mechanism to delete the data from the table.
当与包id相关的行不需要时，SAP需要一种快速而有效的机制来从表中删除该数据。
ON DELETE CASCADE—When a record is deleted from the parent table, all records in the child table with matching foreign key values are also deleted.
ON DELETECASCADE —当一条记录从父表中删除时，子表中的所有记录以及匹配的外键值都全部被删除。
The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.
delete语句从指定表中删除满足可选where子句的所有行。
When ON delete set NULL is active, when a record is deleted from the parent table, all records in the child table with matching foreign key values are set to NULL.
当ON DELETESETNULL规则被激活时，如果一条记录从父表中删除，子表中的所有记录以及匹配的外键值都被设置为NULL。
When an ON delete CASCADE rule is active, all records in the child table with matching foreign key values are deleted when a record is deleted from the parent table.
当ONDELETECASCADE规则被激活时，当一条记录从父表中删除时，子表中的所有记录以及匹配的外键值都被删除。
Apart from the ability to create new tables, you might also want to delete tables-only if you've made an accidental typing mistake, or when you no longer need a particular table.
除了能够创建新表之外，您可能还想删除表—只有在偶然犯了输入错误或不再需要特定表时。
从表中删除一条记录。
All that DB2 does is to allow an UPDATE, DELETE, and INSERT to appear in the from clause of a select and allow the user to chose which transition table shall be selected from.
DB 2所做的就是允许UPDATE、DELETE和INSERT出现在选择语句的from子句中，并允许用户选择应该从哪个过渡表进行选择。
Delete-the delete method takes an integer ID and deletes that row from the table.
delete—delete方法接受一个整数ID并从表中删除该行。
From the table list of links, identify the link you wish to delete.
从链接的表格列表中，找出你想要删除的链接。
For queries or views that show data from a single table or view, you can edit the values in individual columns in the result set, add new rows, and delete existing rows.
如果是显示来自单一资料表或检视表资料的查询或检视表，您可以在结果集内的个别资料行中编辑值、加入新的记录列以及删除现有的资料列。
I have a table structure with partitioned tables, where a few child tables inherit from a common parent. How so I DELETE only from the parent table?
我与分区表有一个表的结构，其中一些孩子继承了一个共同的父表。我怎么DELETE只有从父表？
应用推荐