bus.sql

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

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

SELECT * FROM bus;