centos7 安裝mysql
[root@localhost ~]# yum -y install mariadb mariadb-server
啟動mysql
[root@localhost ~]# systemctl start mariadb
[root@localhost ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.65-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
mysql基礎操作
- centos7 安裝mysql
- 啟動mysql
- 創建一個資料庫
- 創建一個UTF8的資料庫
- 查看所有庫
- 洗掉資料庫
- 創建表 表的三種型別:innodb,myisam,memory
- 查看表結構
- 洗掉表
- 常規操作：增
- 常規操作：刪
- 常規操作：改
- 常規操作：查
創建一個資料庫
MariaDB [(none)]> create database ku;
Query OK, 1 row affected (0.00 sec)
創建一個UTF8的資料庫
MariaDB [(none)]> create database ku1 character set utf8 collate utf8_bin;
Query OK, 1 row affected (0.00 sec)
查看所有庫
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| ku |
| ku1 |
| mysql |
| performance_schema |
| test |
+--------------------+
6 rows in set (0.00 sec)
洗掉資料庫
MariaDB [(none)]> drop database ku;
Query OK, 0 rows affected (0.00 sec)
創建表 表的三種型別:innodb,myisam,memory
先進入一個資料庫
MariaDB [(none)]> use ku1;
Database changed
MariaDB [ku1]> create table test1(id int(10),name varchar(10)) engine=mylsam;
Query OK, 0 rows affected, 2 warnings (0.00 sec)
MariaDB [ku1]> create table test2(id int(10),name varchar(10)) engine=innodb;
Query OK, 0 rows affected (0.00 sec)
MariaDB [ku1]> create table test3(id int(10),name varchar(10)) engine=memory;
Query OK, 0 rows affected (0.00 sec)
查看表結構
MariaDB [ku1]> desc test2;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(10) | YES | | NULL | |
| name | varchar(10) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
洗掉表
MariaDB [ku1]> drop table test1;
Query OK, 0 rows affected (0.00 sec)
常規操作：增
MariaDB [ku1]> insert into test2 values(1,"小紅花");
Query OK, 1 row affected (0.00 sec)
MariaDB [ku1]> insert into test2 values(2,"小綠花");
Query OK, 1 row affected (0.00 sec)
常規操作：刪
洗掉表的全部資料：
MariaDB [ku1]> delete from test2;
Query OK, 1 row affected (0.00 sec)
常規操作：改
MariaDB [ku1]> update test2 set name="小黃花" where name="小紅花";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
常規操作：查
查看整張表的資料:
MariaDB [ku1]> select * from test2;
+------+-----------+
| id | name |
+------+-----------+
| 1 | 小黃花 |
| 2 | 小綠花 |
+------+-----------+
2 rows in set (0.00 sec)
指定id來查看:
MariaDB [ku1]> select * from test2 where id=2;
+------+-----------+
| id | name |
+------+-----------+
| 2 | 小綠花 |
+------+-----------+
1 row in set (0.00 sec)
指定name來查看:
MariaDB [ku1]> select * from test2 where name="小黃花";
+------+-----------+
| id | name |
+------+-----------+
| 1 | 小黃花 |
+------+-----------+
1 row in set (0.00 sec)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/197020.html
標籤：java
上一篇：Mysql獲取最新記錄