/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

3 votes173 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote150 views1 answer
Select only one row sql
SQL
3 votes178 views2 answers
How to force truncate a table in mysql
SQL
2 votes155 views1 answer
Mysql add boolean column
SQL
3 votes200 views2 answers
How to View column names of a table in SQL
SQL
0 vote152 views1 answer
Php delete database
SQL
0 vote220 views1 answer
Mysql collation portugues brasil
SQL
4 votes156 views1 answer
Oracle select first 10 rows
SQL
0 vote203 views1 answer
Mysql extract day from date leading zero
SQL
0 vote143 views1 answer
Find how many table doesn't contain column in mysql
SQL

Share