Linux下Mysql数据库的基本使用
2023-09-14 09:15:42 时间
Linux下Mysql数据库的基本使用
一、Mysql的delete删除语法
1.删除数据库
①使用drop删除
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| huawei |
| information_schema |
| mysql |
| performance_schema |
| sys |
| zabbix |
+--------------------+
6 rows in set (0.00 sec)
mysql> drop database huawei;
Query OK, 1 row affected (0.10 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| zabbix |
+--------------------+
5 rows in set (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
2.删除数据库的表
①使用drop语法
mysql> show tables;
+------------------+
| Tables_in_zabbix |
+------------------+
| student |
+------------------+
1 row in set (0.00 sec)
mysql> drop table student;
Query OK, 0 rows affected (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
Empty set (0.00 sec)
二、查询数据
语法:select _column,_column from _table [where Clause] [limit N][offset M]
1.基本查询
select * from 表名
mysql> select * from fruits;
+------+------+------------+---------+
| f_id | s_id | f_name | f_price |
+------+------+------------+---------+
| a1 | 101 | apple | 5.20 |
| b1 | 101 | blackberry | 10.20 |
| bs1 | 102 | orange | 11.20 |
| bs2 | 105 | melon | 7.20 |
| t1 | 102 | banana | 10.30 |
+------+------+------------+---------+
5 rows in set (0.00 sec)
mysql> select s_id from fruits;
+------+
| s_id |
+------+
| 101 |
| 101 |
| 102 |
| 105 |
| 102 |
+------+
5 rows in set (0.00 sec)
2.条件查询
mysql> select s_id,f_name,f_price from fruits where f_price <=7;
+------+--------+---------+
| s_id | f_name | f_price |
+------+--------+---------+
| 101 | apple | 5.20 |
+------+--------+---------+
1 row in set (0.00 sec)
三、数据库插入数据
1.创建新表
create table fruits ( f_id char(10) not null, s_id int not null, f_name char(255) not null, f_price decimal(8,2) not null, primary key(f_id) );
2.插入数据
mysql> insert into fruits(f_id,s_id,f_name,f_price) values ('bs2',105,'melon','7.2') ;
Query OK, 1 row affected (0.00 sec)
mysql> insert into fruits(f_id,s_id,f_name,f_price) values ('t1',102,'banana','10.3') ;
Query OK, 1 row affected (0.05 sec)
mysql> select * from fruits;
+------+------+------------+---------+
| f_id | s_id | f_name | f_price |
+------+------+------------+---------+
| a1 | 101 | apple | 5.20 |
| b1 | 101 | blackberry | 10.20 |
| bs1 | 102 | orange | 11.20 |
| bs2 | 105 | melon | 7.20 |
| t1 | 102 | banana | 10.30 |
+------+------+------------+---------+
5 rows in set (0.00 sec)
四、修改数据库表内容
mysql> select * from fruits;
+------+------+------------+---------+
| f_id | s_id | f_name | f_price |
+------+------+------------+---------+
| a1 | 101 | apple | 5.20 |
| b1 | 101 | blackberry | 10.20 |
| bs1 | 102 | orange | 11.20 |
| bs2 | 105 | melon | 7.20 |
| t1 | 102 | banana | 10.30 |
+------+------+------------+---------+
5 rows in set (0.00 sec)
mysql> UPDATE fruits SET f_price='8.5' WHERE f_id='a1';
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from fruits;
+------+------+------------+---------+
| f_id | s_id | f_name | f_price |
+------+------+------------+---------+
| a1 | 101 | apple | 8.50 |
| b1 | 101 | blackberry | 10.20 |
| bs1 | 102 | orange | 11.20 |
| bs2 | 105 | melon | 7.20 |
| t1 | 102 | banana | 10.30 |
+------+------+------------+---------+
5 rows in set (0.00 sec)
相关文章
- Linux 命令行实现文件重命名(linux命令重命名)
- Linux系统查找字符串的方法(linux查找字符串)
- MySQL 合并:一种合理的数据库设计策略(mysql合并)
- 掌握MySQL状态查看方法,轻松搞定数据库状态(mysql状态查看)
- MySQL中插入自增数据的简洁方法(mysql插入自增数据)
- 如何查看MySQL数据库的密码(如何查看mysql的密码)
- 管理用Linux进行MySQL远程管理(linux远程mysql)
- MySQL:连接数据库的最佳实践 (mysql的数据库连接)
- MySQL数据库初始化指南(mysql数据库初始化)
- Linux服务器构建路由网关实现网络连接(linux服务器做网关)
- 展示Linux各种变体之美(linux的分支)
- 通过 MySQL 二级考试,踏上职业发展之路(mysql二级考试)
- Linux下线程实现机制及其应用(linux线程实现机制)
- 探索Linux网络:最全面的PDF资源汇总(linux网络pdf)
- CSV文件如何快速导入MySQL数据库?(csv怎么导入mysql)
- 深入了解:如何通过MySQL查看等待状态?(mysql查看等待)
- 探索 Linux 下的进程管理(进程linux)
- Explaining MySQL: Understanding the Popular Open Source Database System(mysql解释)
- MySQL 更新日志:记录数据库变更和修复信息的必备工具(mysql更新日志)
- Mysql数据库:记录创建时刻(mysql数据库创建时间)
- MySQL数据库:架起智慧信息大桥(费mysql数据库)
- 中国 搭建CND服务器连接MySQL数据库(cnd链接mysql)
- MySQL读写锁实现安全多用户并发操作(c mysql读写锁)
- C程序与MySQL处理日期的实现(c mysql 日期)
- MySQL异常1242错误解析(mysql中1242)
- 使用CMD命令行登录MySQL数据库(cmd里登录mysql)
- C语言与MySQL数据库的连接实现(c l与mysql连接)
- MySQL一直是个经典的数据库选择(mysql 一直使用)
- MySQL数据库是什么(mysql_db是什么)
- MySQL数据丢失小心误删误关数据库(mysql不小心关)
- 2018年MySQL下载指南轻松获取最新版MySQL数据库(mysql下载2018)