/SQL/Mysql parse int

Mysql parse int

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 vote166 views1 answer
Postgresql parse json array
SQL
0 vote196 views1 answer
Sql select sum group by id laravel join
SQL
2 votes244 views1 answer
Create mysql user on all hosts
SQL
0 vote157 views1 answer
CREATE MULTIPLE FK
SQL
0 vote188 views1 answer
Sql cmd no truncate
SQL
0 vote187 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote196 views1 answer
Hour differeence in mysql
SQL
0 vote168 views1 answer
Mysql workbench format date
SQL
0 vote168 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
1 vote137 views1 answer
Database run
SQL

Share