Hi have installed MySQL on my local PC. I want a front end so that i have a GUI for creating tables, inserting values etc.
I know about SQLYOG but i don't know if its free/open-source. I want to use it in my office, so I can't use pirated stuff.
Any other tool for GUI?
I sometimes really like the MySQL Workbench. It's available free for all the major platforms (Ubuntu, Mac, Windows etc. and the advantage compared to tools like phpMyAdmin is, that you
- have a nice environment for designing your database and not only a tool for querying
- don't need to setup a Apache/IIS for running the tool
Use phpMyAdmin, it's open-source & has some great GUI features.
My choice is "Toad for MySQL". It is a freeware. http://www.quest.com/toad-for-mysql/
try phpmyadmin.I think it is what you are looking for.
i would recommend one of standalone tools instead of setting up whole php/apache stack
i'm not using any of those but quick googling provides some options: mysql workbench, sql yog, sequel pro, heidi sql
I usually use phpMyAdmin if web access is required or I have LAMP stack setup, or otherwise I use MySQL Workbench.
At work I also use SqlDbx which is pretty awesome and does what I need.
I like to use this tool, it is a nice graphic interface that will generate the needed SQL when you save it. You can then just run the SQL on your database.
http://code.google.com/p/wwwsqldesigner/
You can download the free version of SQLyog here: https://code.google.com/p/sqlyog/downloads/list
精彩评论