1. MySQL简介
MySQL是一个开源的关系型数据库管理系统,由瑞典MySQL AB 公司开发,目前属于 Oracle 旗下产品。它具有体积小、速度快、总体拥有成本低的特点,使得MySQL在许多中小型网站中很受欢迎。
2. MySQL简单入门
(1)创建数据库:create database [database_name];
(2)删除数据库:drop database [database_name];
(3)显示当前的数据库:show databases;
(4)使用数据库:use database_name;
(5)创建表:create table [table_name] (column_name column_type);
(6)显示当前数据库所拥有的表:show tables;
(7)插入数据:insert into [table_name] (column_name,...) values(column_value,...);
(8)查询数据:select column_name,... from [table_name] where [condition];
(9)删除数据:drop from [table_name] where [condition];
(10)修改数据:update [table_name] set column_name = new value where [condition];
3. C/C++简单使用MySQL
C/C++通过MySQL提供的API进行操作MySQL,一般情况下,步骤如下: a.初始化数据库; b.创建一个连接对象并初始化; c.连接数据库; d.创建SQL语句,并执行; e.关闭服务
#include<iostream>
#include<winsock.h>
#include<mysql.h>
#include<stdlib.h>
#include<string.h>
using namespace std;
int main(void)
{
//1.初始化数据库
if(0 == mysql_library_init(0,NULL,NULL))
{
cout<<" mysql library init succeed"<<endl;
}
else
{
cout<<" mysql library init failed"<<endl;
return -1;
}
//2.创建一个连接对象
MYSQL conn;
if(NULL != mysql_init(&conn))
{
cout<<" mysql init succeed"<<endl;
}
else
{
cout<<" mysql init failed"<<endl;
return -1;
}
//3.连接数据库
if(!mysql_real_connect(&conn,"127.0.0.1","root","mysql","test",0,0,0);)
{
cout<<"mysql failed to connect to database:"<<mysql_error(&conn)<<endl;
exit(-1);
}
//4.创建SQL语句
string sqlstr;
sqlstr = "create table user_info";
sqlstr +="(user_id int not null primary key,";
sqlstr +="user_name varchar(30),";
sqlstr +="user_sex varchar(2),";
sqlstr +="user_age int,";
sqlstr +="user_telephone varchar(11)";
sqlstr +=");";
//5.执行SQL语句
if(0 == mysql_query(&conn),sqlstr.c_str()))
{
cout<<" mysql query create table succeed"<<endl;
}
else
{
cout<<" mysql query create table failed"<<endl;
mysql_close(mysql);
eixt(-1);
}
//6.关闭mysql服务
mysql_close(&conn);
mysql_library_end();
return 0;
}
最后,程序编译时需指明所依赖的MySQL库,即可: g++ mysql_create.cpp -o create -I/usr/include/mysql -lmysqlclient