/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 vote150 views1 answer
Import excel to sql
SQL
0 vote100 views1 answer
Como leer datos de mysql esp32
SQL
0 vote138 views1 answer
Postgres enumerated type
SQL
0 vote142 views1 answer
Hive batch drop table
SQL
0 vote146 views2 answers
Connect to mysql server mac terminal
SQL
11 votes142 views2 answers
Having in sql
SQL
0 vote153 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote139 views1 answer
How to write if case in select query in select statement
SQL
2 votes97 views1 answer
Sql group by different columns
SQL
0 vote131 views1 answer
Mariadb LOAD DATA INFILE
SQL

Share