/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

15 votes328 views6 answers
Drop foreign key mysql
SQL
0 vote311 views1 answer
Strat with in sql
SQL
2 votes361 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote321 views1 answer
Sqlite select split string
SQL
0 vote321 views1 answer
Myswql show full processlist
SQL
0 vote327 views1 answer
Oracle search columns in schema
SQL
1 vote341 views2 answers
Mysql show views
SQL
3 votes314 views1 answer
Sql several or
SQL
1 vote350 views1 answer
Oracle drop job if exists
SQL
0 vote360 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL

Share