/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

1 vote132 views1 answer
Mariadb alter user host
SQL
0 vote128 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote126 views1 answer
Convert sql server guid to varbinary
SQL
2 votes151 views1 answer
Sql OR
SQL
0 vote139 views1 answer
Insert using condition postgres
SQL
0 vote130 views1 answer
Mysql url
SQL
0 vote128 views1 answer
Sql count * vs count 1
SQL
8 votes131 views1 answer
Oracle add auto_increment column to existing table
SQL
4 votes137 views2 answers
Postgresql default value
SQL
0 vote127 views1 answer
Select in select sql
SQL

Share