invalid syntax and invalid column

Posted on

Question :

first picture i dont know why i keep getting this error i have no idea how to fix it…either i get this error or invalid column name -_-
enter image description here
the invalid column error i get only on the item ‘tosai’


this is the coding i used …checked it multiple time with my notes and i dont see anything wrong here i must be missing something out but i have no idea what is it

Answer :

You need to enclose condition in ‘ and ‘. ( Sql Syntax)

delete from [Food] where [Food List] = 'Potato'

Leave a Reply

Your email address will not be published. Required fields are marked *