C:\xampp\mysql\bin> mysql -u root -p    //mysqlのあるディレクトリ内で実行

MariaDB [(none)]>　                  //このようになればOK
MariaDB [(none)]> exit               //mysqlから切断

MariaDB [(none)]> status;
//いろんな情報が出てきます()

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| example            |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+

MariaDB [(none)]> create database データベース名;
MariaDB [(none)]> show databases;

MariaDB [(none)]> create database test2;
Query OK, 1 row affected (0.002 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| example            |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
| test2              | //追加されていれば成功
+--------------------+

MariaDB [(none)]> use データベース名;

MariaDB [(none)]> use test2;
Database changed
MariaDB [test2]>  //[]のなかが変更されていれば成功 

MariaDB [test2]> create table テーブル名(
-> テーブルのフィールド情報を入力
->);

MariaDB [test2]> show tables;
MariaDB [test2]> describe テーブル名;

MariaDB [test2]> create table students(
-> id int,
-> first_name varchar(60),
-> last_name varchar(60) //最後に「,」は不要
->);

MariaDB [test2]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| students       |
+----------------+

MariaDB [test2]> describe students;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id         | int(11)     | YES  |     | NULL    |       |
| first_name | varchar(60) | YES  |     | NULL    |       |
| last_name  | varchar(60) | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+

MariaDB [test2]> insert into テーブル名 values
    -> ('フィールド1の要素','フィールド2の要素','フィールド3の要素');

MariaDB [test2]> select * from テーブル名;

MariaDB [test2]> insert into students values
    -> ('1','hogehoge','pugepuge');

MariaDB [test2]> select * from students;
+------+------------+-----------+
| id   | first_name | last_name |
+------+------------+-----------+
|    1 | hogehoge   | pugepuge  |
+------+------------+-----------+

MariaDB [test2]> select * from テーブル名 limit 範囲指定;

MariaDB [test2]> select * from students;
+------+------------+-----------+
| id   | first_name | last_name |
+------+------------+-----------+
|    1 | user1      | pugepuge  |
|    2 | qqqq       | pppp      |
|    3 | bbb        | aaaa      |
+------+------------+-----------+
3 rows in set (0.000 sec)

MariaDB [test]> select * from students limit 0,1;
+------+------------+-----------+
| id   | first_name | last_name |
+------+------------+-----------+
|    1 | user1      | pugepuge  |
+------+------------+-----------+

MariaDB [test2]> delete from テーブル名;

MariaDB [test2]> delete from user;
Query OK, 1 row affected (0.004 sec)

//確認してみる
MariaDB [test2]> select * from students;
Empty set (0.000 sec)　// emptyとなっていれば成功

MariaDB [test2]> delete from テーブル名 where テーブルの要素 = 消したいとこ;

MariaDB [test2]> delete from students where id = 1;
MariaDB [test2]> select * from students;
Empty set (0.000 sec)　// emptyとなっていれば成功

MariaDB [test2]> select * from students;
//現在の状態
+------+------------+-----------+
| id   | first_name | last_name |
+------+------------+-----------+
|    1 | hogehoge   | pugepuge  |
+------+------------+-----------+
//変更
MariaDB [test2]> update テーブル名 set 変更したいテーブルのフィールド名=変更後の名前 where 変更したいテーブルのフィールド名=そのまま入力;

MariaDB [test2]> update students set first_name='test' where last_name='pugepuge';
Query OK, 1 row affected (0.004 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [test2]> select * from students;
+------+------------+-----------+
| id   | first_name | last_name |
+------+------------+-----------+
|    1 | test       | pugepuge  |
+------+------------+-----------+
1 row in set (0.002 sec)