mysql 入力
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
単語検索
|
最終更新
|
ヘルプ
]
開始行:
[[mysql]]
[[マニュアル:https://dev.mysql.com/doc/refman/5.6/ja/]]
[[【MySQL, SQL】データベースを扱う基本SQL一覧:https://qii...
[root@pc0700-vm wp]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 8.0.17 Source distribution
Copyright (c) 2000, 2019, Oracle and/or its affiliates. ...
Oracle is a registered trademark of Oracle Corporation a...
affiliates. Other names may be trademarks of their respe...
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the cu...
mysql>
mysql> select Host, User from mysql.user;
+-----------+------------------+
| Host | User |
+-----------+------------------+
| localhost | admin |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | phpmyadmin |
| localhost | redmine |
| localhost | root |
| localhost | wordpress |
+-----------+------------------+
8 rows in set (0.00 sec)
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| redmine |
| sys |
| wordpress |
+--------------------+
7 rows in set (0.00 sec)
mysql>
mysql> create database test;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| redmine |
| sys |
| test |
| wordpress |
+--------------------+
8 rows in set (0.00 sec)
mysql> use test;
Database changed
mysql> show tables;
Empty set (0.01 sec)
mysql>
mysql> create table test (
-> id int(10) unsigned NOT NULL AUTO_INCREMENT,
-> name varchar(64) NOT NULL,
-> address varchar(128) NOT NULL,
-> tel varchar(64) NOT NULL,
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected, 1 warning (0.03 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| test |
+----------------+
1 row in set (0.00 sec)
mysql> show create table test;
..
| test | CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`address` varchar(128) NOT NULL,
`tel` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_...
..
1 row in set (0.00 sec)
mysql> insert into test ( id, name, address, tel) values...
Query OK, 1 row affected (0.01 sec)
mysql> select * from test;
+----+----------+----------+------+
| id | name | address | tel |
+----+----------+----------+------+
| 1 | sekigawa | kanagawa | 0123 |
+----+----------+----------+------+
1 row in set (0.00 sec)
mysql>
mysql> use wordpress;
Reading table information for completion of table and co...
You can turn off this feature to get a quicker startup w...
Database changed
mysql>
mysql> select database();
+------------+
| database() |
+------------+
| wordpress |
+------------+
1 row in set (0.00 sec)
mysql>
mysql> show tables;
+-----------------------+
| Tables_in_wordpress |
+-----------------------+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
12 rows in set (0.00 sec)
mysql>
mysql> show create table wp_options\G
*************************** 1. row *********************...
Table: wp_options
Create Table: CREATE TABLE `wp_options` (
`option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`option_name` varchar(191) COLLATE utf8mb4_unicode_520...
`option_value` longtext COLLATE utf8mb4_unicode_520_ci...
`autoload` varchar(20) COLLATE utf8mb4_unicode_520_ci ...
PRIMARY KEY (`option_id`),
UNIQUE KEY `option_name` (`option_name`),
KEY `autoload` (`autoload`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8m...
1 row in set (0.00 sec)
mysql>
mysql> select * from wp_options limit 5;
+-----------+--------------------+----------------------...
| option_id | option_name | option_value ...
+-----------+--------------------+----------------------...
| 1 | siteurl | http://192.168.0.38/w...
| 2 | home | http://192.168.0.38/w...
| 3 | blogname | mpiano ...
| 4 | blogdescription | Just another WordPres...
| 5 | users_can_register | 0 ...
+-----------+--------------------+----------------------...
5 rows in set (0.00 sec)
mysql>
mysql> select option_value from wp_options limit 5;
+-----------------------------+
| option_value |
+-----------------------------+
| http://192.168.0.38/wp |
| http://192.168.0.38/wp |
| mpiano |
| Just another WordPress site |
| 0 |
+-----------------------------+
5 rows in set (0.00 sec)
mysql>
mysql> select option_value from wp_options\G
*************************** 1. row *********************...
option_value: http://192.168.0.38/wp
*************************** 2. row *********************...
option_value: http://192.168.0.38/wp
*************************** 3. row *********************...
option_value: mpiano
*************************** 4. row *********************...
option_value: Just another WordPress site
*************************** 5. row *********************...
option_value: 0
mysql>
mysql> SELECT 10 * 8 + 4 FROM DUAL;
+------------+
| 10 * 8 + 4 |
+------------+
| 84 |
+------------+
1 row in set (0.00 sec)
mysql>
mysql> update wp_options set option_value='http://192.16...
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select option_value from wp_options limit 5;
+-----------------------------+
| option_value |
+-----------------------------+
| http://192.168.0.41/wp |
| http://192.168.0.38/wp |
| mpiano |
| Just another WordPress site |
| 0 |
+-----------------------------+
5 rows in set (0.00 sec)
mysql>
mysql> GRANT ALL ON *.* TO admin@localhost;
Query OK, 0 rows affected (0.02 sec)
mysql>
mysql> SHOW COLUMNS FROM articles;
+------------+---------------------+------+-----+-------...
| Field | Type | Null | Key | Defaul...
+------------+---------------------+------+-----+-------...
| id | bigint(20) unsigned | NO | PRI | NULL ...
| title | varchar(255) | NO | | NULL ...
| body | text | NO | | NULL ...
| created_at | timestamp | YES | | NULL ...
| updated_at | timestamp | YES | | NULL ...
+------------+---------------------+------+-----+-------...
5 rows in set (0.00 sec)
mysql>
終了行:
[[mysql]]
[[マニュアル:https://dev.mysql.com/doc/refman/5.6/ja/]]
[[【MySQL, SQL】データベースを扱う基本SQL一覧:https://qii...
[root@pc0700-vm wp]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 8.0.17 Source distribution
Copyright (c) 2000, 2019, Oracle and/or its affiliates. ...
Oracle is a registered trademark of Oracle Corporation a...
affiliates. Other names may be trademarks of their respe...
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the cu...
mysql>
mysql> select Host, User from mysql.user;
+-----------+------------------+
| Host | User |
+-----------+------------------+
| localhost | admin |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | phpmyadmin |
| localhost | redmine |
| localhost | root |
| localhost | wordpress |
+-----------+------------------+
8 rows in set (0.00 sec)
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| redmine |
| sys |
| wordpress |
+--------------------+
7 rows in set (0.00 sec)
mysql>
mysql> create database test;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| redmine |
| sys |
| test |
| wordpress |
+--------------------+
8 rows in set (0.00 sec)
mysql> use test;
Database changed
mysql> show tables;
Empty set (0.01 sec)
mysql>
mysql> create table test (
-> id int(10) unsigned NOT NULL AUTO_INCREMENT,
-> name varchar(64) NOT NULL,
-> address varchar(128) NOT NULL,
-> tel varchar(64) NOT NULL,
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected, 1 warning (0.03 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| test |
+----------------+
1 row in set (0.00 sec)
mysql> show create table test;
..
| test | CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`address` varchar(128) NOT NULL,
`tel` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_...
..
1 row in set (0.00 sec)
mysql> insert into test ( id, name, address, tel) values...
Query OK, 1 row affected (0.01 sec)
mysql> select * from test;
+----+----------+----------+------+
| id | name | address | tel |
+----+----------+----------+------+
| 1 | sekigawa | kanagawa | 0123 |
+----+----------+----------+------+
1 row in set (0.00 sec)
mysql>
mysql> use wordpress;
Reading table information for completion of table and co...
You can turn off this feature to get a quicker startup w...
Database changed
mysql>
mysql> select database();
+------------+
| database() |
+------------+
| wordpress |
+------------+
1 row in set (0.00 sec)
mysql>
mysql> show tables;
+-----------------------+
| Tables_in_wordpress |
+-----------------------+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
12 rows in set (0.00 sec)
mysql>
mysql> show create table wp_options\G
*************************** 1. row *********************...
Table: wp_options
Create Table: CREATE TABLE `wp_options` (
`option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`option_name` varchar(191) COLLATE utf8mb4_unicode_520...
`option_value` longtext COLLATE utf8mb4_unicode_520_ci...
`autoload` varchar(20) COLLATE utf8mb4_unicode_520_ci ...
PRIMARY KEY (`option_id`),
UNIQUE KEY `option_name` (`option_name`),
KEY `autoload` (`autoload`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8m...
1 row in set (0.00 sec)
mysql>
mysql> select * from wp_options limit 5;
+-----------+--------------------+----------------------...
| option_id | option_name | option_value ...
+-----------+--------------------+----------------------...
| 1 | siteurl | http://192.168.0.38/w...
| 2 | home | http://192.168.0.38/w...
| 3 | blogname | mpiano ...
| 4 | blogdescription | Just another WordPres...
| 5 | users_can_register | 0 ...
+-----------+--------------------+----------------------...
5 rows in set (0.00 sec)
mysql>
mysql> select option_value from wp_options limit 5;
+-----------------------------+
| option_value |
+-----------------------------+
| http://192.168.0.38/wp |
| http://192.168.0.38/wp |
| mpiano |
| Just another WordPress site |
| 0 |
+-----------------------------+
5 rows in set (0.00 sec)
mysql>
mysql> select option_value from wp_options\G
*************************** 1. row *********************...
option_value: http://192.168.0.38/wp
*************************** 2. row *********************...
option_value: http://192.168.0.38/wp
*************************** 3. row *********************...
option_value: mpiano
*************************** 4. row *********************...
option_value: Just another WordPress site
*************************** 5. row *********************...
option_value: 0
mysql>
mysql> SELECT 10 * 8 + 4 FROM DUAL;
+------------+
| 10 * 8 + 4 |
+------------+
| 84 |
+------------+
1 row in set (0.00 sec)
mysql>
mysql> update wp_options set option_value='http://192.16...
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select option_value from wp_options limit 5;
+-----------------------------+
| option_value |
+-----------------------------+
| http://192.168.0.41/wp |
| http://192.168.0.38/wp |
| mpiano |
| Just another WordPress site |
| 0 |
+-----------------------------+
5 rows in set (0.00 sec)
mysql>
mysql> GRANT ALL ON *.* TO admin@localhost;
Query OK, 0 rows affected (0.02 sec)
mysql>
mysql> SHOW COLUMNS FROM articles;
+------------+---------------------+------+-----+-------...
| Field | Type | Null | Key | Defaul...
+------------+---------------------+------+-----+-------...
| id | bigint(20) unsigned | NO | PRI | NULL ...
| title | varchar(255) | NO | | NULL ...
| body | text | NO | | NULL ...
| created_at | timestamp | YES | | NULL ...
| updated_at | timestamp | YES | | NULL ...
+------------+---------------------+------+-----+-------...
5 rows in set (0.00 sec)
mysql>
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
