11 Ọganihu MySQL Database Ajụjụ na Azịza ajụjụ ọnụ maka ndị ọrụ Linux


Anyị ebipụtalarị akụkọ MySQL abụọ, Tecmint Community nwere ekele maka ya. Nke a bụ edemede nke atọ na usoro ajụjụ ọnụ MySQL na iri na isii na kọlụm ụdị ajụjụ ọnụ.

  1. 15 Ajụjụ ajụjụ ọnụ MySQL
  2. 10 MySQL Database Ajụjụ ajụjụ ọnụ maka ndị etiti

Anyị erutela ebe a niile n'ihi nkwado gị ma anyị na-achọ otu ihe ahụ n'ọdịnihu na-etolite njedebe gị. N'ebe a n'isiokwu a, anyị ga-elekwasị anya na akụkụ bara uru nke MySQL, ajụjụ dị mkpa maka akụkụ ajụjụ ọnụ.

Azịza: Iwu MySQL nke dị n'okpuru ga-egosi ụdị nkesa na ebe nchekwa data ahọpụtara ugbu a.

mysql> SELECT VERSION(), DATABASE();

+-------------------------+------------+
| VERSION()               | DATABASE() |
+-------------------------+------------+
| 5.5.34-0ubuntu0.13.10.1 | NULL       |
+-------------------------+------------+
1 row in set (0.06 sec)

N'ime kọlụm nchekwa data ọ na-egosi uru NULL n'ihi na anyị ahọrọbeghị nchekwa data ọ bụla. Yabụ, họrọ nchekwa data dị ka egosiri na iwu a.

mysql> use Tecmint;

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select VERSION(), DATABASE();

+-------------------------+------------+
| VERSION()               | DATABASE() |
+-------------------------+------------+
| 5.5.34-0ubuntu0.13.10.1 | tecmint    |
+-------------------------+------------+
1 row in set (0.00 sec)

Azịza: Nkwupụta dị n'okpuru ga-egosi kọlụm niile nke ndị ọrụ site na tebụl 'Tecmint' ewezuga onye ọrụ ' SAM.

mysql> SELECT * FROM Tecmint WHERE user !=SAM;

+---------------------+---------+---------+---------+---------+-------+ 
| date                | user    | host 	 | root     | local   | size  | 
+---------------------+---------+---------+---------+---------+-------+ 
| 2001-05-14 14:42:21 | Anthony | venus  | barb     | venus   | 98151 | 
| 2001-05-15 08:50:57 | TIM     | venus  | phil     | venus   | 978   | 
+---------------------+---------+---------+---------+---------+-------+

Azịza: A na-eji onye na-arụ ọrụ AND mgbe anyị na-eji (=) ma onye ọrụ OR na-eji ya mgbe anyị na-eji (!=). Ihe atụ nke (=) na AND Operator.

mysql> SELECT * FROM mail WHERE user = SAM AND root = phil

Ọmụmaatụ nke (!=) na onye ọrụ ma ọ bụ.

mysql> SELECT * FROM mail WHERE user != SAM OR root != phil

+---------------------+---------+---------+---------+---------+-------+ 
| date                | user    | host    | root    | local   | size  | 
+---------------------+---------+---------+---------+---------+-------+ 
| 2001-05-14 14:42:21 | Anthony | venus   | barb    | venus   | 98151 | 
+---------------------+---------+---------+---------+---------+-------+

  1. = : pụtara nhata na
  2. != : Haghị
  3. ! : na-anọchi anya Ọ BỤGHỊ onye ọrụ

A na-emeso AND & OR dị ka ndị na-arụ ọrụ na MySQL.

Azịza: Enwere ike dee ajụjụ dị na MySQL nke ọma site na iji nkwupụta IFNULL(). Nkwupụta IFNULL() nwale arụmụka mbụ ya wee laghachi ma ọ bụrụ na ọ bụghị NULL, ma ọ bụ weghachi arụmụka nke abụọ ya, ma ọ bụghị ya.

mysql> SELECT name, IFNULL(id,'Unknown') AS 'id' FROM taxpayer;

+---------+---------+ 
| name 	  | id      | 
+---------+---------+ 
| bernina | 198-48  | 
| bertha  | Unknown | 
| ben     | Unknown | 
| bill    | 475-83  | 
+---------+---------+

Azịza: Anyị kwesịrị iji nkeji LIMIT yana ORDER BY iji nweta ọnọdụ ahụ akọwara n'elu.

mysql> SELECT * FROM name LIMIT 1;

+----+------+------------+-------+----------------------+------+ 
| id | name | birth      | color | foods                | cats | 
+----+------+------------+-------+----------------------+------+ 
| 1  | Fred | 1970-04-13 | black | lutefisk,fadge,pizza | 0    | 
+----+------+------------+-------+----------------------+------+
mysql> SELECT * FROM profile LIMIT 5;

