Peruttu

simple MySQL script

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 ;

Taidot: PHP

Näytä lisää: simple mysql script, simple file database, primary job, php script null, php symbol, update mysql, timestamp, php script create table, null, int, import mysql, script update database mysql, mysql database import, excel file mysql, mysql create database engine, mysql structure, php mysql import script, import database excel mysql, simple script excel, mysql excellent, mysql update field, update database mysql, mysql review, mysql import excel table, excel timestamp

About the Employer:
( 82 reviews ) karachi, Pakistan

Projektin tunnus: #397945