Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8
  1. #1
    Regular Coder YaymeQ's Avatar
    Join Date
    Feb 2008
    Location
    virginia
    Posts
    140
    Thanks
    14
    Thanked 0 Times in 0 Posts

    MySQL phpmyadmin or no?

    I'm just learning php and mysql and I'm not sure if I should use some application like phpmyadmin or something else, I'm open to doing things the hard way to better understand it but I'm not sure it's worth it. I haven't gone too far into it yet (Obviously or I'd probably know) so what do you guys suggest?

    Thanks
    ~YaymeQ
    Where is the "any" key??!

  • #2
    New Coder
    Join Date
    May 2008
    Location
    Doncaster, England
    Posts
    34
    Thanks
    2
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by YaymeQ View Post
    I'm just learning php and mysql and I'm not sure if I should use some application like phpmyadmin or something else, I'm open to doing things the hard way to better understand it but I'm not sure it's worth it. I haven't gone too far into it yet (Obviously or I'd probably know) so what do you guys suggest?

    Thanks
    ~YaymeQ
    Hello YaymeQ. I am also new to this but I do use PHPmyAdmin and I would suggest using it but only because it is all I have used and all I am familier with. I hope that helped you a bit.

    David.

  • #3
    New Coder
    Join Date
    Jan 2008
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    when sql syntax is unfamiliar to you and you need the job done, sure use phpmyadmin.
    mysqlquerybrowser is also good tool even with it's bugs if you know your sql well enough.
    command line works best when doing major operations to data or when you type faster than you click.

  • #4
    bdl
    bdl is offline
    Regular Coder
    Join Date
    Apr 2007
    Location
    Camarillo, CA US
    Posts
    590
    Thanks
    4
    Thanked 83 Times in 82 Posts
    I use phpMyAdmin occasionally when I want to get a nice overview of all database and table structures, and perform some minor tweaking. I think it's a great tool but I still rely on the command line to perform most tasks. I recommend you learn to use both. There are some good GUI tools but AFAIK they are platform dependent (e.g. MS Windows) so I don't use them.

    Make sure you use the 'SQL box' provided (or the command line) to create and test all queries prior to insertion in your script. Don't just slap some SQL into a script without knowing how it works and what the result set should be (if any).

    One thing I'll caution against, phpMyAdmin has a bad habit of allowing you to create and use reserved words by invisibly surrounding them with `backticks`. You won't know this until you try to execute the query in a standalone PHP script and it fails. At least 50% of all 'query error forum posts' can be attributed to this.

  • #5
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    Quote Originally Posted by YaymeQ View Post
    I'm just learning php and mysql and I'm not sure if I should use some application like phpmyadmin or something else, I'm open to doing things the hard way to better understand it but I'm not sure it's worth it. I haven't gone too far into it yet (Obviously or I'd probably know) so what do you guys suggest?

    Thanks
    ~YaymeQ
    no, I don't use it.
    for testing query, banchmark, ...., I use mysql client on a local server or sometimes mysql query browser, both come with mysql. First is command line, second have a gui, I talk about a linux machine, I have no idea on windows.

    regards

  • #6
    Super Moderator Inigoesdr's Avatar
    Join Date
    Mar 2007
    Location
    Florida, USA
    Posts
    3,647
    Thanks
    2
    Thanked 406 Times in 398 Posts
    Check out the GUIs section in this sticky thread in the MySQL forum for some more choices.

  • #7
    Regular Coder YaymeQ's Avatar
    Join Date
    Feb 2008
    Location
    virginia
    Posts
    140
    Thanks
    14
    Thanked 0 Times in 0 Posts
    Thanks guys, I'll try the command line first and maybe swich if I get to doing stuff that is too easy and tedious. Ha!
    Hopefully I'll avoid those "Query Errors"
    I've got the time to learn.

    ~YaymeQ
    Where is the "any" key??!

  • #8
    New Coder
    Join Date
    Mar 2008
    Location
    Somerset, England
    Posts
    93
    Thanks
    0
    Thanked 10 Times in 10 Posts
    If you're local computer is a windows box and your MySQL server allows connections from a different IP I would recommend SQLyog it's a very easy to use GUI and there is a free version.


  •  

    Posting Permissions

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