/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 vote104 views1 answer
How to get last client id sql
SQL
0 vote160 views1 answer
Drush run sql select
SQL
0 vote185 views1 answer
Openquery update linked server
SQL
16 votes203 views4 answers
Find duplicates mysql
SQL
2 votes154 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
1 vote186 views1 answer
Postgres select as csv
SQL
0 vote146 views2 answers
How to update date in oracle
SQL
0 vote145 views1 answer
Sql server get date of previous sunday
SQL
0 vote165 views1 answer
How to inner join 4 tables in sql
SQL
0 vote156 views1 answer
Reona
SQL

Share