/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

1 vote106 views2 answers
Login to mysql
SQL
0 vote120 views1 answer
Sql decimal to 2 places
SQL
0 vote102 views1 answer
Find all tables where column name exists oracle
SQL
0 vote108 views1 answer
.sql File Run in PSQL
SQL
0 vote104 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote88 views1 answer
Select value from previous row in postgresql
SQL
0 vote120 views1 answer
Kill mysqld_safe process mariadb
SQL
3 votes92 views2 answers
Find string in stored procedure sql server
SQL
0 vote103 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote135 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL

Share