/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

0 vote385 views4 answers
Open mysql port bitnami tomact
SQL
0 vote362 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote362 views1 answer
Oracle apex version view
SQL
0 vote374 views1 answer
Postgresql linux password
SQL
7 votes356 views3 answers
Sql fill table with info from anothe rtable
SQL
32 votes372 views6 answers
Sql count where
SQL
0 vote357 views1 answer
TSQL convert csv to table
SQL
0 vote331 views1 answer
What does the -p flag do in mysql cli
SQL
4 votes383 views1 answer
Sql select limit range
SQL
1 vote354 views1 answer
How to drop function in sql
SQL

Share