MySQL DELETE query doesn't delete element from c++ code

Question

I have this simple code:

    std::stringstream del;
    int ret = 0;
    del<<"DELETE FROM 'database_name' WHERE id=\""<<id<<"\""; //id is a parameter of the function
    std::string query = del.str();
    const char* ch_q = query.c_str();
    ret = mysql_query(conn, ch_q);
    if(ret == 0)
    {
        std::cout<<"Record deleted successfully"<<std::endl;
        return true;
    }else{
        std::cout<<"Failed to delete record"<<std::endl;
        return false;
    }

The id row in the database has a type of TEXT and is a PRIMARY KEY Every time I run the code, it fails to delete the element.

Have you queried the MySQL library for the exact error message? — Asteroids With Wings, Jan 15 '21 at 10:23
Have you considered using parameters? Building SQL like this is usually bad. — Asteroids With Wings, Jan 15 '21 at 10:24
"It fails to delete the element" And does it report any error? If so, what? It presumably does. — underscore_d, Jan 15 '21 at 10:45

score 0 · Accepted Answer · answered Jan 15 '21 at 10:33

0

Your statement has an error where you're naming the table.

From the MySQL manual page on identifiers:

The identifier quote character is the backtick (`)

So:

DELETE FROM `database_name`

You've used a single-quote instead:

DELETE FROM 'database_name'

answered Jan 15 '21 at 10:33

Asteroids With Wings

17,071
2
21
35

MySQL DELETE query doesn't delete element from c++ code

1 Answers1