So far I have tried this http://www.youtube.com/watch?v=tPd4m3PLVqU but no luck. Here is what I have tried. And I saved it in custom packages in exalted text 2, and then tried to run the select command using command B.
{
"cmd": ["mysql", "-u", "markrios", "-e", "source $file"],
"selector": "source.sql"
}
Also, I apologize in advance if this is a stupid question.
OSX 10.9.1. Sublime Text 2 Server Version: 5.6.15 MySQL Community Server (GPL)
By the way, I am currently using MySQL Workbench, but I would like to use Sublime. Syntax highlighting is better in Sublime (in my opinion).
Any help would be appreciated! Thank!
@MattDMo Update 1: 2/20/14 5:37 PM PST after running use cisp;in Sublime I get the following
[Errno 2] No such file or directory
[cmd: [u'mysql', u'-u', u'markrios', u'-e', u'source /Users/markrios/test.html']]
[dir: /Users/markrios]
[path: /usr/bin:/bin:/usr/sbin:/sbin]
[Finished]
I am also confused about how the sublime text building system knows which password to use to login to mysql. When I enter the terminal with this command mysql -umarkrios -pand then I get this message `Marks-MacBook-Air-2: ~ markrios $ mysql -umarkrios -p Enter the password: Welcome to the MySQL monitor. The teams end; or \ g. Your MySQL connection identifier is 11 Server version: 5.6.15 MySQL Community Server (GPL)
Copyright (c) 2000, 2013, Oracle and / or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and / or its branch. Other names may be trademarks of their respective owners.
"help"; '\ h' . '\ c', . `
- - Sublime Text 2:
`mysql> select Holiday.* from Holiday;
+ -------------------- + ------------ + ------------ --- +
| | | |
+ -------------------- + ------------ + --------------- +
| | 2012-12-25 | 2012-12-25 |
| COLUMBUS | 2012-10-08 | 2012-10-08 |
| | 2012-07-04 | 2012-07-04 |
| | 2012-09-03 | 2012-09-03 |
| MARTIN LUTHER KING | 2012-01-15 | 2012-01-16 |
| | 2012-05-28 | 2012-05-28 |
| | 2012-01-01 | 2012-01-02 |
| | 2012-02-20 | 2012-02-20 |
| THANKSGIVING | 2012-11-22 | 2012-11-22 |
| | 2012-11-11 | 2012-11-12 |
+ -------------------- + ------------ + --------------- +
10 (0,01 )
mysql > `