/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 vote169 views1 answer
How to order result of subquery in select
SQL
25 votes179 views6 answers
Import mysql database command line
SQL
0 vote165 views1 answer
Postgres select except
SQL
1 vote202 views1 answer
Postgresql append array
SQL
1 vote193 views1 answer
Sql how to replace full stop
SQL
1 vote183 views1 answer
What is int in mysql
SQL
0 vote192 views2 answers
Temp Space
SQL
0 vote175 views1 answer
How to install postgresql on wsl
SQL
0 vote182 views1 answer
Vbscript connect mssql
SQL
0 vote186 views3 answers
How to assign custom id in mysql
SQL

Share