/SQL/Mysql cast to varchar

Mysql cast to varchar

Mysql parse int

SELECT CAST(PROD_CODE AS INT) FROM PRODUCT

0

Mysql cast to varchar

SELECT CAST(aField as UNSIGNED) from table; 
-- for VARCHAR use CHAR(50), INT use UNSIGNED

0

Similar codes

3 votes348 views2 answers
How to View column names of a table in SQL
SQL
0 vote358 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote351 views1 answer
Components/Fields of Internal Table
SQL
0 vote371 views1 answer
Show the colums of table sql
SQL
0 vote390 views3 answers
Select top 10 rows in sql
SQL
0 vote408 views3 answers
Mysql CAST(amount as float)
SQL
6 votes370 views2 answers
Drop foreign key
SQL
2 votes392 views2 answers
How to add not null constraint in sql
SQL
0 vote355 views1 answer
Can't connect to postgresql mac os
SQL
4 votes429 views4 answers
Check constraint in ms sql
SQL

Share