ClownWiki

この文書は読取専用です。文書のソースを閲覧することは可能ですが、変更はできません。もし変更したい場合は管理者に連絡してください。
====== コマンド  ======
===== テーブル構造・カラム一覧  =====
<code>
> DESCRIBE テーブル名;
</code>

===== index確認  =====
<code>
> show index from テーブル;
</code>

===== テーブル定義確認  =====
<code>
> show create table テーブル;
</code>

===== ユーザ確認  =====
<code>
> SELECT host,user FROM mysql.user;
+-----------+------+
| host      | user |
+-----------+------+
| 127.0.0.1 | root |
| localhost |      |
| localhost | root |
+-----------+------+
3 rows in set (0.00 sec)

> show grants;
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.02 sec)
</code>

===== 文字列連結  =====

==== CONCAT  ====

<code>
> SELECT CONCAT('THIS ','IS ','PEN');
+---------------------------------------------------------------------+
| CONCAT('THIS','IS','PEN')                                           |
+---------------------------------------------------------------------+
| THIS IS PEN                                                         |
+---------------------------------------------------------------------+
1 row in set (0.02 sec)
</code>

==== PIPES_AS_CONCAT  ====

<code>
> set @@session.sql_mode='PIPES_AS_CONCAT';
Query OK, 0 rows affected (0.00 sec)
</code>

<code>
> SELECT 'THIS ' || 'IS ' || 'PEN';
+---------------------------------------------------------------------+
| 'THIS ' || 'IS ' || 'PEN'                                           |
+---------------------------------------------------------------------+
| THIS IS PEN                                                         |
+---------------------------------------------------------------------+
1 row in set (0.02 sec)
</code>

<code>
# vi /etc/my.cnf
+) sql_mode = 'PIPES_AS_CONCAT'
</code>

===== エラーを無視してインポートする  =====
-f, –force Continue even if we get an SQL error.
<code>
mysql -uroot -ppassword -f dbname < ddl.sql
</code>

===== 接続中のMySQLが動作しているホスト名を確認 =====
<code>
mysql> show variables like '%hostname%';
+---------------+---------+
| Variable_name | Value   |
+---------------+---------+
| hostname      | mc-db04 |
+---------------+---------+
1 row in set (0.00 sec)
</code>

===== サーバステータスを確認 =====
<code>
mysql> \s
--------------
mysql  Ver 14.14 Distrib 5.5.32, for Linux (x86_64) using readline 5.1

Connection id:          4903
Current database:       
Current user:           root@192.168.24.222
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.5.32-log MySQL Community Server (GPL) by Remi
Protocol version:       10
Connection:             192.168.24.183 via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 39 min 39 sec

Threads: 2  Questions: 1606  Slow queries: 0  Opens: 125  Flush tables: 1  Open tables: 33  Queries per second avg: 0.675
--------------
</code>