/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 vote165 views4 answers
Restart MySQL
SQL
0 vote224 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
10 votes176 views2 answers
SQL rounding numbers
SQL
3 votes177 views1 answer
Sql multi column index performance
SQL
6 votes219 views2 answers
WHERE value IS sql
SQL
0 vote181 views1 answer
Postgresql custom order by
SQL
0 vote166 views1 answer
Doesn't have default value mysql
SQL
1 vote174 views1 answer
Increase existing date in sql
SQL
2 votes228 views2 answers
Create table mysql integer NOT null
SQL
0 vote200 views1 answer
Openquery update linked server
SQL

Share