将 int 转换为 varchar

2021-11-20 00:00:00 sql database casting mariadb mysql

我有以下查询,需要将 id 转换为 varchar

I have below query and need to cast id to varchar

架构

create table t9 (id int, name varchar (55));
insert into t9( id, name)values(2, 'bob');

我尝试了什么

select CAST(id as VARCHAR(50)) as col1 from t9;

select CONVERT(VARCHAR(50),id) as colI1 from t9;

但它们不起作用.请提出建议.

but they don't work. Please suggest.

推荐答案

您需要castconvert 作为 CHAR 数据类型,没有可以将数据转换/转换为的 varchar 数据类型:

You will need to cast or convert as a CHAR datatype, there is no varchar datatype that you can cast/convert data to:

select CAST(id as CHAR(50)) as col1 
from t9;

select CONVERT(id, CHAR(50)) as colI1 
from t9;

在 SQL Fiddle 上查看以下 SQL — 实际操作:

See the following SQL — in action — over at SQL Fiddle:

/*! Build Schema */
create table t9 (id INT, name VARCHAR(55));
insert into t9 (id, name) values (2, 'bob');

/*! SQL Queries */
select CAST(id as CHAR(50)) as col1 from t9;
select CONVERT(id, CHAR(50)) as colI1 from t9;

除了您尝试转换为不正确的数据类型这一事实之外,您用于 convert 的语法也不正确.convert 函数使用以下内容,其中 expr 是您的列或值:

Besides the fact that you were trying to convert to an incorrect datatype, the syntax that you were using for convert was incorrect. The convert function uses the following where expr is your column or value:

 CONVERT(expr,type)

 CONVERT(expr USING transcoding_name)

您的原始查询的语法向后.

Your original query had the syntax backwards.

相关文章