mSQLÀº ¾ÆÁÖ ÀûÀº ¸Þ¸ð¸®·®À» Â÷ÁöÇÏ¸é¼ ºü¸£°Ô µ¥ÀÌÅ͸¦ ¿¢¼¼½ºÇÒ ¼ö ÀÖµµ·Ï Çϱâ À§ÇØ ¼³°èµÈ °æ·®ÀÇ µ¥ÀÌÅͺ£À̽º ¿£ÁøÀÌ´Ù. À̸§¿¡¼ ¾Ë ¼ö ÀÖµíÀÌ mSQLÀº query ÀÎÅÍÆäÀ̽º·Î SQLÀÇ ºÎºÐÁýÇÕÀ» Á¦°øÇÑ´Ù. mSQLÀº ºä¿Í subquery´Â Á¦°øÇÏÁö ¾Ê´Â´Ù.
ÇöÀç mSQL ÆÐÅ°Áö´Â µ¥ÀÌÅͺ£À̽º ¿£Áø(msql2d), Å͹̳Π¸ð´ÏÅÍ ÇÁ·Î±×·¥(msql), µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥(msqladmin), ½ºÅ°¸¶ ºä¾î(relshow), C ¾ð¾î API¸¦ Á¦°øÇÑ´Ù. ±×¸®°í C API´Â TCP/IP ³×Æ®¿öÅ© »ó¿¡¼ Ŭ¶óÀ̾ðÆ®/¼¹ö ȯ°æ¿¡¼ µ¿ÀÛÇϵµ·Ï µÇ¾î ÀÖ´Ù.
mSQLÀº »ó¿ëµ¥ÀÌÅͺ£À̽º¿Í °°Àº µ¥ÀÌÅͺ£À̽º½Ã½ºÅÛ¿¡ ºñÇØ Ç³ºÎÇÑ ±â´ÉÀ» Á¦°øÇÏÁö´Â ¾ÊÁö¸¸ ºñ±³Àû ¼Ò±Ô¸ðÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ´Ù·ç±â¿¡´Â ÀûÇÕÇÏ´Ù. ¶ÇÇÑ °æ·®ÀÇ µ¥ÀÌÅͺ£À̽º¿£ÁøÀ̱⠶§¹®¿¡ ÀÛÀº ±Ô¸ðÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇؼ´Â ºü¸¥ ¼Óµµ·Î ¼ºñ½º¸¦ Á¦°øÇÒ ¼ö ÀÖ´Ù.
msqladmin
µ¥ÀÌÅͺ£À̽ºÀÇ »ý¼º, »èÁ¦µî µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®Çϴµ¥ »ç¿ëµÈ´Ù.
»ç¿ëÇü½Ä
msqladmin option database
shutdown: ¼¹ö µ¿ÀÛ ÁßÁö
reload: ¼¹ö ȯ°æ ¼³Á¤ Reloading
version: ¼¹ö Á¤º¸ º¸À̱â
stats: ¼¹ö ÀÛµ¿ ½Ã½ºÅÛ È¯°æ º¸À̱â
create: µ¥ÀÌŸº£À̽º »ý¼º
drop: µ¥ÀÌŸº£À̽º »èÁ¦
»ç¿ë¿¹
dBÀÇ »ý¼º. commlab¶ó´Â dB¸¦ »ý¼ºÇÑ´Ù.
% msqladmin create commlab
dBÀÇ »èÁ¦. commlab¶ó´Â dB¸¦ »èÁ¦ÇÑ´Ù.
% msqladmin drop commlab
msql
msqlÀÇ ¸ð´ÏÅÍ ÇÁ·Î±×·¥À¸·Î SQL¹®À» Á÷Á¢ÀÔ·Â, µ¥ÀÌÅ͸¦ Á¶ÀÛÇÒ ¼ö ÀÖ´Ù.
»ç¿ëÇü½Ä
msql [-f conf_file] [-h host] database
-f : ±âº» ¼³Á¤ÈÀÏÀÌ¿ÜÀÇ ¼³Á¤ÆÄÀÏÀ» »ç¿ë
-h : msqlÀÌ Remote È£½ºÆ®¿¡ ¼³Ä¡µÈ °æ¿ì ¿ø°Ý È£½ºÆ®ÀÇ ÁÖ¼Ò
database: Á¢¼ÓÇÏ·Á´Â µ¥ÀÌÅÍ º£À̽º
»ç¿ë¿¹
% msql graduate
Welcome to the miniSQL monitor. Type \h for help.
mSQL >
À§¿¡¼¿Í °°ÀÌ mSQL > ¶ó´Â ÇÁ·ÒÇÁÆ®°¡ º¸À̸é ÀÌ ÇÁ·ÒÇÁÆ®¿¡¼ Á÷Á¢ query ÀÔ·ÂÇÏ°í \g¸¦ ÀÔ·ÂÇϸé query¸¦ ¼öÇàÇϰԵȴÙ. Áï,
mSQL > create table address(name char(8), phone char(15), address text(50))
-> \g
Query OK. 1 row(s) modified or retrieved.
mSQL >
ÁÖÀÇ :
query´Â \g°¡ ¼öÇàµÇ±â Àü±îÁö ¸îÁÙÀÌ¶óµµ ÀÔ·ÂÇÒ ¼ö ÀÖ´Ù. ¸¸¾à, ÀÔ·ÂÇÏ´Â Áß°£¿¡ À߸ø ÀÔ·ÂÇß´Ù¸é, \e ¸í·ÉÀ» ÀÌ¿ëÇؼ ¼öÁ¤ÇÒ ¼ö ÀÖ´Ù.
msqlÀÇ ¸í·É
\g
»ç¿ëÀÚ°¡ ÀÔ·ÂÇÑ query¸¦ dB ¿£ÁøÀ¸·Î Àü¼Û. ½ÇÁ¦ SQL ÁúÀÇ´Â \g¸¦ ÀÔ·ÂÇÒ ¶§ ¼öÇàµÈ´Ù.
\e
ÀÌÀü¿¡ ÀÔ·ÂÇß´ø »ç¿ëÀÚ ÁúÀǸ¦ ¼öÁ¤. vi ÆíÁý±â¸¦ È£ÃâÇؼ ¹Ù·ÎÀü¿¡ ÀÔ·ÂÇÑ ÁúÀǸ¦ ¼öÁ¤ÇÑ´Ù.
\h
°£´ÜÇÑ µµ¿ò¸»À» Ãâ·ÂÇÑ´Ù.
\q
msql ¸ð´ÏÅÍ ÇÁ·Î±×·¥À» Á¾·áÇÑ´Ù.
ÁÖÀÇ :
¸ðµç SQL ÁúÀÇ´Â Çѹø¿¡ Çϳª¸¸ ¼öÇàÇØ¾ß ÇÑ´Ù.
relshow
Shema Viewer·Î¼ msql·Î »ý¼ºÇÑ Å×À̺íÀÇ ½ºÅ°¸¶¸¦ Ãâ·ÂÇÑ´Ù.
»ç¿ëÇü½Ä
µ¥ÀÌÅͺ£À̽ºÀÇ ¸ñ·Ï(relshow)
% relshow
+-----------------+
| Databases |
+-----------------+
| mhlee |
| hee |
| test |
| commlab |
| www |
+-----------------+
Å×ÀÌºí ¸ñ·Ï(relshow database)
% relshow commlab
Database = commlab
+---------------------+
| Table |
+---------------------+
| book |
| testbook |
+---------------------+
Å×ÀÌºí ½ºÅ°¸¶(relshow database table)
% relshow commlab book
Database = commlab
Table = book
+-----------------+----------+--------+----------+--------------+
| Field | Type | Length | Not Null | Unique Index |
+-----------------+----------+--------+----------+--------------+
| class | char | 8 | N | N/A |
| title | char | 80 | N | N/A |
| auth | char | 20 | N | N/A |
| pub | char | 30 | N | N/A |
| pdate | char | 8 | N | N/A |
| sdate | char | 8 | N | N/A |
| cost | char | 6 | N | N/A |
| site | char | 8 | N | N/A |
| state | char | 8 | N | N/A |
+-----------------+----------+--------+----------+--------------+
À§¿¡¼ º¸¿©Áö´Â °Íó·³ relshow¸í·ÉÀ» ÀÌ¿ëÇϸé, Å×À̺íÀÇ Çʵå¸í, ÇÊµå ¼Ó¼º, Not Null ¿©ºÎ, Indexing ¿©ºÎ¸¦ ¾Ë ¼ö ÀÖ´Ù.
msqlexport
µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷À» À§ÇØ µ¥ÀÌÅͺ£À̽º¸¦ ÅؽºÆ® ÆÄÀÏ·Î ÀúÀåÇϴµ¥ »ç¿ëÇÑ´Ù.
»ç¿ëÇü½Ä
msqlexport [-h host] [-v] [-s Char] [-q Char] [-e Char] database table
-v: export °úÁ¤À» ÀÚ¼¼È÷ º¸¿©ÁØ´Ù.
-s: Çʵ带 ºÐ¸®ÇÒ ¶§ »ç¿ëÇÒ ¹®ÀÚ¸¦ ÁöÁ¤ÇÑ´Ù. ±âº»°ªÀº ½°Ç¥(,)
-q: Çʵ带 ÀοëÇÒ ¶§ »ç¿ëÇÒ ¹®ÀÚ¸¦ ÁöÁ¤ÇÑ´Ù.
-e: Escape ¹®ÀÚ¸¦ ÁöÁ¤ÇÑ´Ù. ±âº»°ªÀº ¿ª½½·¡½¬(\)
»ç¿ë¿¹
% msqlexport commlab book
COMM-DSP,Multidimensional Digital Signal Processing,Dan E. Dudgeon
COMM-SS,Digital Communication and Spread Spectrum System,R. E. Ziemer
COMM-MOD,An Introduction to Communication System,A. R. Hambley
STDOUTÀ¸·Î Ãâ·ÂµÇ¹Ç·Î ÆÄÀÏ·Î ÀúÀåÇϱâÀ§Çؼ´Â RedirectionÀ» »ç¿ëÇÑ´Ù.
% msqlexport commlab book > file
msqlimport
´Ù¸¥ µ¥ÀÌÅͺ£À̽º·ÎºÎÅÍ µ¥ÀÌÅ͸¦ °¡Á®¿À°Å³ª ¹é¾÷µÈ µ¥ÀÌÅ͸¦ ÀÔ·ÂÇϴµ¥ »ç¿ëµÈ´Ù.
»ç¿ëÇü½Ä
msqlimport [-h host] [-v] [-s Char] [-e Char] [-q Char] database table
-v: export °úÁ¤À» ÀÚ¼¼È÷ º¸¿©ÁØ´Ù.
-s: Çʵ带 ºÐ¸®ÇÒ ¶§ »ç¿ëÇÒ ¹®ÀÚ¸¦ ÁöÁ¤ÇÑ´Ù. ±âº»°ªÀº ½°Ç¥(,)
-q: Çʵ带 ÀοëÇÒ ¶§ »ç¿ëÇÒ ¹®ÀÚ¸¦ ÁöÁ¤ÇÑ´Ù.
-e: Escape ¹®ÀÚ¸¦ ÁöÁ¤ÇÑ´Ù. ±âº»°ªÀº ¿ª½½·¡½¬(\)
»ç¿ë¿¹
% msqlimport commlab testbook < file
Importing into table 'testbook'
Field 1 is 'class' of type char
Field 2 is 'title' of type char
Field 3 is 'auth' of type char
Field 4 is 'pub' of type char
Field 5 is 'pdate' of type char
Field 6 is 'sdate' of type char
Field 7 is 'cost' of type char
Field 8 is 'site' of type char
Field 9 is 'state' of type char
STDINÀ» ÅëÇØ ÀÔ·ÂÇØ¾ß ÇϹǷΠÆÄÀϷκÎÅÍ ÀÔ·ÂÇϱâÀ§Çؼ´Â RedirectionÀ» »ç¿ëÇÑ´Ù.
% msqlexport commlab book < file
msqldump
Å×ÀÌºí ½ºÅ°¸¶¸¦ Æ÷ÇÔÇÑ Àü µ¥ÀÌÅͺ£À̽ºÀÇ SQL¹®À» ASCII·Î ÀúÀåÇϴµ¥ »ç¿ëµÈ´Ù.
»ç¿ëÇü½Ä
msqldump [-h host] [-f conf] database [table]
-h: ¿ø°Ý È£½ºÆ®ÀÇ ÁÖ¼Ò
-f: ¼³Á¤ÆÄÀϸí
database: µ¥ÀÌÅͺ£À̽ºÀÇ À̸§
table: Å×À̺íÀÇ À̸§
»ç¿ë¿¹
msqldump commlab book
#
# mSQL Dump (requires mSQL 2.0 Beta 5 or newer)
#
# Host: localhost Database: commlab
#--------------------------------------------------------
#
# Table structure for table 'book'
#
CREATE TABLE book (
class CHAR(8),
title CHAR(80),
auth CHAR(20),
pub CHAR(30),
pdate CHAR(8),
sdate CHAR(8),
cost CHAR(6),
site CHAR(8),
state CHAR(8)
) \g
INSERT INTO book VALUES ('COMM-MOD','Digital Communications','I. A. Glover','Pr
entice-Hall','19980101','19980105','12000','','304')\g
INSERT INTO book VALUES ('COMP-MAN','SoftICE - Command Reference','NuMega','NuM
ega','19960101','19970204','5000','','Áý')\g
STDOUTÀ¸·Î Ãâ·ÂµÇ¹Ç·Î ÆÄÀÏ·Î ÀúÀåÇϱâÀ§Çؼ´Â RedirectionÀ» »ç¿ëÇÑ´Ù.
% msqldump commlab book > file