SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    Oct 2001
    Posts
    359
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question what is wrong with this update command

    This is the command:
    Code:
    update users set (last_act,count) = ('2004-06-07 22:01:12','0') where uname='random';
    Spits back this error:
    Code:
    Check the manual that corresponds to your MySQL server version for the right syntax to use near '(last_act,count) = ('2004-06-07 23:28:51','1') WHERE uname='
    thanks

  2. #2
    SitePoint Member
    Join Date
    Jun 2004
    Location
    Sydney
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the update syntax should be like this:

    update users set last_act = '2004-06-07 22:01:12', count = '0' where uname = 'random';


    hope this helps


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
  •