在MySQL中给现有的 int 列添加字符?
要在现有的 int 列值中添加字符,请使用MySQL CONCAT()函数。 首先让我们创建一个表 –
mysql> create table DemoTable
(
Amount int
);
Query OK, 0 rows affected (1.44 sec)
使用插入命令将一些记录插入表中 –
mysql> insert into DemoTable values(709);
Query OK, 1 row affected (0.67 sec)
mysql> insert into DemoTable values(34560);
Query OK, 1 row affected (0.30 sec)
mysql> insert into DemoTable values(90854);
Query OK, 1 row affected (0.28 sec)
mysql> insert into DemoTable values(3456);
Query OK, 1 row affected (0.15 sec)
使用 select 语句从表中显示所有记录 –
mysql> select *from DemoTable;
这将产生以下输出 –
+--------+
| Amount |
+--------+
| 709 |
| 34560 |
| 90854 |
| 3456 |
+--------+
4 rows in set (0.00 sec)
以下是将字符添加到列值的查询 –
mysql> select concat('The Product Amount is=',Amount) AS AddingCharacters from DemoTable;
这将产生以下输出 –
+-----------------------------+
| AddingCharacters |
+-----------------------------+
| The Product Amount is=709 |
| The Product Amount is=34560 |
| The Product Amount is=90854 |
| The Product Amount is=3456 |
+-----------------------------+
4 rows in set (0.00 sec)
阅读更多:MySQL 教程