Issue in updating data in SQL need help

Discuss
#1

Trying to update data in a cell but getting error see my blocks and help me

IMG_20200212_110159
IMG_20200212_110159764×705 149 KB
IMG_20200212_110033
IMG_20200212_110033782×416 90.4 KB

And error msg

IMG_20200212_105851
IMG_20200212_1058511025×644 116 KB

I also tried to find solutions in community and got a thread but that could not solve my problems plz help anyone

#2

Views and slno column is integer you can directly pass without ‘’ and column name with `` backticks.
UPDATE CJcorp SET Views =1 WHERE Sl. No. = 2.
Backticks because your column name contains space sl. No.

#3

use reasonakle column names without spaces or dots…
probably it will work, if you put that column name in double quotes…
Unbenannt

Taifun

#4

Use deephost extension for db

#5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.