// -------------------------------------------------------------------- /* mysql_delete.cpp Jun/06/2011 */ // -------------------------------------------------------------------- #include #include using namespace std; #include #include #include #define MYSQL_SERVER "host_mysql" #define MYSQL_USERNAME "scott" #define MYSQL_PASSWORD "tiger" #define MYSQL_DB "city" #define MYSQL_SOCKET "/var/run/mysqld/mysqld.sock" #define MYSQL_OPT 0 // -------------------------------------------------------------------- int main (int argc, char *argv[]) { cerr << "*** 開始 ***\n"; char id_in[10]; strcpy (id_in,argv[1]); cout << id_in << endl; int count; MYSQL mysql_buf; MYSQL *mysql=0; MYSQL_RES *result; MYSQL_ROW record; mysql_init(&mysql_buf); mysql = mysql_real_connect (&mysql_buf, MYSQL_SERVER, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DB, MYSQL_PORT, MYSQL_SOCKET, MYSQL_OPT); if (!mysql) { cerr << "*** ffff ***\n"; printf("failed to connect to mysql server (server=%s, userid=%s)\n", MYSQL_SERVER ? MYSQL_SERVER : "", MYSQL_USERNAME ? MYSQL_USERNAME : ""); return (-1); } mysql_query (&mysql_buf, "SET NAMES utf8"); result = mysql_store_result (&mysql_buf); char str_sql[255]; sprintf (str_sql,"delete from cities where ID = '%s'",id_in); cout << str_sql << "\n"; mysql_query (&mysql_buf, str_sql); result = mysql_store_result (&mysql_buf); mysql_close(&mysql_buf); mysql_free_result(result); cerr << "*** 終了 ***\n"; return 0; } // --------------------------------------------------------------------