1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

(Easy enough) How to rename a mysql field

Discussion in 'MySQL' started by basketmen, Jan 26, 2009.

0
  1. #1
    from this picture i want to change "Recent Blog Entries" to just "Blog"

    [​IMG]









    how to make it guys, or what command i need to run, there is no edit button there (thats like usually showing in table edit)
     
    basketmen, Jan 26, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Run this query to update, it is better to keep the backup of the table before running this query.
    UPDATE zp_entemodule_link SET
title = 'Blog'
WHERE title = 'Recent Blog Entries'
    Code (markup):
     
    mwasif, Jan 26, 2009 IP
  3. Christian Little

    Christian Little Peon

    Messages:
    1,753
    Likes Received:
    80
    Best Answers:
    0
    Trophy Points:
    0
    #3 
    
UPDATE zp_entemodule_link SET title="Blog" WHERE title="Recent Blog Entries"
    Code (markup):
    That'll do it, but with 30,000+ rows it will probably take 5-10 minutes to run if you are on a shared host.
     
    Christian Little, Jan 26, 2009 IP
  4. basketmen

    basketmen Well-Known Member

    Messages:
    837
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    130
    #4
    ah i am sorry, maybe there is problem with my connection or in dp server before so its post in two thread, i will tell mod to delete the other thread




    thank you for your answer thought

     
    basketmen, Jan 26, 2009 IP