SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Zealot
    Join Date
    Oct 2007
    Posts
    100
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    (Easy enough) How to rename a mysql field

    from this picture i want to change "Recent Blog Entries" to just "Blog"











    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)

  2. #2
    SitePoint Zealot falsealarm's Avatar
    Join Date
    Sep 2008
    Posts
    147
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How about an UPDATE statement to make that change rather than limiting yourself to phpMyAdmin front end functionality This should be simple enough.

    update zp_entemodule_link set title = 'Blog' where title = 'Recent Blog Entries';

    You will have to execute this in the SQL tab. This should update all records where title is Recent Blog Entries to Blog. Reversing should be simply so I am not telling you to back up the table, etc.

  3. #3
    SitePoint Zealot
    Join Date
    Oct 2007
    Posts
    100
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by falsealarm View Post
    How about an UPDATE statement to make that change rather than limiting yourself to phpMyAdmin front end functionality This should be simple enough.

    update zp_entemodule_link set title = 'Blog' where title = 'Recent Blog Entries';

    You will have to execute this in the SQL tab. This should update all records where title is Recent Blog Entries to Blog. Reversing should be simply so I am not telling you to back up the table, etc.
    many thank dude, its works, gbu always


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
  •