/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

28 votes109 views6 answers
Mysql change user password
SQL
4 votes102 views1 answer
Mysql set max connections
SQL
2 votes66 views1 answer
Sql float to int
SQL
0 vote109 views1 answer
Oracle string length
SQL
0 vote115 views2 answers
Plsql function that return a table
SQL
0 vote111 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote163 views1 answer
Postgres dump sql insert
SQL
0 vote105 views1 answer
How to find sql server installation folder
SQL
1 vote100 views1 answer
Oracle finding duplicate records
SQL
16 votes103 views1 answer
Sqlserver add column to table
SQL

Share