 |
|
 |
| |
Developer on focus
Anton Zamov is a dipl. engineer with more than 6 years of active professional
experience and many awards ...
read more>>
|
|
 |
 |
 |
|
|
|
|
| |
|
MySQL: Difficult Column Names, Like `DATE` -- use backtick
|
Difficult Column Names, Like `DATE` -- use backtick.
If using "date" as a column name, enclose it in backticks ` as follows:
CREATE TABLE IF NOT EXISTS stocks (
pkey int(11) NOT NULL auto_increment,
`date` date,
ticker varchar(5),
open float,
high float,
low float,
close float,
volume int,
timeEnter timestamp(14),
PRIMARY KEY (pkey)
) ;
To get 1 day old data reference:
http://biz.swcp.com/stocks/#Daily update
Statement to load data:
mysql> load data infile '/tmp/sp500hst.txt' into table stocks
fields terminated by ',' (date,ticker,open,high,low,close,volume);
|
About the author of this programming example or tutorial:
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (c) 2004 (GPU Free Documentation License)
Last Updated: Tue Jul 20 12:14:51 EDT 2004
|
|
|
|
|
|
|
|
