微客导航 » 文章资讯 » MySQL查询删除列记录中除最后7个字符外的所有内容

MySQL查询删除列记录中除最后7个字符外的所有内容

2024-05-17 21:59:06 384

让我们首先创建一个表-

create table DemoTable
(
   Strength text
);

使用插入命令在表中插入一些记录-

insert into DemoTable values('John is a good programmer');
insert into DemoTable values('Chris is a good player in cricket');
insert into DemoTable values('Bob is good in algorithm');

使用select语句显示表中的所有记录-

select *from DemoTable

这将产生以下输出-

+-----------------------------------+
| Strength                          |
+-----------------------------------+
| John is a good programmer         |
| Chris is a good player in cricket |
| Bob is good in algorithm          |
+-----------------------------------+
3 rows in set (0.00 sec)

以下是删除列记录中最后7个字符以外的所有内容的查询-

update DemoTable set Strength=substr(Strength,-7,7);
Rows matched: 3 Changed: 3 Warnings: 0

让我们再次检查表记录-

select *from DemoTable;

这将产生以下输出-

+----------+
| Strength |
+----------+
| grammer  |
| cricket  |
| gorithm  |
+----------+
3 rows in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

MySQL查询删除列记录中除最后7个字符外的所有内容

热门推荐

随机推荐