/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 vote140 views1 answer
Oracle sql winter time change
SQL
0 vote136 views2 answers
Find Overlapping sql
SQL
0 vote158 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
26 votes142 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote160 views1 answer
Default
SQL
2 votes150 views3 answers
Sql truncate table
SQL
6 votes170 views1 answer
To count number of rows in SQL table
SQL
0 vote141 views2 answers
Tsql row number
SQL
10 votes144 views1 answer
User_dependencies
SQL
0 vote152 views1 answer
Nosql vs sql
SQL

Share