www.webdeveloper.com
Results 1 to 2 of 2

Thread: update query set field to other field

  1. #1
    Join Date
    Nov 2011
    Posts
    12

    update query set field to other field

    i need the query for update one field to other field and text
    for example :
    Code:
    update shop_products set buy_link=(`id`)."text"';
    but this query syntax error

  2. #2
    Join Date
    Nov 2011
    Posts
    12
    my answer :
    Code:
    update shop_products set buy_link=CONCAT(`id`,'s');

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles