[RESOLVED] error: Use of undeclared identifier 'mysql_create_db'; did you mean 'mysql_select_db'

[micha_eleric]

int mysql_create_db(MYSQL *mysql, const char *db)

highlights like development environment recognizes it, but is not found by compiler

#include <mysql.h>

int main(int argc, char *argv[])
{
MYSQL* PA;
mysql_create_db(conn, "mydatabase");


return 0;
}

from the few websites i found mysql_create_db, and said anything about #include, all that is needed is #include <mysql.h>

why does editor recognize mysql_create_db, but suggest mysql_select_db?
and how to use mysql_create_db?