0

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

2
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by Arjun_Sarankulu
0

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.

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.