有关删除的错误[已解决] [英] an error about delete [Solved]

问题描述

大家好：为什么这段代码出错：'*'附近的语法不正确。

hi every body: why this code make an error: Incorrect syntax near '*'.

Public Sub Delete_data()
        cn.Open()
        Dim rs As New SqlCommand("delete * from shakhes where tadieh_shakhes='" & TextBoxX2.Text & "'", cn)
        rs.ExecuteNonQuery()
        cn.Close()
        display_data()
    End Sub

推荐答案

更改

change

delete * from shakhes

to

to

delete  from shakhes 

删除语法是

delete syntax is

DELETE FROM table_name
WHERE some_column=some_value;

这篇关于有关删除的错误[已解决]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！