+----+------+------------+-------+-----------------------+------+ 
| id | name | birth      | color | foods                 | cats | 
+----+------+------------+-------+-----------------------+------+ 
| 1  | Fred | 1970-04-13 | black | lutefisk,fadge,pizza  | 0    | 
| 2  | Mort | 1969-09-30 | white | burrito,curry,eggroll | 3    | 
| 3  | Brit | 1957-12-01 | red   | burrito,curry,pizza   | 1    |   
| 4  | Carl | 1973-11-02 | red   | eggroll,pizza         | 4    | 
| 5  | Sean | 1963-07-04 | blue  | burrito,curry         | 5    | 
+----+------+------------+-------+-----------------------+------+
mysql> SELECT * FROM profile ORDER BY birth LIMIT 1;

+----+------+------------+-------+----------------+------+ 
| id | name | birth      | color | foods          | cats | 
+----+------+------------+-------+----------------+------+ 
| 9  | Dick | 1952-08-20 | green | lutefisk,fadge | 0    | 
+----+------+------------+-------+----------------+------+

Azịza: Ọfọn, ha abụọ nwere uru na ọghọm ya. Ka oge na-aga, m na-ahọrọ MySQL.

  1. Mysql bụ FOSS.
  2. MySQL nwere ike ibugharị.
  3. MySQL na-akwado ma GUI yana Command Prompt.
  4. A na-akwado nchịkwa MySQL n'ihe nchọgharị ajụjụ.

Azịza: Inweta ụbọchị dị ugbu a na MySQL dị mfe dị ka imezu nkwupụta Nhọrọ dị n'okpuru.

mysql> SELECT CURRENT_DATE();

+----------------+
| CURRENT_DATE() |
+----------------+
| 2014-06-17     |
+----------------+

Azịza: Anyị na-eji nhọrọ '-e' (bupu) ibupu tebụl MySQL ma ọ bụ nchekwa data niile n'ime faịlụ XML. Na nnukwu tebụl anyị nwere ike iji aka mejuputa ya mana maka obere tebụl, ngwa dị ka phpMyAdmin nwere ike ịrụ ọrụ ahụ.

Iwu obodo MySQL nwere ike ime ya.

mysql -u USER_NAME –xml -e 'SELECT * FROM table_name' > table_name.xml

Ebe USER_NAME bụ aha njirimara data, table_name bụ tebụl anyị na-ebupụ na XML na table_name.xml bụ faịlụ xml ebe echekwara data.

Azịza: MySQL_pconnect() na-emepe njikọ na-adịgide adịgide na MySQL Database nke pụtara na anaghị emeghe nchekwa data oge ọ bụla ibe na-ebu ibu ya mere anyị enweghị ike iji MySQL_close() mechie njikọ na-adịgide adịgide.

Ọdịiche dị n'etiti MySQL_pconnect na MySQL_connect bụ.

N'adịghị ka MySQL_pconnect, MySQL_connect - Mepee Database oge ọ bụla na-ejuru ibe nke nwere ike mechie oge ọ bụla site na iji nkwupụta MySQL_close().

Azịza: Iwu na-esote ga-egosi ndeksi niile nke onye ọrụ' tebụl.

mysql> show index from user;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | 
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 
| user  |          0 | PRIMARY  |            1 | Host        | A         |        NULL |     NULL | NULL   |      | BTREE      |         |               | 
| user  |          0 | PRIMARY  |            2 | User        | A         |           4 |     NULL | NULL   |      | BTREE      |         |               | 
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 
2 rows in set (0.00 sec)

Azịza: CSV na-anọchi anya ụkpụrụ rịkọm-iche aka aka Character-Separated Values. Tebụl CSV na-echekwa data n'ime ederede doro anya yana usoro tabul. Ọ na-enwekarị otu ndekọ kwa ahịrị.

Ekewapụrụ ndekọ ọ bụla site na ndị na-akpachapụ anya (Comma, Semi-colon,…) ebe ndekọ ọ bụla nwere otu usoro nke ubi. A na-ejikarị tebụl CSV eme ihe iji chekwaa kọntaktị ekwentị na mbubata na mbupụ ma nwee ike iji chekwaa ụdị data ederede ọ bụla.

Nke ahụ bụ ihe niile ugbu a. Aga m anọ ebe a ọzọ na akụkọ ọzọ na-atọ ụtọ, ị ga-enwe mmasị ịgụ. Ruo mgbe ahụ nọrọ na nche ma jikọọ na Tecmint ma echefula ịnye anyị nzaghachi bara uru gị na ngalaba nkọwa n'okpuru.