/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

2 votes206 views1 answer
How to delete all duplicate items in mysql
SQL
5 votes201 views1 answer
Find table from column name in sql
SQL
2 votes197 views1 answer
Sql as
SQL
0 vote185 views1 answer
Why mysql is used?
SQL
12 votes195 views3 answers
Install sqlite driver ubuntu
SQL
2 votes182 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
3 votes212 views2 answers
Order by postgresql
SQL
0 vote210 views1 answer
Sql tabelle erstellen
SQL
0 vote200 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote200 views1 answer
Get schema of table sql
SQL

Share