¸®´ª½º °ü·Ã °­Á¶õ

HomePage Backward Forward Post Reply List
Delete Modify
  Á¦¸ñ   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 ¹®¹ý¿¡ ´ëÇØ ¾Ë¾Æ ºÃ¾¹´Ï´Ù.
¾ÆÁÖ ±âÃÊÀûÀÎ ³»¿ë¸¸ ¾Ë¾ÆºÃÀ¸¹Ç·Î, µÉ ¼öÀÖÀ¸¸é,
Ã¥À» ã¾Æº¸½Ã±â ¹Ù¶ø´Ï´Ù.

HomePage Backward Forward Post Reply List
1998 by swindler