Reputation: 4357
I am having a strange error in mysql that despite of existing the column it generates and error saying that the column does not exists.
This is the table schema:
This is the Error in query:
Upvotes: 1
Views: 2197
Reputation: 54084
go to that table structure, edit the field.. there may b space
before and after attribute name
Upvotes: 3
Reputation: 2987
Should there be imagepath != 'NA' in mysql sql language? I would prefer <> 'NA'
Upvotes: 0
Reputation: 8710
Try to do a dump of the database in order to see the data structure. For doing that you can use the mysqldump
command. Take a look at the ouput of this command.
Upvotes: 0
Reputation: 48706
Seems that the column does not exist. Try to execute a 'desc user_ads' to check whether the column has indeed been removed or not.
Upvotes: 0