SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict Kevinslair's Avatar
    Join Date
    Jul 2002
    Location
    Binghamton
    Posts
    246
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Removing the 1 from query window in phpmyadmin

    Hello, Everyone!! Happy New Year!!

    I have a question. I hope this is the right thread for it.

    In phpmyadmin, how do you remove the '1' from the sql query window where it shows: select * from `table` WHERE 1
    ??
    Should I remove it or keep it there? It's really bothersome sometimes.
    Thanks,
    Kevin
    I PHP!

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Why is it bothersome? It's a condition which is always true, so it doesn't change your results.

    You don't need to use phpMyAdmin, it's not something that's a part of MySQL or even comes with it, just a script some guy wrote in PHP one time...

  3. #3
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,789
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by Kevinslair View Post
    how do you remove the '1' from the sql query window where it shows: select * from `table` WHERE 1
    That's just there to get you started. Simply overtype whatever part of the select statement (or even all of it) with what you actually want the SQL to read. Alternatively use the buttons alongside to build the query if you don't actually know enough SQL to write it for yourself.
    Stephen J Chapman

    javascriptexample.net, Book Reviews, follow me on Twitter
    HTML Help, CSS Help, JavaScript Help, PHP/mySQL Help, blog
    <input name="html5" type="text" required pattern="^$">


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
  •