#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    32
    Rep Power
    15
    Ok I have created a table....
    now I have added another row

    what's the correct insert syntax to

    INSERT into tablename set blah=0 where
    name like "%john%";

    what's wrong here, thanks for your help!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 1999
    Location
    Annapolis, Maryland US
    Posts
    113
    Rep Power
    16
    > UPDATE table_name set blah=0....
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    32
    Rep Power
    15
    damn im stupid

    thanks

Similar Threads

  1. sql newbiew: insert problem
    By worlddom in forum MySQL Help
    Replies: 6
    Last Post: January 10th, 2004, 06:59 AM
  2. insert problem
    By damienleonardo in forum PHP Development
    Replies: 6
    Last Post: October 24th, 2003, 05:53 PM
  3. insert problem
    By zuzupus in forum MySQL Help
    Replies: 8
    Last Post: September 4th, 2003, 12:24 PM
  4. Replies: 3
    Last Post: November 22nd, 2002, 06:08 PM
  5. Uknow Known MYSQLERROR
    By andyw in forum MySQL Help
    Replies: 7
    Last Post: January 23rd, 2001, 10:34 AM

IMN logo majestic logo threadwatch logo seochat tools logo