PDA

View Full Version : [other] Re: MySQL Editor? What's good for a beginner?



danap_n_mt
June 7th, 2009, 09:05 PM
The following often appears as a link to the MyJSQLView project
from the Ubuntu Forum in of June 2007 and I would like to answer.
At the time MyJSQLView may not of been able to pull in a .xls
sheet, but it does now. Just save it as .csv text format then
import. MyJSQLView will either insert or update the data provided
you have a database table created with the proper fields.

danap.

> MySQL Editor? What's good for a beginner?
> I just ran across this http://myjsqlview.sourceforge.net/
> and was wondering if anyone has experience with other SQL
> editors for complete n00bs.

> Basically I am looking to be able to take an .xls sheet,
> edit it, and convert the output to integrate into an existing
> SQL database, to be managed online via myPHPadmin.

> Any suggestions would be greatly appreciated

cmnorton
June 10th, 2009, 12:25 AM
To me, SQL is not like C, Java, or Python. I am not sure it is critical that you have syntax highlighting. If SQL is embedded in source code, you would get syntax highlighting based on your language from your programmer's editor.

You can download various gui clients that will give you a default editor. I have used vim and Epsilon to construct SQL scripts that are executed from the command line.