Virajsinh

MySQL_Build_Sytem_SubLime

Nov 26th, 2019
57
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sublime MySQL Build System for UBUNTU
  2.  
  3. {
  4.     "cmd": ["/opt/lampp/bin/mysql", "-u", "root", "-e", "source $file", "-t"],
  5.     "selector": "source.sql"
  6. }
  7. ---------------------------------------------------
  8. Make Any commnad.sql file And Type MySQL Command.
  9. Press "Ctrl + B"
  10.  
  11. ---------------------------------------------------
  12. /opt/lampp/bin/mysql -u root //MySQL Path
  13. use DataBaseName             //DataBaseName
  14. show tables;
  15. ---------------------------------------------------
  16. SELECT tbl_subcategory.*, tbl_category.name AS category_id_name FROM tbl_subcategory, tbl_category WHERE tbl_category.id = tbl_subcategory.category_id
RAW Paste Data