Advertisement
Virajsinh

MySQL_Build_Sytem_SubLime

Nov 26th, 2019 (edited)
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.76 KB | None | 0 0
  1. // --> Tools --> Build System --> Build New System
  2.  
  3. Sublime MySQL Build System for UBUNTU
  4.  
  5. {
  6.     "cmd": ["/opt/lampp/bin/mysql", "-u", "root", "-e", "source $file", "-t"],
  7.     "selector": "source.sql"
  8. }
  9. ---------------------------------------------------
  10. Make Any commnad.sql file And Type MySQL Command.
  11. Press "Ctrl + B"
  12.  
  13. ---------------------------------------------------
  14. /opt/lampp/bin/mysql -u root //MySQL Path
  15. use DataBaseName             //DataBaseName
  16. show tables;
  17. ---------------------------------------------------
  18. SELECT tbl_subcategory.*, tbl_category.name AS category_id_name FROM tbl_subcategory, tbl_category WHERE tbl_category.id = tbl_subcategory.category_id
  19.  
  20. Mac Path : "/Applications/XAMPP/xamppfiles/bin/mysql"
  21. Win Path : "D:\\xampp\\mysql\\bin\\mysql.exe"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement