mySql delete
include
include
int main() { MYSQL* conn; conn = mysql_init(0);
conn = mysql_real_connect(conn, "localhost", "username", "password", "database_name", 0, NULL, 0);
if(conn){
std::cout << "Connected to database" << std::endl;
if(mysql_query(conn, "DELETE FROM table_name WHERE condition")){
std::cout << "Delete operation failed: " << mysql_error(conn) << std::endl;
} else {
std::cout << "Delete operation successful" << std::endl;
}
} else {
std::cout << "Connection failed" << std::endl;
}
mysql_close(conn);
return 0;
}