MyCLI - Onye ahịa MySQL/MariaDB nwere mmecha akpaaka yana ngosipụta-nkọwapụta

MyCLI bụ akara ahịrị iwu dị mfe iji (CLI) maka sistemu njikwa nchekwa data ama ama: MySQL, MariaDB na Percona nwere mmecha akpaaka na ngosiputa syntax. Ewubere ya site na iji Quick_toolkit ma chọọ Python 2.7, 3.3, 3.4, 3.5, na 3.6. Ọ na-akwado njikọ echekwara n'elu SSL na sava MySQL.

  • Mgbe ịmalitere ya, a ga-emepụta faịlụ nhazi na-akpaghị aka na ~/.myclirc.
  • Na-akwado mmecha akpaaka ka ị na-ede mkpụrụokwu SQL yana tebụl, echiche na kọlụm dị na nchekwa data.
  • Na-akwadokwa smart-emecha nke a na-enyere ya aka na ndabara yana ọ ga-enye ntụnye maka mmecha nke nwere mmetụta gburugburu.

Dị ka ọmụmaatụ:

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

  • Na-akwado iji Pygments pụta ìhè.
  • Nkwado maka njikọ SSL.
  • Na-enye nkwado maka ajụjụ ọnụọgụgụ ọtụtụ.
  • Ọ na-edobe ajụjụ ọ bụla na mmepụta ya na faịlụ (rịba ama na nke a nwere nkwarụ site na ndabara).
  • Na-enye gị ohere ịchekwa ajụjụ ọkacha mmasị (chekwaa ajụjụ site na iji utu aha wee jiri utu mee ya).
  • Na-akwado oge nke nkwupụta SQL na nsụgharị tebụl.
  • Na-ebipụta data tabular n'ụzọ mara mma.

Otu esi etinye MyCLI maka MySQL na MariaDB na Linux

Na nkesa Debian/Ubuntu, ị nwere ike ịwụnye ngwugwu mycli ngwa ngwa site na iji iwu dabara dị ka ndị a:

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

N'otu aka ahụ, Fedora 22+ nwere ngwugwu dị maka mycli, ị nwere ike tinye ya site na iji iwu dnf dị ka n'okpuru:

$ sudo dnf install mycli

Maka nkesa Linux ndị ọzọ dị ka RHEL/CentOS, ị ga-achọ ngwa Python pip iji wụnye mycli. Malite site na ịwụnye pip na iwu dị n'okpuru:

$ sudo yum install pip

Ozugbo etinyere pip, ị nwere ike iwunye mycli dị ka ndị a:

$ sudo pip install mycli

Otu esi eji MyCLI maka MySQL na MariaDB na Linux

Ozugbo etinyere mycli, ị nwere ike iji ya dị ka nke a:

$ mycli -u root -h localhost

Mmecha dị mfe dị ka isi okwu na ọrụ sql.

Emechara aha tebụl ka mkpụrụokwu 'FROM' gachara.

Emecha kọlụm ga-arụ ọrụ ọbụlagodi mgbe akpọkọtara aha tebụl.

Ngosipụta syntax maka MySQL.

A na-ebunye mmepụta MySQL na-akpaghị aka site na obere iwu.

Iji banye na mysql wee họrọ nchekwa data n'otu oge, ịnwere ike iji iwu yiri nke a.

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

Maka nhọrọ ojiji ọzọ, pịnye:

$ mycli --help

Ebe obibi MyCLI: http://mycli.net/index

Lelee ụfọdụ akụkọ bara uru maka nchịkwa MySQL.

  1. 20 MySQL (Mysqladmin) Iwu maka nchịkwa nchekwa data na Linux
  2. Etu esi agbanwe akwụkwọ ndekọ data MySQL/MariaDB na Linux
  3. 4 Ngwa iwu iwu bara uru iji nyochaa arụmọrụ MySQL na Linux
  4. Etu esi agbanwe paswọọdụ MySQL ma ọ bụ MariaDB na Linux
  5. MySQL ndabere na weghachite iwu maka nchịkwa data

Ọ gwụla! N'ime ntuziaka a, anyị gosipụtara otu esi etinye na iji mycli nwere iwu dị mfe na Linux. Kekọrịta echiche gị gbasara akụkọ a site na mpempe nzaghachi n'okpuru.