/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

2 votes321 views1 answer
Sql string_agg
SQL
0 vote306 views1 answer
Enable full text search mysql
SQL
9 votes326 views6 answers
Oracle substring
SQL
0 vote306 views1 answer
Oracle sql date winter time
SQL
0 vote311 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote359 views3 answers
Postgres trim string
SQL
21 votes322 views5 answers
Oracle all tables
SQL
0 vote308 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
2 votes334 views2 answers
Postgres timestamp to datetime
SQL
0 vote301 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL

Share