SQLシェル
まず、シェルを起動。-p でパスワード入力をする。
$ mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 463 to server version: 5.0.20a-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
データベースを列挙する
mysql> show databases; +--------------------+ | Database | +--------------------+ | mt | | mysql | +--------------------+ 8 rows in set (0.00 sec)
データベースを選択する
mysql> use mt; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed
テーブルを列挙する
mysql> show tables; +-----------------+ | Tables_in_mt | +-----------------+ | mt_author | | mt_blog | | mt_category | | mt_comment | | mt_config | | mt_entry | | mt_fileinfo | | mt_ipbanlist | | mt_log | | mt_notification | | mt_objecttag | | mt_permission | | mt_placement | | mt_plugindata | | mt_session | | mt_tag | | mt_tbping | | mt_template | | mt_templatemap | | mt_trackback | +-----------------+ 20 rows in set (0.00 sec)
テーブルのフィールドを列挙する
mysql> show fields from mt_author; +-----------------------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+--------------+------+-----+-------------------+----------------+ | author_id | int(11) | NO | PRI | | auto_increment | | author_api_password | varchar(60) | YES | | | | | author_can_create_blog | tinyint(4) | YES | | | | | author_can_view_log | tinyint(4) | YES | | | | | author_email | varchar(75) | YES | MUL | | | | author_hint | varchar(75) | YES | | | | | author_is_superuser | tinyint(4) | YES | | | | | author_name | varchar(50) | NO | MUL | | | | author_nickname | varchar(50) | YES | | | | | author_password | varchar(60) | NO | | | | | author_preferred_language | varchar(50) | YES | | | | | author_public_key | mediumtext | YES | | | | | author_remote_auth_token | varchar(50) | YES | | | | | author_remote_auth_username | varchar(50) | YES | | | | | author_type | smallint(6) | NO | MUL | 0 | | | author_url | varchar(255) | YES | | | | | author_created_on | datetime | YES | MUL | | | | author_created_by | int(11) | YES | | | | | author_modified_on | timestamp | YES | | CURRENT_TIMESTAMP | | | author_modified_by | int(11) | YES | | | | | author_entry_prefs | varchar(255) | YES | | | | +-----------------------------+--------------+------+-----+-------------------+----------------+ 21 rows in set (0.73 sec)