Year month value
2009 1 1.1
2009 2 1.2
2009 3 1.3
2009 4 1.4
2010 1 2.1
2010 2 2.2
2010 3 2.3
2010 4 2.4
文件如上所示,但在load data infile时,在fields terminated by ' '遇到问题,用空格好像不对,不知道该怎么写域分隔符,因为在文件里两个分隔符的空格数不一样,有办法解决吗吗
2009 1 1.1
2009 2 1.2
2009 3 1.3
2009 4 1.4
2010 1 2.1
2010 2 2.2
2010 3 2.3
2010 4 2.4
文件如上所示,但在load data infile时,在fields terminated by ' '遇到问题,用空格好像不对,不知道该怎么写域分隔符,因为在文件里两个分隔符的空格数不一样,有办法解决吗吗
INFILE 'data_file'
INTO TABLE table_name
(@var1)
SET year = substr( @var1 , 0, 4 ),
month = substr( @var1 , 6, 2 ),
value = substr( @var1 , 11, 5 );