/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

13 votes125 views4 answers
What is sql
SQL
2 votes98 views1 answer
Latest record in sql
SQL
2 votes140 views2 answers
Sqlalchemy return id after insert
SQL
1 vote143 views1 answer
Mysql search like order by best match
SQL
0 vote122 views1 answer
How to connect pgadmin with excel
SQL
0 vote126 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote129 views1 answer
Hibernate show sql xml property
SQL
3 votes136 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote133 views1 answer
Oracle array
SQL
0 vote116 views1 answer
Insert thai language sql server
SQL

Share