SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member GoSURF's Avatar
    Join Date
    Aug 2002
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to query this code

    i've a table 'stat_vistors'

    --------------------------------
    log_date | number | v1.5 | v2
    ================================
    02-10-26 | 2000 | 1500 | 500
    --------------------------------
    02-10-27 | 2100 | 1550 | 550


    i want to update the column "v1.5"
    so i write : "UPDATE stat_vistors SET v1.5 = 1551 WHERE log_date = '02-10-26'"

    but it seems v1.5 = 1551 is an error sytanx.
    what's the correct form.
    ps: i can't change the column name "v1.5" to another.
    GoSuRF WebBrowser (http://www.mmjd.com/gosurf)
    - Smart spam control
    - Magic mouse gestures

  2. #2
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    UPDATE stat_vistors SET `v1.5` = 1551 WHERE ...

    ` == grave accent

  3. #3
    SitePoint Member GoSURF's Avatar
    Join Date
    Aug 2002
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it works. thx
    GoSuRF WebBrowser (http://www.mmjd.com/gosurf)
    - Smart spam control
    - Magic mouse gestures


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •