mysql> describe main; +--------------------+------------------+------+-----+---------+-------+---- -----------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +--------------------+------------------+------+-----+---------+-------+---- -----------------------------+ | commondata | varchar(30) | YES | | NULL | | select,insert,update,references | | id | int(10) unsigned | | PRI | 0 | | select,insert,update,references | | fpipart | varchar(100) | YES | | NULL | | select,insert,update,references | | description | varchar(100) | YES | | NULL | | select,insert,update,references | | documentfile | varchar(200) | YES | | NULL | | select,insert,update,references | | pumps | varchar(200) | YES | | NULL | | select,insert,update,references | | pumptype | int(10) unsigned | YES | | NULL | | select,insert,update,references | | maxflow | int(10) unsigned | YES | | NULL | | select,insert,update,references | | flowtype | varchar(200) | | | | | select,insert,update,references | | maxpressure | int(10) unsigned | YES | | NULL | | select,insert,update,references | | maxhead | int(10) unsigned | YES | | NULL | | select,insert,update,references | | field1 | int(10) unsigned | YES | | NULL | | select,insert,update,references | | mzxsyspressure | int(10) unsigned | YES | | NULL | | select,insert,update,references | | maxtemp | int(10) unsigned | YES | | NULL | | select,insert,update,references | | speed | int(10) unsigned | YES | | NULL | | select,insert,update,references | | applicationservice | int(10) unsigned | YES | | NULL | | select,insert,update,references | | valves | int(10) unsigned | YES | | NULL | | select,insert,update,references | | pipesize | int(10) unsigned | YES | | NULL | | select,insert,update,references | | orificesize | int(10) unsigned | YES | | NULL | | select,insert,update,references | | minimum | int(10) unsigned | YES | | NULL | | select,insert,update,references | | opacinertgas | int(10) unsigned | YES | | NULL | | select,insert,update,references | | opacinertwater | int(10) unsigned | YES | | NULL | | select,insert,update,references | | opaclightoil | int(10) unsigned | YES | | NULL | | select,insert,update,references | | opdcinertgas | int(10) unsigned | | | 0 | | select,insert,update,references | | opdcinertwater | int(10) unsigned | | | 0 | | select,insert,update,references | | opdclightoil | int(10) unsigned | | | 0 | | select,insert,update,references | | maxfluidtempac | int(10) unsigned | | | 0 | | select,insert,update,references | | maxfluidtempdc | int(10) unsigned | | | 0 | | select,insert,update,references | | bodymatl | varchar(100) | | | | | select,insert,update,references | | seatingmatl | varchar(100) | | | | | select,insert,update,references | | qtyorder | int(10) unsigned | | | 0 | | select,insert,update,references | | docexists | varchar(100) | | | | | select,insert,update,references | | price | varchar(50) | | | | | select,insert,update,references | | userprice | varchar(50) | | | | | select,insert,update,references | | pricetext | varchar(50) | | | | | select,insert,update,references | | ordernotes | varchar(100) | | | | | select,insert,update,references | | websiteinfo | varchar(100) | | | | | select,insert,update,references | | rfe1 | varchar(100) | | | | | select,insert,update,references | | rfe2 | varchar(100) | | | | | select,insert,update,references | | rfeval1 | varchar(100) | | | | | select,insert,update,references | | rfeval2 | varchar(100) | | | | | select,insert,update,references | | weight | int(10) unsigned | | | 0 | | select,insert,update,references | | oemtext | varchar(100) | | | | | select,insert,update,references | +--------------------+------------------+------+-----+---------+-------+---- -----------------------------+ 43 rows in set (0.00 sec) mysql> show index from main; +-------+------------+----------+--------------+-------------+-----------+-- -----------+----------+--------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-------+------------+----------+--------------+-------------+-----------+-- -----------+----------+--------+---------+ | main | 0 | PRIMARY | 1 | id | A | 1 | NULL | NULL | NULL | +-------+------------+----------+--------------+-------------+-----------+-- -----------+----------+--------+---------+ 1 row in set (0.00 sec) FIRST 5 RECORDS: ~1~"IQ-AP15-CSQM"~"Cast Iron Progressive Cavity Pump with Buna stator"~"IQ PC pump.pdf"~"0"~0~1.90~"GPM"~150~346~"0"~0~190~~0~"0"~~~0~0~0~0~0~0~0~0~0~~~0~ 1~$384.00~$384.00~~~~~~~~~ ~2~"IQ-AP22-CSQM"~"Cast Iron Progressive Cavity Pump with Buna stator"~"IQ PC pump.pdf"~"0"~0~4.90~"GPM"~100~231~"0"~0~190~~0~"0"~~~0~0~0~0~0~0~0~0~0~~~0~ 1~$387.00~$387.00~~~~~~~~~ ~3~"IQ-AP33-CSQM"~"Cast Iron Progressive Cavity Pump with Buna stator"~"IQ PC pump.pdf"~"0"~0~9.40~"GPM"~50~116~"0"~0~190~~0~"0"~~~0~0~0~0~0~0~0~0~0~~~0~1 ~$389.00~$389.00~~~~~~~~~ ~4~"IQ-AP44-CSQM"~"Cast Iron Progressive Cavity Pump with Buna stator"~"IQ PC pump.pdf"~"0"~0~15.00~"GPM"~50~116~"0"~0~190~~0~"0"~~~0~0~0~0~0~0~0~0~0~~~0~ 1~$396.00~$396.00~~~~~~~~~ ~5~"IQ-AP56-CSQM"~"Cast Iron Progressive Cavity Pump with Buna stator"~"IQ PC pump.pdf"~"0"~0~24.00~"GPM"~50~116~"0"~0~190~~0~"0"~~~0~0~0~0~0~0~0~0~0~~~0~ 1~$726.00~$726.00~~~~~~~~~ Command used to load data: load data local infile "main.txt" into table main fields terminated by '~' enclosed by '"' lines terminated by '\n' --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
