一、MySQL命令
1.USE dataname; 使用库
2.SHOW TABLES; 列出库中的所有表
3.DESCRIBE tablename显示表的属性
4.查询类命令
查询数值型数据:
SELECT * FROM tb_name WHERE sum > 100;
查询谓词:>,=,<,<>,!=,!>,!<,=>,=<
查询字符串
SELECT * FROM tb_stu WHERE sname = '小刘'
SELECT * FROM tb_stu WHERE sname like '刘%'
SELECT * FROM tb_stu WHERE sname like '%程序员'
SELECT * FROM tb_stu WHERE sname like '%PHP%'
查询日期型数据
SELECT * FROM tb_stu WHERE date = '2011-04-08'
注:不同数据库对日期型数据存在差异: :
(1)MySQL:SELECT * from tb_name WHERE birthday = '2011-04-08'
(2)SQL Server:SELECT * from tb_name WHERE birthday = '2011-04-08'
(3)Access:SELECT * from tb_name WHERE birthday = #2011-04-08#
查询逻辑型数据
SELECT * FROM tb_name WHERE type = 'T'
SELECT * FROM tb_name WHERE type = 'F'
查询表的数据量
SELECT COUNT(*) FROM tb_name;
5.插入数据
INSERT INTO tablename(类目1, 类目2) VALUES(data1, data2);
6.删除数据
DELETE FROM tablename WHERE ...
二、C++客户端函数
1.int mysql_query (MYSQL *connection, const char *query);执行SQL语句,connection是SQL结构体,query是命令字符串,成功执行返回0
2.int mysql_insert_id (MYSQL *connection);返回刚刚插入的数据ID号