mysql:command
文書の過去の版を表示しています。
コマンド
テーブル構造・カラム一覧
> DESCRIBE テーブル名;
index確認
> show index from テーブル;
テーブル定義確認
> show create table テーブル;
ユーザ確認
> 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)
文字列連結
CONCAT
> SELECT CONCAT('THIS ','IS ','PEN');
+---------------------------------------------------------------------+
| CONCAT('THIS','IS','PEN') |
+---------------------------------------------------------------------+
| THIS IS PEN |
+---------------------------------------------------------------------+
1 row in set (0.02 sec)
PIPES_AS_CONCAT
> set @@session.sql_mode='PIPES_AS_CONCAT'; Query OK, 0 rows affected (0.00 sec)
> SELECT 'THIS ' || 'IS ' || 'PEN'; +---------------------------------------------------------------------+ | 'THIS ' || 'IS ' || 'PEN' | +---------------------------------------------------------------------+ | THIS IS PEN | +---------------------------------------------------------------------+ 1 row in set (0.02 sec)
# vi /etc/my.cnf +) sql_mode = 'PIPES_AS_CONCAT'
エラーを無視してインポートする
-f, –force Continue even if we get an SQL error.
mysql -uroot -ppassword -f dbname < ddl.sql
mysql/command.1397789279.txt.gz · 最終更新: 2025/02/16 13:50 (外部編集)