先复制页面表格数据到EXCEL中,比如
| 2012-1-4 | 52.7 | 52.7 | 49 | 48.83 | 190007 | 9506968 |
| 2012-1-5 | 48.86 | 49.79 | 45.72 | 45.6 | 623252 | 29890388 |
| 2012-1-6 | 45.71 | 46.71 | 44.85 | 43.71 | 453108 | 20183486 |
| 2012-1-9 | 45.18 | 45.3 | 44.79 | 43.5 | 757707 | 33454778 |
| 2012-1-10 | 44.81 | 46.71 | 45.99 | 44.45 | 625620 | 28381340 |
| 2012-1-11 | 45.55 | 46.82 | 44.88 | 44.61 | 844306 | 38555872 |
| 2012-1-12 | 45.7 | 46.3 | 44.47 | 44.04 | 650360 | 29329488 |
| 2012-1-13 | 44.28 | 44.47 | 40.02 | 40.02 | 1516461 | 62606884 |
| 2012-1-16 | 38.02 | 40.43 | 40.02 | 37.6 | 697920 | 27940500 |
然后在M1单元中 输入
=CONCATENATE("INSERT INTO `300105` VALUES ('",TEXT(E1,"yyyy-mm-dd"),"','",TEXT(ROUND(F1,3),"#.000"),"','",TEXT(ROUND(G1,3),"#.000"),"','",TEXT(ROUND(H1,3),"#.000"),"','",TEXT(ROUND(I1,3),"#.000"),"');")
然后在MYSQL新建数据库 表名为300105
CREATE TABLE `300105` (
`c_date` varchar(20) NOT NULL,
`c_kpj` varchar(50) NOT NULL,
`c_zgj` varchar(50) NOT NULL,
`c_spj` varchar(50) NOT NULL,
`c_zdj` varchar(50) NOT NULL,
PRIMARY KEY (`c_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
增加对应的项目名称
其中 TEXT(E1,"yyyy-mm-dd") 将第一列中日期以原来格式保存 TEXT(ROUND(F1,3),"#.000")会将 数值 保留后三位小数 不足以0填充 如例中第一条记录
| INSERT INTO `300105` VALUES ('2012-01-04','52.700','52.700','49.000','48.830'); |
做完记录后 将M1列复制到文本并保存.sql文件 用MYSQL导入即可