This seems like a trivial thing, but one of the biggest slowdowns in my workflow has become logging in to phpmyadmin for creating and modifying tables- my biggest gripe is the complete lack of keyboard support. I just need a simple tool to generate (and run, ideally) create table and alter statements.
Edit: aft开发者_如何转开发er thinking on this a bit, something that was a web-based spreadsheet for me to type into (think Google Docs) with columns for colName, colType, colLength (where applicable) that generated a create table statement would suffice. Does this exist or am I about to code something to use Google Docs?
I would recommend SQLyog but there is a more "professional" tool: navicat lite for mySQL (it has versions for other SQL too like Oracle) or SQL-Front
精彩评论