/SQL/Mysql parse int

Mysql parse int

String to int mysql

SELECT field,CONVERT(field,UNSIGNED INTEGER) AS num
FROM table;

1

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 votes190 views1 answer
Oracle index size calculation
SQL
0 vote187 views1 answer
Oracle for loop on list
SQL
36 votes204 views6 answers
Rename table sql
SQL
4 votes185 views1 answer
Datepart postgres
SQL
0 vote206 views1 answer
Oracle sql number to varchar2
SQL
1 vote200 views3 answers
Sql union
SQL
1 vote211 views2 answers
Begin transaction sql
SQL
1 vote250 views1 answer
Wherein mysql
SQL
1 vote293 views1 answer
Mysql is odd
SQL
1 vote280 views1 answer
Oracle select first row order by
SQL

Share