/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

9 votes318 views5 answers
Sql limit
SQL
0 vote334 views1 answer
T sql dynamic top n query
SQL
2 votes363 views1 answer
Postgresql group by month and year
SQL
0 vote324 views1 answer
Find usage of table in sql server
SQL
1 vote306 views1 answer
Tsql random number
SQL
0 vote310 views2 answers
How to update the multiple rows in sql
SQL
1 vote292 views2 answers
How to drop a unique constraint in sql
SQL
4 votes354 views3 answers
Sql find second highest salary employee
SQL
0 vote319 views1 answer
Get sum sqlite android
SQL
1 vote373 views1 answer
Sql select row with max date
SQL

Share