/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 vote257 views1 answer
Sql period overlap
SQL
0 vote253 views1 answer
Sql alter table order by
SQL
0 vote236 views2 answers
Sql select inside select
SQL
2 votes248 views1 answer
Check isolation level in mysql
SQL
24 votes274 views6 answers
Alter table name sql
SQL
0 vote268 views1 answer
Mysql sum per week
SQL
-1 vote275 views4 answers
Sql view postgresql
SQL
0 vote280 views1 answer
Oracle winter time change
SQL
2 votes264 views1 answer
How to get non distinct values in sql
SQL
0 vote262 views1 answer
How to do a function to return row type from a table in pl/sql
SQL

Share