/SQL/String to int mysql

String to int mysql

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

0 vote171 views1 answer
Csv to sqlite python
SQL
0 vote170 views1 answer
Sql clear table
SQL
1 vote170 views1 answer
Jooq convert using gbk
SQL
0 vote172 views1 answer
Sqlite closes value
SQL
0 vote180 views1 answer
Sql server remove 0 from left
SQL
0 vote135 views2 answers
Sql query unique
SQL
1 vote187 views1 answer
Tsql get beginning of year
SQL
4 votes174 views2 answers
Tsql utf to local time
SQL
31 votes186 views3 answers
SQL Server change column data type
SQL
0 vote171 views1 answer
Oracle query archive mode
SQL

Share