Update spot_price set location = ‘PATAN’ where symbol = ‘CASTORP’ and polling_date between ‘20110730’ and ‘20110806’

Giving sql syntax error.

Same query i am using to update another table in sqlserver its working but not in mysql

Same query worked
Thanks debasis for giving your time

That will depend how the value is stored.

Sql Server and MySql may behave differently to the exact same piece of code, after all they are two different databases from two different vendors.

hi debasis do you any idea about Gridview insert update and delete using Ajax
if you dont mind i know normal insert update delete

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.