还有mysql里面察看命令帮助,我如何操作。
解决方案 »
- Where查询条件中能用函数吗?
- mysql设置输出没有head
- MYSQL复制中的NOW()的问题
- 数组查询?
- delete from password n where n.user_id in(select n.user_id from password n where n.uid='3584');
- 如何往新建的mysql里导入mysql数据库备份sql文件?
- 请问:有我两个不同OS的MYSQL的情况下。如何操作
- asp+mysql
- 通过sql语句查看表结构的小问题
- LEFT JOIN关联查询出来的数据会成倍增加?大神指点。
- 求教:doesn't have a default value错误
- 请教两个关于PSQL的问题
Name: 'SELECT'
Description:
Syntax:
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 [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]
mysql> helpFor information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other products, visit:
https://shop.mysql.com/List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
可以用GRANT,也可用CREATE USER。
你所想了解的在MYSQL的手册中都有。建议花20分钟浏览一下手册的结构。
http://dev.mysql.com/doc/refman/5.1/zh/index.html