busclass.sql

来自「orange源码 数据挖掘技术」· SQL 代码 · 共 12 行

USE test;
DROP TABLE busclass;
CREATE TABLE busclass 
  (m$id varchar(5), 
   line enum('9','10','11'), 
   daytime enum('morning','evening', 'midday'), 
   temp float, weather enum('rainy','sunny'), 
   c$arrival enum('late','on-time'));
LOAD DATA LOCAL INFILE 'bus.txt' INTO TABLE busclass;

SELECT * FROM busclass;