MySQL server version for the right syntax to use near

  • (2 Pages)
  • +
  • 1
  • 2

18 Replies - 998 Views - Last Post: 22 August 2013 - 09:32 AM Rate Topic: -----

#16 d.struiwig  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 20
  • Joined: 14-August 13

Re: MySQL server version for the right syntax to use near

Posted 22 August 2013 - 08:25 AM

The first row must be the updated records but insteed of update the text it is add the records in the database

View Postybadragon, on 22 August 2013 - 08:20 AM, said:

Then you need to create an UPDATE Query instead of an insert query if you are updating. The link provided explains how to create an Update query in SQL, it's also an amazing site for research and common questions.



AAAAAAAAAAA thank u!! very much.. but can i ask u one question if i not bother...

Can u make a example of the update query for me...?

Attached image(s)

  • Attached Image

Was This Post Helpful? 0
  • +
  • -

#17 rgfirefly24  Icon User is offline

  • D.I.C Lover
  • member icon


Reputation: 296
  • View blog
  • Posts: 1,537
  • Joined: 07-April 08

Re: MySQL server version for the right syntax to use near

Posted 22 August 2013 - 08:26 AM

Look at my post about the update statement as well as yba's. Both of our links will give you examples.

This post has been edited by rgfirefly24: 22 August 2013 - 08:27 AM

Was This Post Helpful? 1
  • +
  • -

#18 ybadragon  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 299
  • View blog
  • Posts: 1,534
  • Joined: 11-May 12

Re: MySQL server version for the right syntax to use near

Posted 22 August 2013 - 08:50 AM

This link will direct you to MSDN showing an example of an update query. You really shouldl look at the links we posted though. it goes back to the saysing "Give a man a fish he'll eat for a day, teach a man to fish, he'll eat for a lifetime."
Was This Post Helpful? 0
  • +
  • -

#19 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9579
  • View blog
  • Posts: 36,296
  • Joined: 12-June 08

Re: MySQL server version for the right syntax to use near

Posted 22 August 2013 - 09:32 AM

@OP - seriously.. leaving your connection information out there is a bad thing.. I would prefer not to have to fix it four times next time. At the bare minimum xxx out your user name and password.
Was This Post Helpful? 1
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2