如何删除Compact Sql中的行 [英] How to delete row in Compact Sql

问题描述

在sql compact中删除一行的命令是什么？

解决方案

delete语句功能非常强大，如果使用不正确，可以清空整个表。它是通过引用与值匹配的字段（或多个字段）来完成的 - 如果发现它将删除记录。

 < span class =code-keyword>删除 从 TableName 

删除所有记录。

 删除 来自 TableName 
 其中 _columnName = _value 

将删除符合条件的所有行。



http://www.w3schools.com/sql /sql_delete.asp [ ^ ]

What is the command to delete one row in sql compact?

解决方案

The delete statement is very powerful and if not used correctly can empty the entire table. It is done by referencing a field(or several fields) that matches a value - if found it will delete the record.

Delete From TableName

Would delete all records.

Delete From TableName
Where _columnName = _value

Will delete any rows that match the condition.

http://www.w3schools.com/sql/sql_delete.asp[^]

这篇关于如何删除Compact Sql中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！