The example shows how to use C to operate a MySQL database class

Create an empty console program, create a cpp file, and add the following ** to it. **Section:

cpp**。

#include

Define the socket

#include

#include""

#pragma comment( lib, "");

This sentence is the same as the functionality added to the additional dependenciesusingnamespace std;

int main(char **args)else

1. Attach the directory containing the header file, include is the folder.

2. Attach the library directory, the file in mysql lib is the file in 3, attach the dependency, the name is.

4. Copy the copy to the debug folder, which is available in the lib folder.

What the hell do you look for mysql connectors ->connector c or c++.

The next corresponding version will do.

mysql c api

mysql c++ api

mysql++

MySQL provides all functions, and classes are self-encapsulated.

Mysql++ library, specifically for C++, MySQL manipulation encapsulation...

Web Links. The latest version, Mysql++, includes the VC project, how to use it, etc.

#include

include.

include Make sure to add the mysql header file to the compiler directory

The project needs to be connected.

The executor needs to contain.

int main()

if(mysql_options(temp, mysql_set_charset_name, "gbk"))

temp2 = mysql_real_connect(temp, hostname, usernmae, password, dbname, port, null, 0);

if(!temp2)

printf("If the connection is successful, temp2 is the mysql connection, which is used for subsequent query operations. "); return 0;}

First of all, you should be familiar with basic SQL statements, including at least database creation, table creation, and table addition, deletion, modification, and query. This is fundamental to the operation of all databases.

Then, because the specific database has its own characteristics, and you are using MySQL, then you need to understand the specific statements of the corresponding operations in MySQL. My suggestion is to install MySQL first, log in to connect to the database on the command line, and then practice on the command line until you are proficient in the basic operations of the database (especially the addition, deletion, modification and query of tables). As for MySQL's visual interface, that's just to facilitate these operations.

If you're just making a small program, you don't need a visual interface.

After that, you should learn how to manipulate the database in the program. I don't think this has much to do with MFC or C++. The use of databases in the program can be broadly divided into the following steps:

Load the driver. Establish a connection to the database.

Get the statement object through the connection above.

Execute specific SQL statements through statement objects to obtain and process result sets.

Close the connection. Each of these steps has some small knowledge points that you need to learn on your own. For example, loading a driver may involve a driver package, and to establish a connection, you need to know the URL writing and username and password of the connection to MySQL in the program, obtain the statement object statement and preparestatement, execute SQL statements into two categories: query and update, and close the connection in order. These should be able to find information on the Internet, and the steps of the operation are all dead, so as long as you know it, it is not difficult.

My suggestion is to write a small program by yourself, and then realize the operation of the database in this program, as long as you can query the database in this program, then you will be familiar with this process, and those complex operations will not be difficult to achieve.

Also, manipulating a database in a program is not much different from manipulating a database on the command line, so it's important to practice using a database on the command line.

Master the syntax of MySQL.

Learn how to use the libraries you need to connect to MySQL in C++.

Do the above two steps and you will be able to use your MySQL database.

Of course, you must install MySQL and then enable the service.