{"id":61,"date":"2010-04-17T21:39:21","date_gmt":"2010-04-18T06:39:21","guid":{"rendered":"\/blog\/?p=61"},"modified":"2023-09-21T09:41:21","modified_gmt":"2023-09-21T00:41:21","slug":"mysql-%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%98%eb%b0%8d","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=61","title":{"rendered":"MySQL \ud504\ub85c\uadf8\ub798\ubc0d"},"content":{"rendered":"\nmysql \uc774 \uc6f9\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 RDBMS \ub77c\ub294 \ub370\ub294 \uc758\uc2ec\uc758 \uc5ec\uc9c0\uac00 \uc5c6\ub294 \uac83 \uac19\ub2e4. \uc8fc\ub85c Apache \uc640 PHP \uc640 \uc5f0\ub3d9\ud574\uc11c \uc0ac\uc6a9\ub418\uc5b4 \uc9c0\ub294\ub370 (\uc774 3\uac00\uc9c0 \uc870\ud569\uc744 APM \uc774\ub77c\uace0 \ud55c\ub2e4), \uac04\ub2e8\ud55c \uce74\uc6b4\ud130, \ubc29\uba85\ub85d\uc5d0\uc11c \ubd80\ud130, \uc880\ub354 \ubcf5\uc7a1\ud55c \uc1fc\ud551\ubab0, \uc2a4\ucf00\uc974\uad00\ub9ac, \uac8c\uc2dc\ud310, \uc6f9\uba54\uc77c \ub4f1 \uac70\uc758 \uc4f0\uc774\uc9c0 \uc54a\ub294 \uacf3\uc774 \uc5c6\uc744 \uc815\ub3c4\uc774\ub2e4.
Mysql \uc774 PHP \uc640 \ud568\uaed8 \uc6f9\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294\uac8c \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc6a9\ub3c4\uc774\uae34 \ud558\uc9c0\ub9cc, \ub9ce\uc740 \uacbd\uc6b0 \uc2dc\uc2a4\ud15c\ub808\ubca8\uc5d0\uc11c \uc9c1\uc811 \ub2e4\ub8e8\uc5b4\uc57c \ud558\ub294\uacbd\uc6b0\ub3c4 \uc0dd\uae34\ub2e4. \uc774\ub7ec\ud55c \uacbd\uc6b0\ub97c \uc704\ud574\uc11c mysql \uc740 Perl, Python, C, C++ \ub4f1 \ub2e4\uc591\ud55c API\ub97c \uc81c\uacf5\ud558\ub294\ub370, \uc6b0\uc120 C\ub97c \uc774\uc6a9\ud55c \uc811\uadfc\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\ub2e4. (\ub098\uc911\uc5d0 \uc2dc\uac04\uc774 \ud5c8\ub77d\ud558\uba74 C++ \uc744 \uc774\uc6a9\ud55c mysql \uc811\uadfc\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4) \uc124\uba85\uc5d0 \ub4e4\uc5b4\uac10\uc5d0 \uc55e\uc11c \uc774\ubb38\ub294 \uc5ec\ub7ec\ubd84\uc774 SQL\uacfc RDBMS\uc5d0 \ub300\ud55c \uac1c\ub150\uacfc, mysql \uc758 \uc124\uce58 \ubc0f \uc6b4\uc601\uc5d0 \uad00\ub828\ub41c \uae30\ubcf8 \uc0ac\ud56d\uc740 \uc54c\uace0 \uc788\ub2e4\ub294 \uac00\uc815\ud558\uc5d0 \uc4f0\uc5ec\uc84c\uc73c\uba70, \uc124\uba85\uc744 \uc704\ud574 \uc4f0\uc778 \ucf54\ub4dc\ub4e4\uc740 \uae30\ub2a5\uacfc \ud6a8\uc728\uc131\uc5d0 \uc5fc\ub450\ub97c \ub454 \ucf54\ub4dc\uac00 \uc544\ub2cc \uc21c\uc218 \uc2a4\ud130\ub514\uc6a9 (\ub3cc\uc544\ub9cc\uac00\ub294)\ucf54\ub4dc \uc784\uc744 \uacf5\uc9c0\ud569\ub2c8\ub2e4. mysql\uacfc SQL \uc5d0 \ub300\ud55c \uc0c1\uc138\ud55c \ub0b4\uc6a9\uc740 \uad00\ub828 \uc11c\uc801\uc774\ub098 database.sarang.net<\/A>\uc744 \ucc38\uace0\ud558\uc138\uc694.

\ucf54\ub4dc\ub97c \ud14c\uc2a4\ud2b8 \ud558\uae30 \uc804\uc5d0 \uc6b0\uc120 \uc5ec\ub7ec\ubd84\uc758 \uc2dc\uc2a4\ud15c\uc5d0 mysql client \uac00 \uc124\uce58\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\uc744 \ud574\ubcf4\ubc14\ub780\ub2e4. \ud544\uc790\uc758 \uacbd\uc6b0 mysql-3.23.46 \uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc73c\uba70, \uc778\ud074\ub8e8\ub4dc \ud30c\uc77c\uc740 \/usr\/local\/include\/mysql \uc5d0 \ub77c\uc774\ube0c\ub7ec\ub9ac \ud30c\uc77c\uc740 \/usr\/local\/lib\/mysql \uc124\uce58\ub418\uc5b4 \uc788\ub2e4. \uc694\uc998 \uc660\ub9cc\ud55c Linux \ubc30\ud3ec\ud310\uc740 \uae30\ubcf8\uc73c\ub85c mysql \uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc73c\ub2c8, \uc704\uc758 \uc778\ud074\ub8e8\ub4dc\uc640, \ub77c\uc774\ube0c\ub7ec\ub9ac \uacbd\ub85c\uac00 \uc5b4\ub514\uc5d0 \uc788\ub294\uc9c0 \ud655\uc778\ub9cc \ud558\uba74 \ub420\uac83\uc774\ub2e4.
\uadf8\ub7fc \ud14c\uc2a4\ud2b8\ub97c \uc704\ud55c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uace0 \ud14c\uc774\ube14\uc5d0 \uac04\ub2e8\ud55c \ub0b4\uc6a9\uc744 \uc785\ub825\ud574\ubcf4\uc790, \ud14c\uc774\ube14\uc774 \uc704\uce58\ud560 DB \ub294 test \uc774\uace0 \ud14c\uc774\ube14\uc758 \uc774\ub984\uc740 address \uc774\ub2e4. \n\n\n\n
CREATE TABLE address ( name varchar<\/A>(25) default NULL, address text, tel varchar<\/A>(25) default NULL ); <\/TD><\/TR><\/TBODY><\/TABLE>\uc774 \ud14c\uc774\ube14\uc740 \uac04\ub2e8\ud55c \uc8fc\uc18c\ub85d\uc778\ub370, \"\uc774\ub984\", \"\uc8fc\uc18c\", \"\uc804\ud654\ubc88\ud638\" \ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud574\uc11c \uc0ac\uc6a9\ub41c\ub2e4.
\uc774\uc81c \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574\uc11c 2\uac1c \uc815\ub3c4\uc758 data \ub97c \uc785\ub825\ud558\ub3c4\ub85d \ud558\uc790. \n\n\n\n
INSERT INTO address VALUES ('\ud64d\uae38\ub3d9','\uacbd\uae30\ub3c4 \uc5f0\ucc9c \uc5f0\ucc9c\uc544\ud30c\ud2b8','02-500-5000'); INSERT INTO address VALUES ('\uc544\ubb34\uac1c','\uad11\uc8fc\uad11\uc5ed\uc2dc \uc11c\uad6c \ud604\ub300 \uc544\ud30c\ud2b8','015-000-1111'); <\/TD><\/TR><\/TBODY><\/TABLE>\uc6b0\ub9ac\uac00 \ub9cc\ub4e4 \ud504\ub85c\uadf8\ub7a8\uc744 \ud14c\uc2a4\ud2b8 \ud558\uae30 \uc704\ud55c \ud658\uacbd\uc774 \uac16\ucd94\uc5b4 \uc84c\ub2e4\uba74, \uc774\uc81c \ubcf8\uaca9\uc801\uc73c\ub85c \ucf54\ub4dc\ub97c \uc791\uc131\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\ub2e4.

\uc608\uc81c : mysql_test.c<\/B> \n\n\n\n
\n

#include <mysql.h>
#include <string.h>
#include <stdio.h><\/P>\n


#define DB_HOST \"127.0.0.1\"
#define DB_USER \"root\"
#define DB_PASS \"gkwlak\"
#define DB_NAME \"test\"
#define CHOP(x) x[strlen(x) - 1] = ' '
   
int main(void)
{
    MYSQL       *connection=NULL, conn;
    MYSQL_RES   *sql_result;
    MYSQL_ROW   sql_row;
    int       query_stat; <\/P>\n

    char name[12];
    char address[80];
    char tel[12];
    char query[255];
   
    mysql_init(&conn);<\/P>\n

    connection = mysql_real_connect(&conn, DB_HOST,
                                    DB_USER, DB_PASS,
                                    DB_NAME, 3306,
                                    (char *)NULL, 0);<\/P>\n

    if (connection == NULL)
    {
        fprintf(stderr, \"Mysql connection error : %s\", mysql_error(&conn));
        return 1;
    }<\/P>\n

    query_stat = mysql_query(connection, \"select * from address\");
    if (query_stat != 0)
    {
        fprintf(stderr, \"Mysql query error : %s\", mysql_error(&conn));
        return 1;
    }
   
    sql_result = mysql_store_result(connection);
   
    printf(\"%+11s   %-30s   %-10s\", \"\uc774\ub984\", \"\uc8fc\uc18c\", \"\uc804\ud654\ubc88\ud638\");
    while ( (sql_row = mysql_fetch_row(sql_result)) != NULL )
    {
        printf(\"%+11s   %-30s   %-10s\", sql_row[0], sql_row[1], sql_row[2]);
    }<\/P>\n

    mysql_free_result(sql_result);<\/P>\n

    printf(\"\uc774\ub984 :\");
    fgets(name, 12, stdin);
    CHOP(name);<\/P>\n

    printf(\"\uc8fc\uc18c :\");
    fgets(address, 80, stdin);
    CHOP(address);<\/P>\n

    printf(\"\uc804\ud654 :\");
    fgets(tel, 12, stdin);
    CHOP(tel);<\/P>\n

    sprintf(query, \"insert into address values \"
                   \"('%s', '%s', '%s')\",
                   name, address, tel);<\/P>\n

    query_stat = mysql_query(connection, query);
    if (query_stat != 0)
    {
        fprintf(stderr, \"Mysql query error : %s\", mysql_error(&conn));
        return 1;
    }<\/P>\n

    mysql_close(connection);
}
<\/P><\/TD><\/TR><\/TBODY><\/TABLE>mysql \uc740 mysql \uc5f0\uacb0, query \uacb0\uacfc \ubc1b\uc544\uc624\uae30, \uacb0\uacfc\ubb3c\uc758 Row \uac12\uc744 \uc800\uc7a5\ub4f1\uc744 \uc704\ud55c \uba87\uac1c\uc758 \uad6c\uc870\uccb4\uac00 \uc874\uc7ac\ud55c\ub2e4.
\n\n\n\n\n\n\n\n
MYSQL<\/TD>\n\ub370\uc774\ud0c0 \ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud588\uc744\ub54c, \uc774 \uc5f0\uacb0\uc744 \ub2e4\ub8e8\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \uad6c\uc870\uccb4 \uc774\ub2e4<\/TD><\/TR>\n
MYSQL_RES<\/TD>\n(SELECT, SHOW, DESCRIBE, EXPLAIN)\ub4f1\uc758 \ucffc\ub9ac\ub97c \ub0b4\ub838\uc744\ub54c \uadf8 \uacb0\uacfc\ub97c \ub2e4\ub8e8\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \uad6c\uc870\uccb4\uc774\ub2e4. <\/TD><\/TR>\n
MYSQL_ROW<\/TD>\n\uc774\uac83\uc740 \ub370\uc774\ud0c0\uc758 \ud558\ub098\uc758 row \uac12\uc744 \uac00\ub9ac\ud0a8\ub2e4. \ub9cc\uc57d row \uac12\uc774 \uc5c6\ub2e4\uba74 null \uc744 \uac00\ub974\ud0a4\uac8c \ub41c\ub2e4. <\/TD><\/TR>\n
MYSQL_FIELD<\/TD>\n\uc774 \uad6c\uc870\uccb4\ub294 \uac01 \ud544\ub4dc\uc758 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. \uc5ec\uae30\uc5d0\ub294 \ud544\ub4dc\uc758 \uc774\ub984, \ud0c0\uc785, \ud06c\uae30 \ub4f1\uc758 \uc815\ubcf4\ub97c \uac00\uc9c0\uac8c \ub41c\ub2e4. mysql \uc5d0\uc11c DESC \ucffc\ub9ac\ub97c \ub0b4\ub838\uc744\ub54c\uc758 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4\uace0 \ubcf4\uba74\ub41c\ub2e4. <\/TD><\/TR>\n
MYSQL_FIELD_OFFSET<\/TD>\nmysql \ud544\ub4dc \ub9ac\uc2a4\ud2b8\uc758 \uc704\uce58\ub97c \uac00\uc9c4\ub2e4. <\/TD><\/TR><\/TBODY><\/TABLE>\n\uc774 \ud504\ub85c\uadf8\ub7a8\uc774 \ud558\ub294 \uc77c\uc740 \ucd5c\ucd08 mysql DB\uc5d0 \uc5f0\uacb0\uc744 \ud55c\ub2e4\uc74c\uc5d0 query \ub97c \ud1b5\ud558\uc5ec address \uc758 \ub0b4\uc6a9\uc744 \uac00\uc838\uc640\uc11c \ud654\uba74\uc5d0 \ucd9c\ub825\uc2dc\ucf1c\uc8fc\uace0. \ub2e4\uc74c\uc5d0 \uc0ac\uc6a9\uc790 \uc785\ub825\uc744 \ubc1b\uc544\uc11c DB\uc5d0 \uc800\uc7a5\ud558\ub294\ub370\uae4c\uc9c0\ub2e4. \uc55e\uc5d0\uc11c \ub9d0\ud588\ub4ef\uc774, \uc720\uc800 \uc778\ud130\ud398\uc774\uc2a4\ub77c\ub4e0\uac00 \ud558\ub294 \uae30\ub2a5\uc801\uc778 \uce21\uba74\uc740 \uc804\ud600 \uc2e0\uacbd\uc4f0\uc9c0 \uc54a\uc558\ub2e4. \uc774\ub7ec\ud55c \uce21\uba74\uc5d0 \ub300\ud574\uc11c\ub294 \ub098\uc911\uc5d0 curse \uacc4\uc5f4\uc744 \ub2e4\ub8e8\uba74\uc11c \uc5f0\uad6c\ud558\uac8c \ub420\uac83\uc774\ub2e4. \uadf8\ub7fc \uc774\uc81c\ubd80\ud130 \uc18c\uc2a4\ub97c \ubd84\uc11d\ud574 \ubcf4\uae30\ub85c \ud558\uaca0\ub2e4.

mysql_init<\/A>() \ub294 mysql DB\uc5d0 \uc5f0\uacb0\ud558\uae30 \uc804\uc5d0 \uac00\uc7a5 \uba3c\uc800 \uc2e4\ud589\ub418\uba70, mysql \uc5f0\uacb0 \uc9c0\uc2dc\uc790\ub97c \ucd08\uae30\ud654 \ud558\ub294 \uc77c\uc744 \ud55c\ub2e4. mysql_init<\/A>()\ub97c \uc774\uc6a9\ud574\uc11c mysql \uc5f0\uacb0\uc744 \ucd08\uae30\ud654 \ud558\uace0 \ub098\uc11c mysql_real_connect \ub97c \uc774\uc6a9\ud574\uc11c mysql \uc11c\ubc84\uc5d0 \uc2e4\uc81c\ub85c \uc811\uadfc\ud558\uac8c \ub41c\ub2e4. \uc544\uaddc\uba3c\ud2b8\ub85c\ub294 \uc6b0\ub9ac\uac00 \ud130\ubbf8\ub110\uc5d0\uc11c mysql \uc744\uc774\uc6a9\ud574\uc11c \uc811\uadfc\ud558\ub294\ub370 \ud544\uc694\ud55c, \ud638\uc2a4\ud2b8\uc774\ub984<\/A>(DB_HOST), \uc720\uc800\uacc4\uc815<\/A>(DB_USER), \uacc4\uc815\uc5d0 \ub300\ud55c \ud328\uc2a4\uc6cc\ub4dc<\/A>(DB_PASS), \uc811\uadfc \ud558\uace0\uc790 \ud558\ub294 DB\uc774\ub984<\/A>(DB_NAME), \ud3ec\ud2b8\ubc88\ud638<\/A>(DB_PORT) \ub4f1\uc774 \ub4e4\uc5b4\uac04\ub2e4. \uc5f0\uacb0\uc5d0 \uc131\uacf5\ud558\uba74 connection \ud578\ub4e4 \uac12\uc744 \ub118\uaca8\uc8fc\uace0 \uc2e4\ud328\ud558\uac8c \ub418\uba74 NULL \uac12\uc744 \ub118\uaca8 \uc8fc\uac8c \ub41c\ub2e4. \uc5b4\ub5a4 \uc774\uc720\ub85c \uc2e4\ud328\ud588\ub294\uc9c0 \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf4\uace0 \uc2f6\ub2e4\uba74 mysql_error<\/A>() \uc744 \uc0ac\uc6a9\ud558\ub77c.
mysql \uc11c\ubc84\ub85c\uc758 \uc5f0\uacb0\uae4c\uc9c0 \uc131\uacf5\uc801\uc73c\ub85c \ub9c8\ucce4\ub2e4\uba74, \uc774\uc81c query \ub97c \uc774\uc6a9\ud574\uc11c \ubcf8\uaca9\uc801\uc778 \uc791\uc5c5\uc5d0 \ub3cc\uc785\ud55c\ub2e4. mysql_query \ub97c \ud1b5\ud574\uc11c \ud544\uc694\ud55c query\ub97c \uc2e4\ud589 \uc2dc\ud0a4\uba74\ub41c\ub2e4.
\uc6b0\ub9ac\uac00 \ubcf4\ud1b5 \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\ub294 \"SELECT, SHOW, DESC, EXPLAIN\" \uacfc \uac19\uc774 \ucffc\ub9ac\uc5d0 \uadf8 \uacb0\uacfc \uac12<\/A>(row)\uc744 \uc694\uccad\ud558\ub294 \uac83\uacfc, \"INSERT, UPDATE, DELETE\" \uc640 \uac19\uc774 \uadf8 \uacb0\uacfc \uac12\uc774 \ud544\uc694 \uc5c6\ub294 \uba85\ub839\uc5b4\ub85c \ub098\ub204\uc5b4 \ubcfc\uc218 \uc788\ub2e4. row \uac12\uc744 \uc694\uccad\ud558\uc9c0 \uc54a\ub294 \ucffc\ub9ac\ub77c\uba74 \ud544\uc694\uac00 \uc5c6\uaca0\uc9c0\ub9cc row \uac12\uc744 \uc694\uccad\ud558\ub294 \ucffc\ub9ac\ub77c\uba74 \ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc744 \uc800\uc7a5\ud574\uc57c \ud560\uac83\uc774\ub2e4. \uc774\ub7f4\ub54c mysql_store_result<\/A>()\ub97c \uc774\uc6a9\ud574\uc11c \ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc744 \ub418\ub3cc\ub824 \ubc1b\uc744\uc218 \uc788\ub2e4. mysql_store_result<\/A>()\ub97c \ud1b5\ud574\uc11c \ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc744 \ub418\ub3cc\ub824 \ubc1b\uc558\ub2e4\uba74, mysql_fetch_row<\/A>()\ub97c \uc774\uc6a9\ud574\uc11c row \ub2e8\uc704\ub85c \uacb0\uacfc \uac12\uc744 \uac00\uc838\uc62c\uc218 \uc788\ub2e4. \uc774 \ud568\uc218\ub294 \ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc5d0\uc11c \ub2e4\uc74c\uc758 row \uac12\uc744 \uac00\uc838\uc624\uba70, \ub354\uc774\uc0c1 \uac00\uc838\uc62c row \uac12\uc774 \uc5c6\ub2e4\uba74 NULL \uc744 \ub3cc\ub824\uc900\ub2e4.
\uac00\uc838\uc628 row \uc5d0\uc11c\uc758 \uac01\ud544\ub4dc \uac12\uc740 row[0] \uc5d0\uc11c row[mysql_num_fields<\/A>(result)-1] \uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\uc73c \ubbc0\ub85c, \ud574\ub2f9 row \uc758 field \uac12\uc744 \uc27d\uac8c \uac00\uc838\uc62c\uc218 \uc788\ub2e4.
mysql_store_result<\/A>() \uc744 \ud1b5\ud574\uc11c \uac00\uc838\uc628 \ucffc\ub9ac\uacb0\uacfc\uac12\uc744 \ub354\uc774\uc0c1 \uc0ac\uc6a9\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4\uba74, \uba54\ubaa8\ub9ac\ub97c \ub418\ub3cc\ub824\uc918\uc57c \ud558\ub294\ub370, mysql_free_result \ub97c \ud1b5\ud574\uc11c \ub418\ub3cc\ub824\uc8fc\uba74 \ub41c\ub2e4. mysql_store_result<\/A>()\ub97c \uc0ac\uc6a9\ud588\ub2e4\uba74 \ubc18\ub4dc\uc2dc mysql_free_result<\/A>()\ub97c \uc0ac\uc6a9\ud574\uc11c \uba54\ubaa8\ub9ac\ub97c \ud574\uc81c \uc2dc\ucf1c\uc918\uc57c \ud55c\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uba54\ubaa8\ub9ac \ub204\uc218\uac00 \ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4.

mysql_free_result<\/A>()\uae4c\uc9c0 \uc2dc\ucf1c\uc8fc\uace0 \ub098\uc11c, fgets<\/A>() \ud568\uc218\ub97c \ud1b5\ud558\uc5ec\uc11c \"\uc774\ub984\", \"\uc8fc\uc18c\", \"\uc804\ud654\ubc88\ud638\" \ub97c \uc785\ub825\ubc1b\uc544\uc11c, \uc785\ub825\ubc1b\uc740 \uc815\ubcf4\ub85c \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uace0 \uc774\ub97c mysql_query<\/A>()\ub97c \uc774\uc6a9\ud574\uc11c DB \uc5d0 \uc801\uc7ac\ud558\ub294 \uac83\uc744 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc608\uc81c\uc758 \uc124\uba85\uc774 \ub05d\ub0ac\ub2e4.
\ub204\uac00 \ubcf4\ub354\ub77c\ub3c4 \uc774\ud574\ud558\uae30 \uc26c\uc6b4 \ucf54\ub4dc\uc77c\uac83\uc774\ub2e4. \uc774\uc81c \uc774 \ucf54\ub4dc\ub97c \ucef4\ud30c\uc77c \ud574\uc11c \uc2e4\ud589\uc2dc\ucf1c \ubcf4\ub294 \uc77c\ub9cc \ub0a8\uc558\ub2e4.
<\/TABLE>\n
\n\n\n
gcc -o mysql_test mysql_test.c -I\/usr\/local\/include\/mysql -L\/usr\/local\/lib\/mysql -lmysqlclient <\/TD><\/TR><\/TBODY><\/TABLE>\n

-I \uacfc -L \uc635\uc158\uc744 \uc774\uc6a9\ud574\uc11c \ucef4\ud30c\uc77c \uc2dc\ud0a4\ub294\ub370 \ud544\uc694\ud55c \uc778\ud074\ub8e8\ub4dc \ud30c\uc77c\uacfc \ub77c\uc774\ube0c\ub7ec\ub9ac \ud30c\uc77c\uc774 \uc788\ub294 \ub514\ub809\ud1a0\ub9ac\ub97c \uba85\uc2dc\ud574\uc8fc\uba74 \ub41c\ub2e4. \uc704\uc758 \ub514\ub809\ud1a0\ub9ac\ub294 \ud544\uc790\uac00 \uac00\uc9c4 \uc2dc\uc2a4\ud15c\uc758 \uacbd\uc6b0\uc774\uace0, \uc704\uc758 \ub514\ub809\ud1a0\ub9ac\ub294 \uc2dc\uc2a4\ud15c\uc5d0 \ub530\ub77c\uc11c \ub2e4\ub97c\uc218 \uc788\uc73c\ub2c8 \uc790\uc2e0\uc758 \uc2dc\uc2a4\ud15c \uc124\uc815\uc5d0 \ub9de\ub3c4\ub85d \uc635\uc158\uc744 \uc8fc\uace0 \ucef4\ud30c\uc77c \ud558\uae30 \ubc14\ub780\ub2e4.

\uc774\uc0c1 \uac04\ub2e8\ud558\uac8c mysql API \ub97c \uc0b4\ud3b4\ubcf4\uc558\ub2e4. \uc704\uc758 \uc608\uc81c\ub294 \ub9ce\uc740 mysql API \uc911\uc758 \uadf9\ud788 \uc77c\ubd80\ubd84\ub9cc\uc744 \uc368\uc11c \uaf2d\ud544\uc694\ud55c \uae30\ub2a5\ub9cc \uad6c\ud604\ud55c\uac83\uc774\ub2e4. \ub354 \uc790\uc138\ud55c \uc815\ubcf4\ub294 www.mysql.org \uc0ac\uc774\ud2b8\ub97c \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4. } }} <\/P>\n

 <\/P>\n

from www.joinc.co.kr<\/P>\n","protected":false},"excerpt":{"rendered":"

mysql \uc774 \uc6f9\uc5d0\uc11c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 RDBMS \ub77c\ub294 \ub370\ub294 \uc758\uc2ec\uc758 \uc5ec\uc9c0\uac00 \uc5c6\ub294 \uac83 \uac19\ub2e4. \uc8fc\ub85c Apache \uc640 PHP \uc640 \uc5f0\ub3d9\ud574\uc11c \uc0ac\uc6a9\ub418\uc5b4 \uc9c0\ub294\ub370 (\uc774 3\uac00\uc9c0 \uc870\ud569\uc744 APM \uc774\ub77c\uace0 \ud55c\ub2e4), \uac04\ub2e8\ud55c \uce74\uc6b4\ud130, \ubc29\uba85\ub85d\uc5d0\uc11c \ubd80\ud130, \uc880\ub354 \ubcf5\uc7a1\ud55c \uc1fc\ud551\ubab0, \uc2a4\ucf00\uc974\uad00\ub9ac, \uac8c\uc2dc\ud310, \uc6f9\uba54\uc77c \ub4f1 \uac70\uc758 \uc4f0\uc774\uc9c0 \uc54a\ub294 \uacf3\uc774 \uc5c6\uc744 \uc815\ub3c4\uc774\ub2e4.Mysql \uc774 PHP \uc640 \ud568\uaed8 \uc6f9\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294\uac8c \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc6a9\ub3c4\uc774\uae34 \ud558\uc9c0\ub9cc, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[19],"tags":[],"class_list":["post-61","post","type-post","status-publish","format-standard","hentry","category-development_lib"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=61"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/61\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}