/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

0 vote75 views1 answer
Mysql sleep connections
SQL
0 vote109 views1 answer
Distinct data types in a table sql query
SQL
8 votes144 views1 answer
My sql version
SQL
1 vote113 views1 answer
Oracle db create new schema
SQL
2 votes125 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
2 votes117 views1 answer
Oracle virtual column
SQL
11 votes116 views1 answer
Mysql text type max length
SQL
-1 vote114 views2 answers
Postgres autoincrement primary key
SQL
3 votes114 views1 answer
Oracle rollback
SQL
1 vote113 views1 answer
Oracle get current schema
SQL

Share