/SQL/Mysql parse int

Mysql parse int

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 vote380 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote389 views5 answers
What is in operator in sql
SQL
0 vote378 views1 answer
Dbms_output sql developer
SQL
1 vote320 views1 answer
Unique vs distinct sql
SQL
5 votes345 views1 answer
Migrate sql table another database
SQL
0 vote402 views1 answer
Sql int vs integer
SQL
1 vote413 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote410 views1 answer
Update top 100 order by sql server
SQL
0 vote364 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote333 views1 answer
How to count null values in sql
SQL

Share