00023351 010006 2009-09-27 20:10:22 58.00 特价
00023372 030031 2009-09-27 21:33:35 69.00 特价
00023447 040102 2009-09-28 21:12:34 69.00 特价
00023448 020173 2009-09-28 21:12:34 69.00 特价
00023449 040017 2009-09-28 21:13:48 69.00 特价
00023464 030132 2009-09-28 21:37:42 81.00 正常
00023465 020145 2009-09-28 21:40:53 60.00 正常
00023466 030087 2009-09-28 21:45:17 72.00 正常
00023467 020102 2009-09-28 21:46:54 51.00 正常
00023469 040051 2009-09-28 21:51:02 60.00 正常
00023472 010299 2009-09-28 22:00:09 60.00 正常
00023496 010128 2009-09-29 19:11:19 72.00 特价
00023499 040239 2009-09-29 19:16:34 51.00 特价
00023500 030108 2009-09-29 19:16:34 60.00 特价
00023501 030089 2009-09-29 19:16:34 72.00 特价
00023502 030068 2009-09-29 19:16:34 81.00 特价
从txt文档导入mysql如何让秒钟显示出来和不显示后面的小数点,以及需要金额后面的两位小数点
这是mysql语句
drop table if exists rfm2a;
create table rfm2a
(
id varchar(20),
customer int(10),
date datetime(6),
#money NUMERIC(8),
money decimal(10,2),
type varchar(20)
);
#MYSQL_QUERY('SET NAMES GBK');
load data infile 'G:\\mysql\\data\\rfm.txt' into table rfm2a