I need an import script that I can run via phpMyAdmin to get the attached excel file into a MySQL database. I've pasted the structure of that database as well below.
You can see that the excel file doesn't have a symbol_id field or the last_update field either. The symbol_id is added incrementally with each new entry.
I'm sure this is very easy so I will give an excellent review for a job well done. Thanks!
-- Table structure for table `symbol`
CREATE TABLE IF NOT EXISTS `symbol` (
`symbol_id` int(11) NOT NULL auto_increment,
`company_name` varchar(255) NOT NULL default '',
`symbol` varchar(20) NOT NULL default '',
`type` varchar(10) NOT NULL default '',
`last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`symbol_id`),
UNIQUE KEY `symbol` (`symbol`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17325 ;