Home > database >  Why can't delete the record, can remove cno=2, deliver
Why can't delete the record, can remove cno=2, deliver

Time:09-18

CodePudding user response:

The delete from course where cno='5'

You changed to

Select * from course where cno='5'

Try

Estimated that no data is found out, may be because of your the where condition is not correct

CodePudding user response:

I'm deleting data not select data I where conditions are right for you that when the delete cno=2 delete

CodePudding user response:

Agree on the first floor, there is no qualified data to remove bai

CodePudding user response:

Have I just input data to the data with the data

CodePudding user response:

You query the data cut a figure out, look at the data, such as much space?

CodePudding user response:

You first for the select, delete, modify the execution outside, if found out put the select is modified to delete the data, finally use the commit, or is not effective