/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

-1 vote213 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote206 views1 answer
Mysql strict_trans_tables
SQL
1 vote176 views1 answer
PLS-00225 type
SQL
2 votes209 views1 answer
Sql server find columns list in tables
SQL
0 vote142 views1 answer
Ms sql print more than 1 variable
SQL
4 votes211 views3 answers
Postgres set default value
SQL
0 vote196 views1 answer
Mssql disable foreign key constraint
SQL
0 vote171 views1 answer
Jooq finding lastest value in table
SQL
0 vote203 views1 answer
Compare if is null sql
SQL
1 vote201 views1 answer
Mysql take number in string
SQL

Share