¸®´ª½º °ü·Ã °Á¶õ |
---|
Á¦¸ñ | PHP/FI #3 1999/01/02 (10:40) |
À̸§ | ±èÈ¿¿ø |
¹øÈ£ | 74 |
Á¶È¸ | 524 |
º»¹® |
¡º¸®´ª½º Çдç-¸®´ª½º °Á / ¿¬Àç (go LINUX)¡» 430¹ø Á¦ ¸ñ:[°ÁÂ03] PHP/FI ¸¦ ÀÌ¿ëÇÑ ÀÎÆ®¶ó³Ý±¸Ãà ¿Ã¸°ÀÌ:kingcrab(¹ÚÀçÈ ) 97/03/22 12:06 ÀÐÀ½:1354 °ü·ÃÀÚ·á ¾øÀ½ ----------------------------------------------------------------------------- ------------------------------------------------------------------------------ II. Basic Usage ------------------------------------------------------------------------------ 1. mSQL ------- 1.1 ¼Ò°³ mSQL Àº mini SQL À̶ó°íµµ Çϸç, ANSI SQL ±¸¹®À» Áö¿øÇÏ´Â, À̸§±×´ë·Î Å©±â°¡ ÀÛ Àº µ¥ÀÌŸº£À̽º ¿£ÁøÀÌ´Ù. ÀÌ µ¥ÀÌŸº£À̽º´Â ¸¹Àº À¯´Ð½º Ç÷§Æû¿¡¼ ÀûÀº ¸Þ¸ð¸® ÇÏ¿¡¼ ºü¸¥ ¾ï¼¼½º¸¦ Á¦°øÇϸç, ±× ¸ñÀûÀ¸·Î ¸¸µé¾îÁ³´Ù. mSQL ¹èÆ÷º»¿¡´Â mSQL ¼ ¹ö, Ŭ¶óÀ̾ðÆ® ÇÁ·Î±×·¥µé, Ŭ¶óÀ̾ðÆ® ¼ÒÇÁÆ®¿þ¾î¿¡ ´ëÇÑ C ÇÁ·Î±×·¡¹Ö ÀÎÅÍÆäÀ̽º, ±×¸®°í ¿©·¯°¡Áö ÅøµéÀÌ Æ÷ÇԵǾîÀÖ´Ù. mSQL Àº °£´ÜÇÑ Å¬¶óÀ̾ðÆ®-¼¹ö ±¸Á¶·Î µÇ¾îÀÖ´Ù. ¼¹ö´Â µ¥ÀÌŸº£À̽º¸¦ À¯Áöº¸¼ö Çϸç, Ŭ¶óÀ̾ðÆ®·ÎºÎÅÍÀÇ ÀÔ·ÂÀ» ¹Þ°í ±×¿¡ ÇØ´çÇÏ´Â ÀÀ´äÀ» ÇÑ´Ù. ±âº»ÀûÀ¸·Î »ç¿ë ÇؾßÇÒ Å¬¶óÀ̾ðÆ® ÇÁ·Î±×·¥µéÀº ´ÙÀ½°ú °°´Ù. * msql - mSQL Å͹̳Π¸ð´ÏÅÍ -- Äõ¸®¸¦ ÀÔ·ÂÇÏ´Â ´ëÈÇü ÇÁ·Î±×·¥ * relshow - mSQL ±¸¼º ºä¾î -- ¼¹ö¿¡ ÀÖ´Â µ¥ÀÌŸº£À̽ºÀÇ ¸ñ·Ï°ú µ¥ÀÌŸº£À̽º¿¡ ÀÖ´Â Å×À̺íÀÇ ¸ñ·ÏÀ» º¸¿©ÁØ´Ù. * msqldump - mSQL µ¥ÀÌŸº£À̽º ´ýÆÛ -- msql ·Î ·ÎµùµÇ¾îÁö´Â SQL ±¸¹®ÀÇ µ¥ÀÌŸ º£À̽º¸¦ ASCII ·Î ÀÛ¼ºÇØÁØ´Ù. Ãß°¡·Î, mSQL °ü¸®ÀÚÀÏ °æ¿ì¿¡´Â mSQL ¼¹ö¸¦ °ü¸®ÇÏ´Â msqladmin ÇÁ·Î±×·¥µµ ÀÖ´Ù. µ¥ÀÌŸº£À̽º¸¦ »õ·Î ¸¸µç´Ù´øÁö, ¾ï¼¼½º Á¦¾î ÆÄÀÏÀ» ´Ù½Ã ·ÎµåÇÏ´Â µîÀÇ °æ¿ì¿¡ »ç ¿ëÇÑ´Ù. ¹°·Ð ¼¹ö¸¦ ¼Ë´Ù¿î½Ãų °æ¿ì¿¡µµ, µ¥ÀÌŸº£À̽º¸¦ »èÁ¦½Ãų °æ¿ì¿¡µµ »ç¿ë ÇÑ´Ù. 1.2 mSQL ÀÇ ±âº» »ç¿ë¹ý 1.2.1 ¼¹ö¿¡ Á¢±ÙÇÏ´Â ¹æ¹ý mSQL ¼¹ö¸¦ ¾ï¼¼½ºÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ¼öÇàÇÏ¸é µÈ´Ù. À̸¦ ½ÇÇà½ÃÅ°±âÀü¿¡ ¹Ýµå½Ã msql2d (mSQL ¼¹ö) °¡ ½ÇÇàÁß¿¡ ÀÖ¾î¾ß ÇÑ´Ù. $ relshow +-----------------+ | Databases | +-----------------+ | w3-msql | | bookmarks | | phpfi | +-----------------+ ¸®¸ðÆ®¸Ó½®¿¡ mSQL ¼¹ö°¡ µ¿ÀÛÁß¿¡ ÀÖÀ» ¶§¿¡´Â ´ÙÀ½°ú °°ÀÌ ÇØ´ç È£½ºÆ®¸íÀ» Àû¾î ÁÙ ¼öµµ ÀÖ´Ù. $ relshow -h css35.kr.unisys.com 1.2.2 ¾î¶² µ¥ÀÌŸº£À̽ºµéÀÌ Àִ°¡? relshow ¸¦ ÀÎÀÚ¾øÀÌ ½ÇÇà½Ãų °æ¿ì¿¡´Â µ¥ÀÌŸº£À̽ºµéÀÇ ¸ñ·ÏÀ» º¸¿©ÁØ´Ù. mSQL Àº ¾²±â, Àб⸦ Á¦ÇÑ ÇÒ ¼ö ÀÖ´Â °£´ÜÇÑ ¾ï¼¼½º Á¦¾î ¸ÞÄ«´ÏÁòÀ» °¡Áö°í ÀÖÀ¸¹Ç·Î ´ÙÀ½ °ú °°ÀÌ ±ÇÇÑÀÌ ÁÖ¾îÁöÁö¾ÊÀº µ¥ÀÌŸº£À̽º¸¦ ¾ï¼¼½ºÇÏ·Á°í ÇÒ °æ¿ì¿¡´Â Á¢±ÙÀ» Çã°¡ ÇÏÁö¾Ê´Â´Ù. $ relshow phpfi Access to database denied 1.2.3 »õ·Î¿î µ¥ÀÌŸº£À̽º ¸¸µé±â ¿À·ÎÁö DBA(DataBase Administrator)¸¸ÀÌ mSQL ¿¡ µ¥ÀÌŸº£À̽º¸¦ Ãß°¡Çϰųª »èÁ¦ÇÒ ¼ö ÀÖ´Ù.(DBA ´Â mSQL À» ¼³Ä¡ÇÒ ¶§ Á¤ÀÇÇØÁØ´Ù.) ÀÌ µÎ°¡Áö °æ¿ì´Â msqladmin ¸í·É À¸·Î ½ÇÇàµÈ´Ù. $ msqladmin create linux $ msqladmin drop linux »õ·Î¿î µ¥ÀÌŸº£À̽º¸¦ ¸¸µé¾ú´Ù¸é msql.acl ÆÄÀÏ¿¡ ¾ï¼¼½º ŸÀÔÀ» Á¤ÀÇÇØÁÙ ¼ö ÀÖ´Ù. I ÀåÀÇ ¼Â¾÷ºÎºÐÀ» Âü°íÇϱ⠹ٶõ´Ù. DBA ´Â ´ÙÀ½°ú °°ÀÌ msqladmin ¸í·ÉÀ¸·Î µ¥ÀÌŸº£À̽º¸¦ ¼Ë´Ù¿î½ÃÅ°°Å³ª, ¾ï¼¼½º Á¦ ¾îÆÄÀÏÀ» ´Ù½Ã ·ÎµùÇÒ ¼ö ÀÖ´Ù. $ msqladmin shutdown $ msqladmin reload 1.2.4 µ¥ÀÌŸº£À̽º ±¸¼º »ìÇDZâ relshow ¸í·ÉÀ» ½ÇÇàÇÒ ¶§ µ¥ÀÌŸº£À̽º¸íÀ» Àû¾îÁÖ¸é µ¥ÀÌŸº£À̽º¿¡ Æ÷ÇԵǾîÀÖ´Â ¸ðµç Å×À̺íÀÌ ³ªÅ¸³ª°Ô µÈ´Ù. ¶Ç µ¥ÀÌŸº£À̽º¸í°ú Å×À̺í¸íÀ» Àû¾îÁÖ¸é ±× Å×À̺í ÀÇ ±¸¼ºÀ» ³ªÅ¸³½´Ù. $ relshow w3-msql Database = w3-msql +---------------------+ | Table | +---------------------+ | namespaces | | areas | | area_acl | | users | | perms | | group_members | | groups | | group_admin | +---------------------+ $ relshow w3-msql namespaces Database = w3-msql Table = namespaces +-----------------+----------+--------+----------+--------------+ | Field | Type | Length | Not Null | Unique Index | +-----------------+----------+--------+----------+--------------+ | namespace | char | 50 | N | N/A | | descr | char | 50 | N | N/A | +-----------------+----------+--------+----------+--------------+ 1.2.5 µ¥ÀÌŸº£À̽ºÀÇ Á¶Á¤ msql Ŭ¶óÀ̾ðÆ® ÇÁ·Î±×·¥Àº ƯÁ¤ µ¥ÀÌŸº£À̽º¿¡ ´ëÇØ SQL ±¸¹®À» Á÷Á¢ ÀÔ·ÂÇÒ ¼ö ÀÖ°Ô ÇØÁÖ´Â ´ëÈÇü ÇÁ·Î±×·¥ÀÌ´Ù. ¾Æ·¡¿Í °°ÀÌ SQL ±¸¹®À¸·Î µÇ¾îÀÖ´Â ÆÄÀÏÀ» ¸¸µé°í µ¥ÀÌŸº£À̽º¿¡ Å×À̺íÀ» ¸¸µé°í µ¥ÀÌŸµéÀ» ÀÔ·ÂÇÒ ¼ö ÀÖ´Ù. -[linuxer.msql]---------------------------------------------------------------- CREATE TABLE linuxer ( name char(8), id char(8), telephone char(13), job char(20), age char(2) )\g INSERT INTO linuxer VALUES ('À¯Çü¸ñ','¿¥ºê¸®¿À','015-298-5000','LG Á¤º¸Åë½Å', '29')\g INSERT INTO linuxer VALUES ('¹ÚÀçÈ','kingcrab','015-8301-8000','Çѱ¹À¯´Ï½Ã½º' ,'28')\g INSERT INTO linuxer VALUES ('·ù°æÈ£','lovest','781-6000','Çѱ¹ IBM','28')\g INSERT INTO linuxer VALUES ('À̸¸¿ë','geoman','015-966-2000','³ª¿ì¸®´ª½ºµ¿½Ã »ð','27')\g INSERT INTO linuxer VALUES ('ÀÌÁ¤ÈÆ','facultas','012-326-8000','¿¬¼¼´ë Àü±â°ø Çаú','25')\g ------------------------------------------------------------------------------ $ msql linux < linuxer.msql mSQL > -> Query OK. 1 row(s) modified or retrieved. mSQL > Query OK. 1 row(s) modified or retrieved. mSQL > Query OK. 1 row(s) modified or retrieved. mSQL > Query OK. 1 row(s) modified or retrieved. mSQL > Query OK. 1 row(s) modified or retrieved. mSQL > Bye! $ msql linux Welcome to the miniSQL monitor. Type \h for help. mSQL > \h MiniSQL Help! The following commands are available :- \q Quit \g Go (Send query to database) \e Edit (Edit previous query) \p Print (Print the query buffer) mSQL > select name, id from linuxer -> \g Query OK. 5 row(s) modified or retrieved. +----------+----------+ | name | id | +----------+----------+ | À¯Çü¸ñ | ¿¥ºê¸®¿À | | ¹ÚÀçÈ | kingcrab | | ·ù°æÈ£ | lovest | | À̸¸¿ë | geoman | | ÀÌÁ¤ÈÆ | facultas | +----------+----------+ msql Ŭ¶óÀ̾ðÆ®´Â \g ³ª \q ¸¦ ÀÔ·ÂÇϱâ Àü±îÁö »ç¿ëÀÚ°¡ ÀÔ·ÂÇÑ ³»¿ëµéÀ» ¸ðµÎ ¹ö ÆÛ¿¡ ³Ö¾î³õ°í ±â´Ù¸°´Ù. ¸Å¹ø ¿£ÅÍÅ°¸¦ Ä¥¶§¸¶´Ù msql Àº "->" ¶ó´Â »õÇÁ·ÒÇÁÆ®¸¦ ³»³õ°í ±×´ÙÀ½ÀÇ ÀÔ·ÂÀ» ±â´Ù¸®¸ç, À̶§ \g ¸¦ ÀÔ·ÂÇÏ¸é ¿©Áö²¯ ÀÔ·ÂÇÑ SQL ±¸¹®µéÀÌ ½ÇÇàµÈ´Ù. \q ¸¦ ÀÔ·ÂÇϸé ÀÔ·ÂÀÌ Ãë¼ÒµÇ°í msql À» ºüÁ®³ª¿Â´Ù. 1.2.6 ÁÖ¼® msql Ŭ¶óÀ̾ðÆ®¿¡¼ # Ç¥½Ã´Â ÁÖ¼®À» ³ªÅ¸³½´Ù. # µÚ¿¡ ¿À´Â ¸ðµç ¹®ÀÚµéÀ» msql Àº ¹«½ÃÇعö¸®°Ô µÈ´Ù. ±×·¯¹Ç·Î, Å×À̺í¸íÀ̳ª µ¥ÀÌŸµéÀ» ´Ù·ç´Â °÷¿¡´Â # ¹®ÀÚ´Â ¾² Áö¾Ê¾Æ¾ß ÇÑ´Ù. 1.2.7 µ¥ÀÌŸº£À̽ºÀÇ ±¸¼ºÀ» Á¤ÀÇÇϰųª º¯°æÇϱâ msql Ŭ¶óÀ̾ðÆ®¸¦ ÀÌ¿ëÇؼ ¼¹ö¿¡ µ¥ÀÌŸº£À̽ºÀÇ ±¸¼ºÀ» Á¤ÀÇÇϰųª º¯°æÇÒ ¼ö ÀÖ ´Ù. ¿¹¸¦ µé¾î ÅÖºó µ¥ÀÌŸº£À̽º company ¸¦ °¡Áö°í ´ÙÀ½°ú °°ÀÌ ÀÔ·ÂÇغ¸ÀÚ. ¸ÕÀú company µ¥ÀÌŸº£À̽º¸¦ »ý¼ºÇÏ¿´´Ù°í °¡Á¤ÇÑ´Ù. $ msql company mSQL > CREATE TABLE project ( -> pname char(15), -> pnumber char(5), -> plocation char(10), -> dnum char(1) -> ) \g Query OK. 1 row(s) modified or retrieved. mSQL > CREATE TABLE dept_locations ( -> dnumber char(1) not null, -> dlocation char(10) not null -> ) \g Query OK. 1 row(s) modified or retrieved. ¿¡·¯°¡ ÀÖÀ»¶§¸¶´Ù ¾î¶² ¿¡·¯ÀÎÁö¸¦ ³ªÅ¸³»Áֱ⠶§¹®¿¡ ÀÌ·¸°Ô ÀÔ·ÂÇÏ´Â ¹æ¹ýÀÌ Ã³À½ ¿¡´Â ±¦ÂúÀº ¹æ¹ýÀÌ´Ù. À§¿¡¼¿Í °°ÀÌ company-schema.msql ÆÄÀÏÀ» ¸¸µé¾î ¸®´ÙÀÌ·º ¼ÇÀ» ½á msql ¿¡ Àü´Þ½ÃÄѵµ µÈ´Ù. ¸¸ÀÏ ÀÌ·¸°Ô ÇßÀ» ¶§ ¿¡·¯°¡ ÀÖÀ¸¸é ´Ù½Ã ÆÄÀÏÀ» ¼öÁ¤ÇÏ°í Àç ½ÇÇàÇÏ¸é µÈ´Ù. À§ÀÇ ¿¹¿¡¼ Ȥ ±âÁ¸¿¡ project ¶ó´Â Å×À̺íÀÌ Á¸ÀçÇÏ¸é ¸ÕÀú ÀÌÀüÀÇ project ¶õ Å×À̺íÀ» »èÁ¦ÇÏ°í ´Ù½Ã »ý¼º½ÃÄÑ¾ß ÇÒ °æ¿ì°¡ ÀÖ´Ù. À̸¦ À§ÇØ ´ÙÀ½°ú °°ÀÌ ÀϹÝÀûÀ¸·Î ½áÁÖ´Â °æ¿ì°¡ ¸¹´Ù. DROP TABLE project \g CREATE TABLE project ( pname char(15), pnumber char(5), plocation char(10), dnum char(1) ) \g ÀÌ°ÍÀÌ Ã³À½ ½ÇÇàµÉ¶§ ¾Æ¸¶µµ ´ÙÀ½°ú °°Àº ¿¡·¯¸Þ½ÃÁö°¡ ³ª¿Ã¼öµµ ÀÖ´Ù. ERROR : Unknown table "project" ÀÌ ¿¡·¯´Â ±âÁ¸¿¡ project ¶ó´Â Å×À̺íÀÌ ¾ø±â¶§¹®¿¡ »èÁ¦ÇÒ Å×À̺íÀÌ ¾ø´Ù´Â ¿¡·¯ÀÌ ±â¶§¹®¿¡ ½Å°æ¾²Áö¾Ê¾Æµµ µÈ´Ù. ÇÏÁö¸¸, ÀÏ´Ü ¿¡·¯°¡ ¹ß»ýÇÏ¸é ±×´ÙÀ½ ±¸¹®Àº ¸ðµÎ ½ÇÇàµÇÁö¾Ê±â ¶§¹®¿¡ ¸¸ÀÏ ÀÌ°æ¿ì¿¡ ù¹ø° ¶óÀÎÀÇ ³¡ºÎºÐ¿¡ \g °¡ ¾ø´Ù¸é ±× ÀÌÈÄÀÇ ¸í·ÉµéÀº ¸ðµÎ ¹«½Ã°¡ µÇ¾î¹ö¸°´Ù. ±×·¯¹Ç·Î, DROP ¹®À» ¾µ °æ¿ì¿¡´Â Ç×»ó ¸¶Áö¸·ºÎ ºÐ¿¡ \g ¸¦ ºÙÀ̱⠹ٶõ´Ù. ÀϹÝÀûÀ¸·Î ¸ðµç mSQL ¸í·ÉµÚ¿¡ \g ¸¦ ºÙÀÌ´Â °ÍÀÌ ÁÁÀº ½À°üÀÌ´Ù. 1.2.8 µ¥ÀÌŸº£À̽º ÀúÀåÇϱâ mSQL Àº ÇöÀç µ¥ÀÌŸº£À̽º¸¦ ¸ðµÎ SQL ¹®À¸·Î ¹Ù²ãÁÖ´Â msqldump ¶ó´Â ¸í·ÉÀ» Á¦°ø ÇÑ´Ù. msqldump ·Î ¸¸µé¾îÁø ÆÄÀÏ·Î ´Ù½Ã ÇöÀçÀÇ µ¥ÀÌŸº£À̽º¸¦ Àç»ý¼º½Ãų ¼ö ÀÖ ´Ù. $ msqldump company > company-dump.msql 1.2.9 ½ºÅ©¸³Æ® ¸¸µé±â À§ÀÇ ³»¿ëÀ» Çѹø¿¡ ½ÇÇàÇÒ ¼ö ÀÖ´Â ½ºÅ©¸³Æ®¸¦ ÀÛ¼ºÇÏ¿© »ç¿ëÇÒ ¼öµµ ÀÖ´Ù. ¾Æ·¡¿Í °°ÀÌ ¸¸µéÀÚ. -[makecompany]----------------------------------------------------------------- #!/bin/bash |