Member Avatar for Arjun_Sarankulu

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
  • 112 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Arjun_Sarankulu
Member Avatar for debasisdas

check for date format.

Member Avatar for Arjun_Sarankulu

Same query worked
Thanks debasis for giving your time

Member Avatar for debasisdas

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.

Member Avatar for Arjun_Sarankulu

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.