USE test;


CREATE TABLE table256 (
  N_O_data_id int(10) unsigned NOT NULL default '0',
  E_OA_recency int(11) default NULL,
  T_buy_1y int(11) default NULL,
  T_buy_6m int(11) default NULL,
  T_buy_2m int(11) default NULL,
  PRIMARY KEY  (N_O_data_id)
) ENGINE=MyISAM DEFAULT CHARSET=cp932;

LOAD DATA INFILE '/win/table256.csv' INTO TABLE table256 FIELDS TERMINATED BY ',' ENCLOSED BY '"';

SELECT T_buy_1y, COUNT(*) FROM table256 GROUP BY T_buy_1y;

SELECT T_buy_1y FROM table256 PROCEDURE ANALYSE();
