股价信息查询代码记录

备份数据库股价信息查询代码

SELECT
`每日行情查询`.`日期`,
LEFT(`每日行情查询`.`股票代码`,6) AS 股票代码,
`股票基础信息`.`股票名称`,
`每日触板`.`涨停原因类别（拆分）`,
`股票基础信息`.`所属同花顺行业` AS 同花顺板块,
`股票基础信息`.`所属东方财富行业` AS 东财板块,
LEFT(`每日行情查询`.`股票代码`,3) AS 证券划分,
`每日资金流向`.`集合竞价`,
`每日资金流向`.`主力净流入` AS 净流入,
`每日资金流向`.`实时超大单数据净额` AS 超大,
`每日资金流向`.`实时大单数据净额` AS 大户,
`每日行情查询`.`开盘`,
`每日行情查询`.`收盘`,
`每日行情查询`.`最低`,
`每日行情查询`.`最高`,
`每日行情查询`.`成交量`,
`每日行情查询`.`成交额`,
`每日行情查询`.`振幅`,
`每日行情查询`.`换手率`,
`每日行情查询`.`涨跌幅`,
`每日行情查询`.`涨跌`,
`每日触板`.`涨停原因类别`

FROM `每日行情查询`
LEFT JOIN `股票基础信息`
ON `每日行情查询`.`股票代码`= `股票基础信息`.`股票代码` 

LEFT JOIN `每日触板`
ON `每日行情查询`.`日期`= `每日触板`.`日期` AND `每日行情查询`.`股票代码`=`每日触板`.`股票代码`
left JOIN `每日资金流向`
ON LEFT(`每日行情查询`.`股票代码`,6)= `每日资金流向`.`股票代码` AND `每日行情查询`.`日期`= `每日资金流向`.`日期`

WHERE      `每日行情查询`.`日期` >= CURDATE() - INTERVAL 100 DAY 
ORDER BY   `每日行情查询`.`日期` DESC, `每日行情查询`.`股票代码` ;