¸®´ª½º °ü·Ã °Á¶õ |
---|
Á¦¸ñ | JDBC, mySQL #2 1999/01/03 (16:24) |
À̸§ | ±èÈ¿¿ø |
¹øÈ£ | 86 |
Á¶È¸ | 486 |
º»¹® |
----------------------------------------------------------------------------- JAVA, JDBC¿Í MySQLÀ» ÀÌ¿ëÇÑ À¥°ú DB 2 (Àúµµ ¾ÆÁ÷ °øºÎ¸¦ ÇÏ´Â ÁßÀ̶ó, Ʋ¸° ºÎºÐÀÌ ¸¹½À´Ï´Ù. Ȥ½Ã ¹ß°ßµÇ¸é, Àú¿¡°Ô ¿¬¶ôÀ» ÁֽʽÿÀ. °¨»çÇÕ´Ï´Ù.) ¾È³çÇϽʴϱî. InoS ÇãÁ¤¼ö½Ê´Ï´Ù. ¿À´ÃÀº MysqlÀÇ »ç¿ë¹ý°ú SQL ¹®¹ýÀ» ¹è¿ï ½Ã°£À̱º¿©..... SQL°ú MysqlÀ» ±î½Å ºÐµéÀ̶ó¸é ¿À´ÃÀº ³Ñ¾î°¡¼Åµµ µË´Ï´Ù. Ãʺ¸ÀÚµéÀº À§ÇØ SQL ¹®¹ýµµ ¹è¿öº¾½Ã´Ù. 1) MySQLÀÇ »ç¿ë¹ý°ú SQL ¹®¹ý °øºÎ <= ¿À´Ã... 2) JDBC 3) - i. JDBC DriverÀÇ ¼³Ä¡¿Í ¼³Á¤ - ii. JDBC API SQLÀº Structured Query LanguageÀÇ ¾àÀÚ·Î ¿ì¸® ³ª¶ó ¸»·Î ÇÏÀÚ¸é ±¸Á¶ÈµÈ ÁúÀǾî Á¤µµÀÔ´Ï´Ù. DataBase¿¡ ÀÌ·± ÁúÀÇ(queyr)¸¦ Çϸé, ¿ì¸®´Â ±× °á°ú¸¦ º¸°Ô µÇ´Â °ÍÀÔ´Ï´Ù. SQL¿¡ ´ëÇÑ ¼³¸íÀº ÀÚ¼¼È÷ ¾ÈÇÏ°Ú½À´Ï´Ù. ÇÏÁö¸¸, ¹®¹ýÀº ¹è¿ï °ÍÀÔ´Ï´Ù. ¾Æ¹«Æ° SQLÀº ±¹Á¦ÀûÀΠǥÁØÀÌ µÇ¾ú°í, ¸¹Àº DataBaseµéÀÌ ÀÖ½À´Ï´Ù. À¯¸íÇÑ mSQL, PostgreSQL, ORACLEµî ¸¹Àº DataBaseµéÀÌ Àִµ¥, Àü ±×Áß¿¡¼ MySQL À̶ó´Â °ÍÀ» ¼±ÅÃÇß½À´Ï´Ù. http://www.tcx.se¿¡¼ ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¹°·Ð ¹«·á°í, ±× Ư¡Àº »ó´çÈ÷ ºü¸¥ ¼Óµµ¸¦ ³½´Ù´Â °ÍÀÔ´Ï´Ù. ¸®´ª½º µ¿È£È¸¿¡µµ ÀÖ´õ±º¿©...... rpm ÆÐÅ°Áö·Î ¿Ã·ÁÀú ÀÖÀ¸´Ï ±ò ±â´Â ½¬¿ï °Ì´Ï´Ù. ÀÌÁ¦ ¼³Ä¡¸¦ ÇÏ°í, ¸î °¡Áö ¼³Á¤µµ ÇսôÙ. 1. ¼³Ä¡¿Í ¼³Á¤.(root·Î ¼³Ä¡ÇսôÙ.) ¿ì¼± ÀÚ·á½Ç¿¡¼ rpmÀ¸·Î ¹ÞÀ¸¼ÌÀ¸¸é, rpm ¸í·ÉÀ» ÀÌ¿ëÇؼ ¼³Ä¡ÇÕ´Ï´Ù. (½±Á®? ^^;) http://www.tcx.se¿¡ °¡¼Ì´Ù¸é, ¼Ò½º ¹×, ¹ÙÀ̳ʸ®, rpm, µ¥ºñ¾È ÆÐÅ°Áö µî ¾ø´Â°Ô ¾ø½À´Ï´Ù. ¸¾¿¡ µå´Â °ÍÀ» °ñ¶ó ¼³Ä¡¸¦ ÇսôÙ. rpmÀÌ ¾Æ´Ï°í ¹ÙÀ̳ʸ®¶ó¸é, µð·ºÅ͸® ¼³Á¤À» ÀßÇØ Áֽñæ.. ¹¹ ¾ÈÇØÁ൵ »ó±ÇÀº ¾ø½À´Ï´Ù¸¸, °ü¸®¸¦ ÀßÇØÁà¾ß ÀÌ¿ëÇϱâ ÆíÇÏ°ÚÁ®.... ÀÚ~ ¼³Ä¡°¡ Àß ¤µÆ½À´Ï±ìû(ÀÌ°Å °Á ¸Â¾î? ¼³¸íµµ ¾ÈÇØÁÖ°í --;) rpmÀ¸·Î ¼³Ä¡Çϼ̴ٸé, ¾ÕÀ¸·Î ºÎÆýø¶´Ù MySQL ´ë¸óÀÌ ÀÚµ¿À¸·Î ½ÇÇàµÉ °ÍÀÔ´Ï´Ù. ¹ÙÀ̳ʸ®·Î ¼³Ä¡ÇϽŠºÐÀº mysql.server start·Î MySQL ´ë¸óÀ» ½ÇÇàÇÏ°í mysql.server stopÀ¸·Î MySQL ´ë¸óÀ» Á¾·áÇÒ ¼ö ÀÖ½À´Ï´Ù. ¾Æ´Ï¸é, /etc/rc.d/rc3.d µî¿¡ ÆíÁýÇؼ ºÎÆýø¶´Ù ´ë¸óÀÌ ¶ã ¼ö ÀÖµµ·Ï ÇÒ¼ö Àִµ¥, ÀÌ°Ç Á¦°¡ Àß ¸ð¸£´Â ±º¿© ^^; MySQLÀ» ¾²·Á¸é µ¥¸óÀÌ ¶ç¾îÁ® À־ ÇÕ´Ï´Ù.telnetÀ̳ª, ftpó·³ ¸»ÀÌÁ®. ps -x Çؼ , (´çºÐ°£Àº root·Î ÀÛ¾÷ÇսôÙ.) 238 ? S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --ski ¿Í °°Àº ³»¿ëÀÌ ÀÖ³ª º¾½Ã´Ù. ÀÖÀ¸¸é, ´ë¸óÀÌ Àß ½ÇÇàµÇ°í ÀÖ´Â °Ì´Ï´Ù. ¾Æ¸¶, rpm À¸·Î ¼³Ä¡ÇϽŠºÐµéÀº ÀÚµ¿À¸·Î ¶ç¾îÁ® ÀÖÀ» °Å±¸, ¹ÙÀ̳ʸ®·Î ¼³Ä¡ÇϽŠºÐÀº mysql.server start ·Î, ¸Å ºÎÆýø¶´Ù ½ÇÇàÇϽñæ. ¾Æ´Ô /etc/rc.d µîÀ» ÆíÁýÇϽøé, ÀÚµ¿À¸·Î ¶ä. ÇÏÁö¸¸ Àü ¸ð¸§. ¾ÕÀ¸·Î ÀÚÁÖ ¾µ ½ÇÇà ÆÄÀÏÀº mysql, mysqladmin°ú mysqlshow µîÀÔ´Ï´Ù. mysql - MySQL¿¡ Äõ¸® µîÀ» ³Ñ±â°í, °á°ú¸¦ ¹Þ´Â ½ÇÇà ÆÄÀÏÀÔ´Ï´Ù. mysqladmin - À̸§´ä°Ô MySQLÀ» °ü¸®ÇÏ´Â °ÍÀÔ´Ï´Ù. mysqlshow - ¾î¶² µ¥ÀÌŸ º£À̽º°¡ ÀÖ´ÂÁö... ±×¸®°í, ±× µ¥ÀÌŸ º£À̽º¿¡ ¾î¶² Å×À̺íÀÌ ÀÖ´ÂÁö¸¦ º¸¿©ÁÝ´Ï´Ù. MySQL FAQ¿¡´Â ´ÙÀ½°ú °°Àº ±ÛÀÌ ÀÖ±º¿©. 1. mysql A SQL shell (with gnu readline). Supports interactive use or as a non inte ractive query tool. When used interactively gives result in a ascii-table format, when using as a filter gives tab-separated output. 2. mysqladmin Administration utility. Create/Drop of databases. reload (read new users and flush tables to disk). Version and process info. 3. mysqld The SQL deamon. This should always be running. 4. mysqldump Dump a MySQL database. Freeware by Igor Romanenko. 5. mysqlshow Show information about database, tables and fields. 6. safe_mysqld Start the mysqld demon with some safety features. Restarts on error and h as logging of runtime info to a logfile. 7. mysqlaccess Script to check the priviliges for a host, user and database combination. 8. mysqlbug This script should always be used when filing a bug report to the mysql l ist. 9. mysql_install_db Creates the mysql grant tables with default privileges. This is usually o nly executed when installing the first MySQL release on a new system. 10. isamchk Check, optimize and repair MySQL tables. 11. msql2mysql A shell script to convert a mSQL program to MySQL. Doesn't handle all cas es but gives a good start when converting. 12. replace Binary used for msql2mysql. Utility program to change strings inplace in files or on stdin. Uses a finite state machine to match longer strings first. Can be used to swap strings, for example 'replace a b b a -- files' swap s 'a' and 'b' in the given files. 13. make_binary_release Makes a binary release of a compiled MySQL. This could be sent by ftp to www.tcx.se/pub/mysql/Incoming for the convenience of other MySQL users. ±ÛÀÌ Á» ±æ¾î¼ º¸±â ÈäÇϱº¿©... ¾ÏÆ° ´Ù¸¥°Ç °ÅÀÇ ¾È¾²°í, mysql, mysqladmin, mysqlshow Á¤µµ¸¸ »ç¿ëÇϽǼö ÀÖÀ¸¸é µË´Ï´Ù ¿ì¼± mysqlshow¶ó°í ¸¸ ÇÁ·ÒÇÁÆ®¿¡¼ Ãĺ¾½Ã´Ù. [InoS#root/]mysqlshow +-----------+ | Databases | +-----------+ | inos | | mysql | | test | +-----------+ ÀúÀÇ °æ¿ì À§¿Í °°ÀÌ ³ª¿À³×¿©... ¿©·¯ºÐµéÀº ´Ù¸£°Ô ³ª¿À°ÚÁö¸¸, mysql À̶ó´Â Database´Â ²À ÀÖÀ» °Ì´Ï´Ù. ÀÌ µ¥ÀÌÅÍ º£À̽º¿¡, mysql¿¡ »ç¿ëÀÚ¿¡ ´ëÇÑ ¼³Á¤ÀÌ µé¾î Àְŵ翩. ±×·³ mysqlÀ̶ó´Â µ¥ÀÌŸ º£À̽º¿¡ ¾î¶² Å×À̺íÀÌ ÀÖ´ÂÁö ¾Ë¾Æ º¾½Ã´Ù. [InoS#root/]mysqlshow mysql +--------+ | Tables | +--------+ | db | | host | | jdbc | | user | +--------+ ÀúÀÇ °æ¿ì À§ ó·³ ³ª¿Ô´Âµ¥, ¿©·¯ºÐÀº ¾Æ¸¶ jdbc Å×À̺íÀº ¾øÀ» ²®´Ï´Ù. [InoS#root/]mysql mysql À§Ã³·³ Çغ¾½Ã´Ù. ±×·³ mysqlÀ̶ó´Â µ¥ÀÌŸ º£À̽º¿¡ Á¢¼ÓÇÏ°Ô µË´Ï´Ù. Welcome to the mysql monitor. Commands ends with ; or \g. Type 'help' for help. mysql> À§Ã³·³ ³ª¿Ã ²®´Ï´Ù. Áö±ÝÀº ±×³É ¹«ÀÛÁ¤, mysql> select * from user ; ¶ó°í 󺾽ôÙ. ±¸¹®ÀÇ ³¡Àº ';' ÀÔ´Ï´Ù. À§ÀÇ ¹®¹ýÀº user¶ó´Â Å×ÀÌºí¿¡¼(from) ¸ðµç (*) Ä÷³À» selectÇ϶ó´Â °ÍÀÔ´Ï´Ù. °á°ú´Â Á÷Á¢È®ÀÎ ÇϽʽÿÀ. mysql> quit ¸¦ ħÀ¸·Î¼ Á¾·áÇÒ ¼ö ÀÖ¾¹´Ï´Ù. ÀÌÁ¦ º»°ÝÀûÀ¸·Î SQL ¹®¹ýÀ» ¹è¿ö º¾½Ã´Ù. ¿ì¼± ¿¬½À¿ëÀ¸·Î ¾µ µ¥ÀÌŸ º£À̽º¸¦ ¸¸µé¾î º¾½Ã´Ù. mysqladmin create [µ¥ÀÌŸ º£À̽º À̸§]... mysqladmin create NNR À̶ó°í ÇÑÈÄ mysqlshow ¸¦ Ä¡¸é NNRÀ̶ó´Â µ¥ÀÌŸ º£À̽º°¡ Ãß°¡ µÈ°ÍÀ» º¼ ¼öÀÖ½À´Ï´Ù. ±×·³ [InoS#root/]mysql ¼ºÀû °ú °°ÀÌ Ãļ ¼ºÀûÀ̶ó´Â µ¥ÀÌÅÍ º£À̽º¸¦ ¸¸Á® º¾½Ã´Ù. 2. SQL ¹®¹ý.. (SQL ¹®¹ýÀº ¾ÆÁÖ °£´ÜÇÑ ±âÃʸ¸ ¹è¿ï °ÍÀÔ´Ï´Ù. Ã¥À»·Î ³»µµ ÇѱÇÀº Á·È÷ ³ÑÀ» ºÐ·®À̰ŵ翩.... Á˼ÛÇÏÁö¸¸, °¢ÀÚ Ã¥À» Âü°í ÇϽñæ) ´ÙÀ½°ú °°Àº °ÍÀ» ¹è¿ì½Ç °Ì´Ï´Ù. 1)Å×ÀÌºí ¸¸µé±â. 2)insert, 3)select 4)update ¿ì¼± À§ÀÇ 4°¡Áö Á¤µµ¸¸ °øºÎÇÏ°Ú½À´Ï´Ù. µé¾î °¡±â Àü¿¡ µ¥ÀÌŸ º£À̽º¿Í Å×ÀÌºí¿¡ ´ëÇÑ ¾ê±â ¸ÕÀú ÇÏÁö¿ä... À½. ¼³¸íÇϱ⠾î·Á¿îµ¥... ¸¸¾à ´ë¸®Á¡À̶ó´Â µ¥ÀÌŸ º£À̽º°¡ ÀÖ´Ù°í ÇÑ´Ù¸é, ÀÌ µ¥ÀÌŸ º£À̽º ¾È¿¡´Â A ´ë¸®Á¡ À̶ó´Â Å×À̺í, B ´ë¸®Á¡ Å×À̺í, C ´ë¸®Á¡ Å×ÀÌºí µîÀÌ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ¼ºÀûÀ̶ó´Â µ¥ÀÌŸ º£À̽º°¡ ÀÖ´Ù¸é, 1 Çг⠼ºÀû Å×À̺í, 2Çг⠼ºÀû Å×À̺í... µîÀÌ ÀÖÀ» ¼ö ÀÖ°ÚÁö¿©... ¿ì¸®´Â ¾Õ¿¡¼ ¼ºÀûÀ̶ó´Â µ¥ÀÌŸ º£À̽º¸¦ ¸¸µé¾ú½À´Ï´Ù. ÀÌÁ¦ ¼ºÀû µ¥ÀÌŸ º£À̽º¿¡ Á¢¼ÓÀ» Çؼ, Å×ÀÌºíµµ ¸¸µé°í, ÀÚ·áµµ ÀÔ·Â ÇսôÙ. 2-1 CREATE [InoS#root/] mysql ¼ºÀû À̶ó°í Ä¡¸é, ¼ºÀû µ¥ÀÌŸ º£À̽º¿¡ Á¢¼ÓµË´Ï´Ù. ÀÌÁ¦ Å×À̺íÀ» ¸¸µé¾î º¾½Ã´Ù. create tableÀ» ½á¼ ¸¸µì´Ï´Ù. ´ë¼Ò¹®ÀÚ´Â ¾È°¡¸³´Ï´Ù. CREATE TABLE syntax. CREATE TABLE table_name ( create_definition,... ) create_definition: column_name type NOT NULL [DEFAULT default_value] [ PRIMARY KEY ] or column_name type [NULL] [ PRIMARY KEY ] or PRIMARY KEY ( key_column_name,... ) or KEY [key_name] KEY( key_column_name,...) or INDEX [key_name] ( key_column_name,...) or UNIQUE [key_name] ( key_column_name,...) ¹®¹ýÀº À§¿Í °°½À´Ï´Ù. SungjuckÀ̶ó´Â Å×À̺íÀ» Á÷Á¢¸¸µé¾î º¸Á®. ¿ì¼± mysql>À̶ó´Â ÇÁ·ÒÇÁÆ®°¡ º¸ÀÌÁ®? ±×·³ mysql> create table Sungjuck(name char(20), number int , (¿£ÅÍ) -> math float, computer float) ; ¸ðµç ±¸¹®ÀÇ ³¡Àº ;·Î ³¡³³´Ï´Ù. ;°Ô ³ª¿À±â Àü±îÁö´Â ¸ðµÎ ÇÑ ¹®ÀåÀÔ´Ï´Ù. create ¹®ÀåÀÌ ±æ¾úÀ¸¹Ç·Î, ¿©·¯ÁÙ¿¡ Ä£°Í »ÓÀÔ´Ï´Ù. mysql> create (¿£ÅÍ) -> table Sungjuck (¿£ÅÍ) -> (name char(20), number int ,math float, -> computer float) ; °ú °°ÀÌ Çصµ ¶È °°½À´Ï´Ù. ¾Æ¹«Æ° ÀÌ·¸°Ô Çؼ SungjuckÀ̶ó´Â Å×À̺íÀÌ »ý°å½À´Ï´Ù. create table Å×À̺í À̸§ ( Ä÷³ÀÇ À̸§°ú typeµî) ; ¾ÆÁÖ °£´ÜÇÑ ¹®¹ýÀÔ´Ï´Ù. ±×·³ ----------------------------------- | name | number | math | computer | ----------------------------------- À§¿Í °°Àº Ä÷³À» °¡Áø SungjuckÀ̶ó´Â Å×À̺íÀÌ »ý±â°Ô µÇ¾ú½À´Ï´Ù. (±â»Ú´Ù.) ¾ÆÁ÷ Å×ÀÌºí¿¡´Â ·¹ÄÚµåµéÀÌ ¾øÀ¸¹Ç·Î, ÀÌÁ¨ Å×ÀÌºí¿¡ ·¹Äڵ带 ÀÔ·ÂÇØ º¾½Ã´Ù. insert¸¦ ÀÌ¿ëÇؼ ÇÕ´Ï´Ù. 2-2 INSERT insert into Å×À̺í À̸§ values( Ä÷³1, Ä÷³2, ....) ; ÀÌ·± ¹®¹ýÀÔ´Ï´Ù. Á÷Á¢ Sungjuck Å×ÀÌºí¿¡ ÀÔ·ÂÀ» Çغ¾½Ã´Ù. mysql> insert into Sungjuck values('ÇãÁ¤¼ö', 9744245, 90, 90) ; (½ºÆ®¸µÀº ''·Î ÀÔ·ÂÇÕ´Ï´Ù, int³ª floatµîÀº ±×³É ¾²½Ã¸é µË´Ï´Ù.) 'mysql>'´Â ÀÔ·ÂÇÏ´Â°Ô ¾Æ´Õ´Ï´Ù. ÇÁ·ÒÇÁÆ® ÀÔ´Ï´Ù. ±×·³ Á¦´ë·Î ÀÔ·Â µÆ´ÂÁö È®ÀÎÇÏ°í ½ÍÀ¸½Ã°ÚÁ®? select ¸¦ ÀÌ¿ëÇؼ °á°ú¸¦ È®ÀÎÇØ º¼¼ö ÀÖ¾¹´Ï´Ù. mysql> select * from Sungjuck; 1 rows in set (0.00 sec) +--------+---------+-------+----------+ | name | number | math | computer | +--------+---------+-------+----------+ | ÇãÁ¤¼ö | 9744245 | 90.00 | 90.00 | +--------+---------+-------+----------+ ÈåÈå, ½Å±âÇÏÁ®? select ´Â Á» ÀÖ´Ù°¡ ¹è¿ì±â·Î ÇÏ°í, insert¸¦ ÀÌ¿ëÇؼ ¸¹Àº Ä£±¸µéÀÇ À̸§°ú, Çйø, ¼ºÀûµîÀ» ÀÔ·Â Çغ¾½Ã´Ù. ÀÌ»Û ÇлýÇÑÅ×´Â Á¡¼ö ¸¹ÀÌ ÁÖ°í, Æò¼Ò °¨Á¤ ÀÖ´ø Çлý µéÇÑÅ×´Â 0Á¡À» ÁÖ¸é¼, insert ¹®À» °øºÎÇÏÁ®...... ¾ó¸¶³ª ÀÔ·ÂÇϼ̽À´Ï±î... ÀÌÁ¨ ±×¸¸ ÀÔ·ÂÇÏ°í, Áö±Ý±îÁö, ÀÔ·ÂÇÑ °ÍÀ» º¸Á®.... mysql> select * from Sungjuck ; 3 rows in set (0.00 sec) +--------+---------+-------+----------+ | name | number | math | computer | +--------+---------+-------+----------+ | ÇãÁ¤¼ö | 9744245 | 90.00 | 90.00 | | Ȳ¼öȯ | 9744253 | 85.00 | 95.00 | | °ºÀÃá | 9744004 | 50.00 | 100.00 | +--------+---------+-------+----------+ Àú´Â 3¸íÀ» ÀÔ·ÂÇß¾¹´Ï´Ù. ÀÌÁ¦ ÀÔ·ÂÇÑ °ÍÀ» °¡Áö°í, select ¸¦ ¹è¿ö º¾½Ã´Ù. select´Â ´ëÃæ Çؼ®À» ÇغÁµµ ¾Æ½Ã°ÚÁö¸¸, ¼±ÅÃÇÏ´Ù... ÀÌ·± °ÅÁ®? DB¿¡ Áú¹®À» ÇÏ°í, ±× °á°ú°ªÀ» ¾ò¾î ¿À´Â °ÍÀÔ´Ï´Ù. (´Ù½Ã Çѹø ¸»ÇÏÁö¸¸, ÀúµÎ ¾ÆÁ÷ ¹è¿ì´Â ´Ü°è°í, È¥ÀÚ °øºÎÇÏ´À¶ó Ʋ¸° ºÎºÐÀÌ ¸¹À» °Ì´Ï´Ù. ¹ß°ßÇϽøé, Àú¿¡°Ô ¿¬¶ô Áֽñæ..... ¿¬¶ôÁֽøé ÈÄ»çÇÕ´Ï´Ù.(»Ç»Ç)). 2-3 SELECT mysql> select * from Sungjuck ; ÀÌ °ÍÀº SungjuckÀ̶ó´Â Å×ÀÌºí¿¡¼, ¸ðµç(*, ¿ÍÀϵå Ä«µåÁ®)¸¦ °¡Á®¿Í¶ó..... ÀÔ´Ï´Ù. ±×·¯´Ï °á°ú°¡ À§Ã³·³ ³ª¿Ô°ÚÁ®..... ±×·³ nameÀ̶ó´Â Ä÷³¸¸ º¸°í ½Í´Ù¸é, mysql> select name from Sungjuck; °á°ú´Â.... 3 rows in set (0.00 sec) +--------+ | name | +--------+ | ÇãÁ¤¼ö | | Ȳ¼öȯ | | °ºÀÃá | +--------+ name°ú math¸¦ º¸°í ½Í´Ù¸é, mysql> select name , math from Sungjuck ; °á°ú´Â 3 rows in set (0.00 sec) +--------+-------+ | name | math | +--------+-------+ | ÇãÁ¤¼ö | 90.00 | | Ȳ¼öȯ | 85.00 | | °ºÀÃá | 50.00 | +--------+-------+ À¸ÇÏ~ ½Å±âÇÏ´Ù....~~~ ^^; select ¿¡¼´Â ¸¹Àº ÇÔ¼öµéÀ» Á¦°øÇÕ´Ï´Ù. ¿ì¼± ¼¼¸íÀÇ mathÀÇ ÃÑÁ¡Àº ¾ó¸¶ÀÎÁö ¾Ë¾Æº¼±î¿©? mysql> select sum(math) from Sungjuck; °á°ú´Â 1 rows in set (0.13 sec) +-----------+ | sum(math) | +-----------+ | 225.00 | +-----------+ sum(Ä÷³À̸§) Çϸé, ±× Ä÷³ÀÇ ÇÕÀ» º¸¿© ÁÝ´Ï´Ù. mathÀÇ Æò±ÕÀ» ³»°í ½Í´Ù¸é, mysql> select avg(math) from Sungjuck ; °á°ú´Â 1 rows in set (0.00 sec) +-----------+ | avg(math) | +-----------+ | 75.000000 | +-----------+ select¿¡¼ ¾²ÀÌ´Â ÇÔ¼ö´Â Á¤¸» ¸¹½À´Ï´Ù. ¾Æ½±Áö¸¸, ÀÌ ÇÔ¼öµéÀº Ã¥À» ÂüÁ¶ÇϽôøÁö.... ¾Æ´Ï¸é /usr/doc/mysql¹öÀü/ ¿¡ ÀÖ´Â myslq-faq¸¦ º¸½Ã±â ¹Ù¶ø´Ï´Ù. ÀÌ ¹®¼´Â mysqlÀ» »ç¿ëÇϴµ¥ °ÅÀÇ ¸ðµç µµ¿ò¸»À» Á¦°øÇÕ´Ï´Ù. ÀÌÁ¦, Á¶°ÇÀ» ÁÖ¾î select ÇÏ´Â °ÍÀ» ¹è¿ö º¾½Ã´Ù. ¸¸¾à ÇлýÀÌ ¸î õ¸íÀÌ ³Ñ´Âµ¥ select * from SungjuckÀ¸·Î´Â ¿øÇÏ´Â ÇлýÀÇ ¼ºÀûÀ» º¸±â Èûµé °ÍÀÔ´Ï´Ù. µû¶ó¼ ÇãÁ¤¼ö ÇлýÀÇ ¼ºÀûÀ» º¸°í ½Í´Ù¸é, Á¶°ÇÀ» ÁÖ¾î mysql> select * from Sungjuck where name = 'ÇãÁ¤¼ö' ; °á°ú´Â 1 rows in set (0.02 sec) +--------+---------+-------+----------+ | name | number | math | computer | +--------+---------+-------+----------+ | ÇãÁ¤¼ö | 9744245 | 90.00 | 90.00 | +--------+---------+-------+----------+ ½±Á®? Çؼ®À» ÇÏ¸é ¹¹... Sungjuck Å×ÀÌºí¿¡¼ nameÀÌ 'ÇãÁ¤¼ö' ÀÎ ·¹ÄÚµåÀÇ ¸ðµç Ä÷³À» º¸¿öÁà¶ó..! Á¤µµÀÔ´Ï´Ù. AND³ª OR , ºÎµîÈ£µµ µË´Ï´Ù. mysql> select * from Sungjuck where math > 70 ; math°¡ 70º¸Å¸ Å« ÇлýÀÇ ·¹Äڵ带 ¼±ÅÃÇ϶ó´Â ±º¿©. °á°ú´Â 2 rows in set (0.05 sec) +--------+---------+-------+----------+ | name | number | math | computer | +--------+---------+-------+----------+ | ÇãÁ¤¼ö | 9744245 | 90.00 | 90.00 | | Ȳ¼öȯ | 9744253 | 85.00 | 95.00 | +--------+---------+-------+----------+ mysql> select * from Sungjuck where math > 80 && computer > 90 ; ANDÀÔ´Ï´Ù. math > 80 ±×¸®°í, computer > 90 ÀÎ Çлý... °á°ú´Â 1 rows in set (0.05 sec) +--------+---------+-------+----------+ | name | number | math | computer | +--------+---------+-------+----------+ | Ȳ¼öȯ | 9744253 | 85.00 | 95.00 | +--------+---------+-------+----------+ SORTµµ °¡´ÉÇÕ´Ï´Ù. ´ÙÀ½°ú °°ÀÌ ¼ÒÆ®¸¦ ÇÕ´Ï´Ù. mysql> select * from Sungjuck order by number asc ; 'order by Ä÷³ À̸§ [acs or desc]' ÀÌ·± ½ÄÀÔ´Ï´Ù. acs´Â ¿À¸§ Â÷¼ø, desc´Â ³»¸² Â÷¼øÀÌÁ®... Ä÷³ À̸§À» °¡Áö°í asc¶Ç´Â desc·Î ¼ÒÆ®ÇÕ´Ï´Ù. °á°ú 3 rows in set (0.01 sec) +--------+---------+-------+----------+ | name | number | math | computer | +--------+---------+-------+----------+ | °ºÀÃá | 9744004 | 50.00 | 100.00 | | ÇãÁ¤¼ö | 9744245 | 90.00 | 90.00 | | Ȳ¼öȯ | 9744253 | 85.00 | 95.00 | +--------+---------+-------+----------+ Çйø ¼øÀ¸·Î ¼ÒÆ®¸¦ Çß±º¿©. À̹ø¿£ ¼ºÀû¼øÀ¸·Î ¼ÒÆ®ÇսôÙ. mysql> select * from Sungjuck order by math desc ; 3 rows in set (0.01 sec) +--------+---------+-------+----------+ | name | number | math | computer | +--------+---------+-------+----------+ | ÇãÁ¤¼ö | 9744245 | 90.00 | 90.00 | | Ȳ¼öȯ | 9744253 | 85.00 | 95.00 | | °ºÀÃá | 9744004 | 50.00 | 100.00 | +--------+---------+-------+----------+ mathÀÇ ³ôÀº ¼øÀ¸·Î ¼ÒÆ®Çß½À´Ï´Ù. ÀÌ»ó ´ëÃæÀ̶ó¸¶, select ±¸¹®¿¡ ´ëÇØ ¾Ë¾Æ º¸¾Ò¾¹´Ï´Ù. ÀÌÁ¨ update¿¡ ´ëÇØ ¾Ë¾Æ º¾½Ã´Ù. 2-4 UPDATE Ä÷³ÀÇ °ªÀ» ¹Ù²Ù·Á°í °¡Á¤ÇսôÙ. Áï, ÇãÁ¤¼öÀÇ ¼öÇÐ Á¡¼ö°¡, 100Á¡À̾ú´Âµ¥, À§¿¡¼´Â 90Á¡À¸·Î µÇ¾î ÀÖ½À´Ï´Ù. ÇãÁ¤¼öÀÇ ¼ºÀûÀ» 100À¸·Î ¹Ù²ã º¾½Ã´Ù. mysql> update Sungjuck set math = 100 where name = 'ÇãÁ¤¼ö' ; Query OK, 1 rows affected (0.00 sec) ±×³É Àб⸸ Çصµ ÀÌÇØ°¡ µÇÁ®? update Å×À̺í À̸§ set Ä÷³ = °ª where Á¶°Ç... ¸¸¾à Á¶°ÇÀ» ¾È¾´´Ù¸é, ¸ðµç ·¹ÄÚµåÀÇ °ªÀÌ ¹Ù²î°Ô µË´Ï´Ù. ÀÌ»ó. MySQL »ç¿ë¹ý°ú °£´ÜÇÑ SQL ¹®¹ý¿¡ ´ëÇØ ¾Ë¾Æ ºÃ¾¹´Ï´Ù. ¾ÆÁÖ ±âÃÊÀûÀÎ ³»¿ë¸¸ ¾Ë¾ÆºÃÀ¸¹Ç·Î, µÉ ¼öÀÖÀ¸¸é, Ã¥À» ã¾Æº¸½Ã±â ¹Ù¶ø´Ï´Ù. |