Click here to Skip to main content
15,394,645 members
Home / Discussions / C#
   

C#

 
GeneralRe: Mysql Update Query Error Pin
Dave Kreskowiak20-Mar-22 10:49
mveDave Kreskowiak20-Mar-22 10:49 
GeneralRe: Mysql Update Query Error Pin
N Mohamed rafi20-Mar-22 18:09
MemberN Mohamed rafi20-Mar-22 18:09 
GeneralRe: Mysql Update Query Error Pin
Richard MacCutchan20-Mar-22 22:25
mveRichard MacCutchan20-Mar-22 22:25 
GeneralRe: Mysql Update Query Error Pin
N Mohamed rafi20-Mar-22 23:45
MemberN Mohamed rafi20-Mar-22 23:45 
GeneralRe: Mysql Update Query Error Pin
Richard MacCutchan20-Mar-22 23:50
mveRichard MacCutchan20-Mar-22 23:50 
GeneralRe: Mysql Update Query Error Pin
Dave Kreskowiak21-Mar-22 2:29
mveDave Kreskowiak21-Mar-22 2:29 
Generalmysql delete code error Pin
N Mohamed rafi19-Mar-22 16:36
MemberN Mohamed rafi19-Mar-22 16:36 
GeneralRe: mysql delete code error Pin
Dave Kreskowiak19-Mar-22 17:54
mveDave Kreskowiak19-Mar-22 17:54 
That's not a valid SQL DELETE statement. You're trying telling it to delete the fields in a row and that's not how it works.

The correct format is, assuming your table name is "employee" and the identity column is "EmployeeID":
SQL
DELETE employee WHERE EmployeeId = @employee_id


GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 18:01
MemberN Mohamed rafi19-Mar-22 18:01 
GeneralRe: mysql delete code error Pin
Dave Kreskowiak19-Mar-22 18:39
mveDave Kreskowiak19-Mar-22 18:39 
GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 19:48
MemberN Mohamed rafi19-Mar-22 19:48 
AnswerRe: mysql delete code error Pin
OriginalGriff19-Mar-22 21:04
mveOriginalGriff19-Mar-22 21:04 
GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 23:05
MemberN Mohamed rafi19-Mar-22 23:05 
GeneralRe: mysql delete code error Pin
OriginalGriff19-Mar-22 23:35
mveOriginalGriff19-Mar-22 23:35 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 0:02
MemberN Mohamed rafi20-Mar-22 0:02 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 0:37
mveOriginalGriff20-Mar-22 0:37 
GeneralRe: mysql delete code error Pin
Richard MacCutchan20-Mar-22 2:13
mveRichard MacCutchan20-Mar-22 2:13 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 2:21
MemberN Mohamed rafi20-Mar-22 2:21 
GeneralRe: mysql delete code error Pin
Richard MacCutchan20-Mar-22 2:25
mveRichard MacCutchan20-Mar-22 2:25 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 1:58
MemberN Mohamed rafi20-Mar-22 1:58 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 2:33
mveOriginalGriff20-Mar-22 2:33 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 2:46
MemberN Mohamed rafi20-Mar-22 2:46 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 3:26
mveOriginalGriff20-Mar-22 3:26 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 3:46
MemberN Mohamed rafi20-Mar-22 3:46 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 2:47
MemberN Mohamed rafi20-Mar-22 2:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.