/SQL/String to int mysql

String to int mysql

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

7 votes101 views1 answer
Alter sequence set current value oracle
SQL
0 vote90 views2 answers
Android sqlite query join
SQL
6 votes125 views2 answers
Mysql timestamp to date
SQL
0 vote109 views1 answer
Copy data from one postgres container to another
SQL
0 vote110 views1 answer
Delete ids between sql
SQL
-1 vote109 views2 answers
First letter capital in mysql query
SQL
5 votes140 views1 answer
Oracle ora-00054 find
SQL
9 votes103 views3 answers
Sql delete where in
SQL
11 votes103 views2 answers
Having keyword sql
SQL
1 vote110 views2 answers
Reset mysqli fetch_arra
SQL

Share