mysql connector c++ 使用_MySQL connector c++使用笔记

Connection

Driver

PreparedStatement

ResultSet

ResultSetMetaData

Statement

下载安装mysql connector c++, 启动mysql, 使用test database.

准备数据(使用官方提供的示例数据, 参考 MySQL手册 3.3.3 http://dev.mysql.com/doc/refman/5.1/zh/tutorial.html)

CREATE TABLE pet (

name VARCHAR(20),

owner VARCHAR(20),

species VARCHAR(20),

sex CHAR(1),

birth DATE,

death DATE

);

导入数据(路径可以为相对路径或绝对路径)

LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet;

pet.txt(修改中间的间隔为\t)

FluffyHaroldcatf1993-02-04\N

ClawsGwencatm1994-03-17\N

BuffyHarolddogf1989-05-13\N

FangBennydogm1990-08-27\N

BowserDianedogm1979-08-311995-07-29

ChirpyGwenbirdf1998-09-11\N

WhistlerGwenbird\N1997-12-09\N

SlimBennysnakem1996-04-29\N

示例代码

#include

#include "mysql_d