MyCLI - Abokin Ciniki na MySQL/MariaDB tare da Kammalawar Kai-da-kai da Haskakawa-Syntax

MyCLI shine layin umarni mai sauƙi don amfani (CLI) don shahararrun tsarin sarrafa bayanai: MySQL, MariaDB, da Percona tare da cikawa ta atomatik da nuna alama. An gina shi ta amfani da Quick_toolkit kuma yana buƙatar Python 2.7, 3.3, 3.4, 3.5, da 3.6. Yana goyan bayan amintattun haɗi akan SSL zuwa uwar garken MySQL.

  • Lokacin da kuka fara shi, ana ƙirƙirar fayil ɗin daidaitawa ta atomatik a ~/.myclirc.
  • Yana goyan bayan kammalawa ta atomatik yayin buga kalmomin SQL da kuma teburi, ra'ayoyi da ginshiƙai a cikin bayanan.
  • Hakanan yana goyan bayan kammalawa mai wayo wanda aka kunna ta tsohuwa kuma zai ba da shawarwari don kammalawa mai hankali.

Misali:

SELECT * FROM <Tab> - this will just show table names. 
SELECT * FROM users WHERE <Tab> - this will simply show column names.

  • Yana goyan bayan yin hasashe ta hanyar amfani da Pygments.
  • Tallafi don haɗin yanar gizo na SSL.
  • Yana ba da tallafi don tambayoyin layi ɗaya.
  • Yana ba da damar yin rajistar kowace tambaya da fitarwa zuwa fayil (lura cewa an kashe shi ta tsohuwa).
  • Yana ba ku damar adana tambayoyin da kuka fi so (ajiye tambaya ta amfani da laƙabin kuma gudanar da shi da laƙabi).
  • Yana goyan bayan lokacin bayanan SQL da ma'anar tebur.
  • Yana buga bayanan tambura a hanya mai ban sha'awa.

Yadda ake Sanya MyCLI don MySQL da MariaDB a cikin Linux

A kan rarraba Debian/Ubuntu, zaku iya shigar da kunshin mycli cikin sauƙi ta amfani da umarnin da ya dace kamar haka:

$ sudo apt-get update
$ sudo apt-get install mycli

Hakanan, Fedora 22+ yana da kunshin samuwa don mycli, zaku iya shigar da shi ta amfani da umarnin dnf kamar ƙasa:

$ sudo dnf install mycli

Don sauran rarrabawar Linux kamar RHEL/CentOS, kuna buƙatar kayan aikin Python pip don shigar da mycli. Fara da shigar pip tare da umarnin da ke ƙasa:

$ sudo yum install pip

Da zarar an shigar da pip, zaku iya shigar da mycli kamar haka:

$ sudo pip install mycli

Yadda ake amfani da MyCLI don MySQL da MariaDB a cikin Linux

Da zarar an shigar da mycli, zaku iya amfani da shi kamar haka:

$ mycli -u root -h localhost

Sauƙaƙan kammalawa kamar keywords da ayyukan sql.

Sunan tebur yana ƙare bayan kalmar 'DAGA'.

Ƙarshen ginshiƙi zai yi aiki ko da lokacin da aka haɗa sunayen tebur.

Ƙaddamar da syntax don MySQL.

Ana fitar da fitarwa ta MySQL ta atomatik ta hanyar ƙaramin umarni.

Don shiga cikin mysql kuma zaɓi bayanan bayanai a lokaci guda, zaku iya amfani da irin wannan umarni kamar haka.

$ mycli local_database
$ mycli -h localhost -u root app_db
$ mycli mysql://[email :3306/django_poll

Don ƙarin zaɓuɓɓukan amfani, rubuta:

$ mycli --help

Shafin Farko na MyCLI: http://mycli.net/index

Duba wasu labarai masu amfani don gudanar da MySQL.

  1. 20 MySQL (Mysqladmin) Umarni don Gudanar da Database a Linux
  2. Yadda ake Canja Tsohuwar Jagorar Bayanan Bayanan MySQL/MariaDB a cikin Linux
  3. 4 Kayan Aikin Layi Mai Amfani don Kula da Ayyukan MySQL a cikin Linux
  4. Yadda ake Canja Tushen Kalmar wucewa ta MySQL ko MariaDB a cikin Linux
  5. Ajiyayyen MySQL da Dawo da Dokokin don Gudanarwar Database

Shi ke nan! A cikin wannan jagorar, mun nuna yadda ake shigarwa da amfani da mycli tare da umarni masu sauƙi a cikin Linux. Raba tunanin ku game da wannan labarin ta hanyar amsawar da ke ƙasa.