· 9 years ago · Oct 11, 2016, 05:58 PM
1DROP TABLE IF EXISTS `companies`; 2CREATE TABLE `companies` ( 3 `cik` varchar(10) NOT NULL, 4 `name` varchar(240) DEFAULT NULL 5); 6CREATE INDEX cik ON companies(cik); 7SELECT * FROM `companies`;