这句话怎么错了 SELECT * FROM marryagedb order by stockdate where stockid="002178.SZ"; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 把where子句跟order子句位置换一下, SELECT * FROM marryagedb where stockid="002178.SZ" order by stockdate ; order by 的句子写在最后~~ 5楼的对。帖一个完整的select语句语法:SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr, ... [INTO OUTFILE 'file_name' export_options | INTO DUMPFILE 'file_name'] [FROM table_references [WHERE where_definition] [GROUP BY {col_name | expr | position} [ASC | DESC], ... [WITH ROLLUP]] [HAVING where_definition] [ORDER BY {col_name | expr | position} [ASC | DESC] , ...] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [PROCEDURE procedure_name(argument_list)] [FOR UPDATE | LOCK IN SHARE MODE]] 同样是获取100条数据,但 Sending data的消耗让人费解,望高手解答 关于临时表的存储引擎问题 求救【在线等候,急急急】 [菜鸟]mysql 建立带外键的表的问题 这样结果mysql怎么实现 mysql/data目录下的所有结构可以在系统间复制吗? 一个极其具有挑战性的问题!(1000分相送,不够再加) SOS!为什么mysql中给root加上密码后phpmyadmin就不能登陆了呢 在mysql的c接口中怎样把变量值的insert数据库中? mysql的查询sql语句中in关键字的选项中最多可以带多少个 sql 两字段相乘 后累加 能实现不? 请教一个mysql排序问题
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr, ...
[INTO OUTFILE 'file_name' export_options
| INTO DUMPFILE 'file_name']
[FROM table_references
[WHERE where_definition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_definition]
[ORDER BY {col_name | expr | position}
[ASC | DESC] , ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[FOR UPDATE | LOCK IN SHARE MODE]]