输入密码进入mysql
(base) [root@compc700 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.7.35 MySQL Community Server (GPL)
退出 mysql> 命令提示窗口可以使用 exit 命令,如下所示:
mysql> exit
Bye
一、创建数据库
创建数据库,数据名为 INSURANCE:
mysql> create database INSURANCE;
查看该数据库是否已经在库中:
mysql> show databases;
选定数据库:
mysql> use INSURANCE;
查看当前使用的数据库:
mysql> select database();
+------------+
| database() |
+------------+
| INSURANCE |
+------------+
1 row in set (0.00 sec)
二、创建表
创建一个名为test的表:
mysql> create table test(vin text not null,batch text not null, s_time datetime not null,e_time datetime not null,model_code text not null,model_values text not null,c_time datetime not null,data_count bigint not null,comment text not null);
查看是否存在表:
mysql> show tables;
+------------------------+
| Tables_in_INSURANCE |
+------------------------+
| test |
+------------------------+
1 row in set (0.00 sec)
查看表结构:
mysql> desc test;
+--------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+-------+
| vin | text | NO | | NULL | |
| batch | text | NO | | NULL | |
| s_time | datetime | NO | | NULL | |
| e_time | datetime | NO | | NULL | |
| model_code | text | NO | | NULL | |
| model_values | text | NO | | NULL | |
| c_time | datetime | NO | | NULL | |
| data_count | bigint(20) | NO | | NULL | |
| comment | text | NO | | NULL | |
+--------------+------------+------+-----+---------+-------+
9 rows in set (0.00 sec)
将数据存入表后,可以通过以下语句查看数据表里的数据:
mysql>select * from test;
三、删除
如果要删除数据库INSURANCE:
mysql>drop database INSURANCE;
删除表test;
mysql> drop table test;