USE nhds;
CREATE TABLE nhds99 (
svy_year int,
newborn char(1),
age_unit char(1),
age int,
sex char(1),
race char(1),
m_status char(1),
dis_month int,
dis_status char(1),
days_care int,
los_flag char(1),
geo_region char(1),
no_beds char(1),
hos_ownership char(1),
ana_weight int,
dc1 char(5),
dc2 char(5),
dc3 char(5),
dc4 char(5),
dc5 char(5),
dc6 char(5),
dc7 char(5),
pc1 char(4),
pc2 char(4),
pc3 char(4),
pc4 char(4),
p_src_payment char(2),
s_src_payment char(2),
drg char(3));
LOAD DATA
LOCAL INFILE 'nhds99.data'
INTO TABLE nhds99
FIELDS TERMINATED BY ',';
|