/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

4 votes135 views2 answers
Float postgres
SQL
1 vote121 views1 answer
Delete specific row in sql
SQL
16 votes124 views1 answer
Sql comment'
SQL
7 votes114 views3 answers
Sql update where id
SQL
0 vote115 views1 answer
Mysql random number between 1 and 100
SQL
0 vote102 views1 answer
Oracle select partition
SQL
1 vote129 views1 answer
Importance of comment in mysql
SQL
0 vote110 views1 answer
Mysql select distinct date from timestamp
SQL
3 votes121 views2 answers
Sql server current date without time
SQL
1 vote118 views2 answers
Login to mysql
SQL

Share