/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

3 votes107 views3 answers
Mysql select table names
SQL
0 vote113 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
2 votes56 views1 answer
Mysql admin u root p password change password
SQL
2 votes120 views1 answer
Sql server current date minus 5 years
SQL
0 vote108 views1 answer
Oracle webcenter content search enginer
SQL
0 vote103 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote108 views1 answer
Mysql in clausule string array
SQL
5 votes171 views2 answers
Mysql date greater than 30 days
SQL
0 vote111 views2 answers
Python mysql create table if not exists
SQL
0 vote103 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL

Share