江苏龙网

  1. 主页 > 生活百科 > >

C/C++连接MySql数据库使用总结( 四 )

C++

四、运行结果

C/C++连接MySql数据库使用总结

文章插图
 
五、数据库脚本
/*Navicat MySQL Data TransferSource Server : localhostSource Server Version : 50141Source Host : localhost:3306Source Database : excelTarget Server Type : MYSQLTarget Server Version : 50141File Encoding : 65001Date: 2011-09-23 10:41:43*/1: SET FOREIGN_KEY_CHECKS=0; 2: -- ---------------------------- 3: -- Table structure for `test` 4: -- ---------------------------- 5: DROP TABLE IF EXISTS `test`; 6: CREATE TABLE `test` ( 7: `x` bigint(4) NOT NULL AUTO_INCREMENT, 8: `y` int(4) DEFAULT NULL, 9: `z` int(4) DEFAULT NULL, 10: PRIMARY KEY (`x`) 11: ) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=latin1; 12:13: -- ---------------------------- 14: -- Records of test 15: -- ---------------------------- 16: INSERT INTO `test` VALUES ('95', '12432', '4334'); 17: INSERT INTO `test` VALUES ('96', '213', '321'); 18: INSERT INTO `test` VALUES ('97', '213', '213'); 19: INSERT INTO `test` VALUES ('98', '123', '231'); 20: INSERT INTO `test` VALUES ('99', '321', '231'); 21: INSERT INTO `test` VALUES ('100', '123', '32132'); 22: INSERT INTO `test` VALUES ('101', '777', '32213'); 23: INSERT INTO `test` VALUES ('102', '123', '213'); 24: INSERT INTO `test` VALUES ('103', '21', '321'); 25: INSERT INTO `test` VALUES ('104', '324', '432'); 26: INSERT INTO `test` VALUES ('105', '132', '231'); 27: INSERT INTO `test` VALUES ('106', '324', '342'); 28: INSERT INTO `test` VALUES ('107', '23', '23'); 29: INSERT INTO `test` VALUES ('108', '12', '21'); 30: INSERT INTO `test` VALUES ('109', '231', '321'); 31: INSERT INTO `test` VALUES ('110', '123', '231'); 32: INSERT INTO `test` VALUES ('111', '123', '231'); 33: INSERT INTO `test` VALUES ('112', '123', '123'); 34: INSERT INTO `test` VALUES ('113', '312', '231'); 35: INSERT INTO `test` VALUES ('114', '312', '321'); 36: INSERT INTO `test` VALUES ('115', '23', '3'); 37: INSERT INTO `test` VALUES ('116', '213', '312'); 38: INSERT INTO `test` VALUES ('117', '2', '3'); 39:40: -- ---------------------------- 41: -- Table structure for `xqdata` 42: -- ---------------------------- 43: DROP TABLE IF EXISTS `xqdata`; 44: CREATE TABLE `xqdata` ( 45: `代码` varchar(20) NOT NULL DEFAULT '', 46: `商品` varchar(20) CHARACTER SET utf8 DEFAULT NULL, 47: `卖出` bigint(20) DEFAULT NULL, 48: `成交` bigint(20) DEFAULT NULL, 49: `涨跌` bigint(20) DEFAULT NULL, 50: `买进` bigint(20) DEFAULT NULL, 51: `总量` bigint(20) DEFAULT NULL, 52: `涨幅` double DEFAULT NULL, 53: `时间` time DEFAULT NULL, 54: PRIMARY KEY (`代码`) 55: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 56:57: -- ---------------------------- 58: -- Records of xqdata 59: -- ---------------------------- 60: INSERT INTO `xqdata` VALUES ('FITX*1', '商品', '34', '43', '23', '34', '0', '1.4', '13:23:08');
【C/C++连接MySql数据库使用总结】


推荐阅读


上一篇：一个Java字符串中到底有多少个字符？

下一篇：CenterOS 7.5下Mysql Cluster 7.6.12高可用集群搭建