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
Arjun_Sarankulu
-3
Junior Poster
Recommended Answers
Jump to Postcheck for date format.
Jump to PostThat 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.
All 5 Replies
debasisdas
580
Posting Genius
Featured Poster
check for date format.
Arjun_Sarankulu
-3
Junior Poster
Same query worked
Thanks debasis for giving your time
debasisdas
580
Posting Genius
Featured Poster
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.
Arjun_Sarankulu
-3
Junior Poster
hi debasis do you any idea about Gridview insert update and delete using Ajax
if you dont mind i know normal insert update delete
Arjun_Sarankulu
-3
Junior Poster
Solved
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.