/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

3 votes302 views1 answer
Oracle apex warn on unsaved changes
SQL
4 votes318 views4 answers
What is primary key
SQL
0 vote297 views1 answer
Sub query in linq
SQL
0 vote310 views2 answers
How do I install microsoft SQL on my Mac?
SQL
4 votes326 views1 answer
Conda install sqlalchemy
SQL
0 vote303 views1 answer
Mysql query problems and solutions
SQL
0 vote293 views1 answer
Mysqldump don't drop table
SQL
0 vote337 views1 answer
Table structure in sql
SQL
1 vote345 views1 answer
Encrypt password postgresql
SQL
0 vote310 views1 answer
Mysql undo delete
SQL

Share