/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 vote144 views1 answer
My sql data file extention
SQL
57 votes336 views5 answers
How to create a new user in postgresql
SQL
12 votes144 views1 answer
How to change the value of a table in sql
SQL
0 vote124 views1 answer
Alter boolean column postgresql
SQL
5 votes147 views2 answers
Get number of columns sql
SQL
2 votes154 views1 answer
Sql string_agg
SQL
0 vote145 views1 answer
Mysql grant grant option
SQL
104 votes354 views2 answers
Like in mysql
SQL
3 votes142 views1 answer
Mysql UPDate with enner join
SQL
0 vote134 views1 answer
Check if a word appears at the end sql query
SQL

Share