在MySQL中批量更改特定字段的所有条目?

在MySQL中批量更改特定字段的所有条目?

让我们先创建一个演示表 –

mysql> create table BulkChangeDemo
     -> (
     -> CustomerId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
     -> CustomerName varchar(20),
     -> isEducated boolean
     -> );
Query OK, 0 rows affected (1.47 sec)

使用insert命令在表中插入一些记录。该查询如下 –

mysql> insert into BulkChangeDemo(CustomerName,isEducated) values('Larry',true);
Query OK, 1 row affected (0.09 sec)
mysql> insert into BulkChangeDemo(CustomerName,isEducated) values('John',false);
Query OK, 1 row affected (0.16 sec)
mysql> insert into BulkChangeDemo(CustomerName,isEducated) values('Carol',false);
Query OK, 1 row affected (0.25 sec)
mysql> insert into BulkChangeDemo(CustomerName,isEducated) values('Mike',true);
Query OK, 1 row affected (0.18 sec)
mysql> insert into BulkChangeDemo(CustomerName,isEducated) values('David',false);
Query OK, 1 row affected (0.13 sec)
mysql> insert into BulkChangeDemo(CustomerName,isEducated) values('Bob',false);
Query OK, 1 row affected (0.10 sec)

使用select语句显示表中的所有记录。查询如下 –

mysql> select *from BulkChangeDemo;

这是输出 –

+------------+--------------+------------+
| CustomerId | CustomerName | isEducated |
+------------+--------------+------------+
| 1          | Larry        | 1          |
| 2          | John         | 0          |
| 3          | Carol        | 0          |
| 4          | Mike         | 1          |
| 5          | David        | 0          |
| 6          | Bob          | 0          |
+------------+--------------+------------+
6 rows in set (0.00 sec)

下面是批量更改特定字段的所有条目的查询 –

mysql> update BulkChangeDemo set isEducated =true;
Query OK, 4 rows affected (0.18 sec)
Rows matched: 6 Changed: 4 Warnings: 0

阅读更多:MySQL 教程

Python教程

Java教程

Web教程

数据库教程

图形图像教程

大数据教程

开发工具教程

计算机教程

MySQL 教程