按类别列出问题

Mathematics


软件 >> MySQL
Questions in category: MySQL (MySQL).

1

WampServer 设置

Posted by haifeng on 2014-05-04 14:45:01 last update 2014-05-04 15:32:19 | Answers (0) | 收藏

WampServer 中的 MySQL 设置文件位于

C:\wamp\bin\mysql\mysql5.5.24\my.ini:

打开后找到 [mysqld]  加入下面两行, 然后重新启动

character-set-server=utf8
collation-server=utf8_general_ci

2

mysql 设置字符集

Posted by haifeng on 2014-05-02 22:25:47 last update 2014-05-04 15:28:41 | Answers (0) | 收藏

mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

3

在 Shell 下执行 mysql 的 SQL 查询.

Posted by haifeng on 2012-10-08 15:14:19 last update 2012-10-08 15:20:06 | Answers (0) | 收藏

[haifeng@arch ~]$ mysql -u user -p -e \'SQL statements;\' database

其中

-u : 指定 mysql 数据库的用户名
-p : 提示输入密码
-e : 执行 sql 查询
database : 指定那个数据库


Reference

http://www.cyberciti.biz/faq/run-sql-query-directly-on-the-command-line/

4

学习 MySQL 的站点

Posted by haifeng on 2012-09-24 15:32:46 last update 2013-12-17 14:50:26 | Answers (0) | 收藏

http://www.mysql.cn/

http://www.mysqltutorial.org/

http://codingrecipes.com

http://www.tutorialspoint.com/mysql

 

sqlfiddle.com 提供了在线测试工具, 来测试和分享数据库的问题与解决方案.

http://sqlfiddle.com/

 

SQL 学习

http://www.sql-tutorial.com/

SQL 在线测试

http://www.sqlquiz.com/

 

 

5

MySQL 中的保留字

Posted by haifeng on 2012-09-18 09:15:12 last update 2012-09-18 09:16:25 | Answers (0) | 收藏

ADD
ALTER
COLUMN
CREATE
DESC/DESCRIBE
DISTINCT
DROP
FROM
LIMIT
ORDER BY
PRIMARY KEY
SELECT
SHOW
TABLE
UNIQUE
WHERE

Search

New posted more ...