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`



`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`)


Taidot: PHP

Näytä lisää: simple mysql script, simple file database, primary job, php script null, create symbol, php symbol, update mysql, timestamp, php script create table, null, int, import mysql, script update database mysql, mysql database import, php import excel file mysql, 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

Tietoa työnantajasta:
( 82 arvostelua ) karachi, Pakistan

Projektin tunnus: #397945