/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

10 votes139 views2 answers
Oracle alter sequence nextval
SQL
0 vote146 views1 answer
Oracle concat datetime
SQL
0 vote140 views1 answer
Use between operator in mysql
SQL
0 vote142 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote144 views1 answer
Oracle string substitution
SQL
19 votes137 views4 answers
Rename database in sql
SQL
0 vote171 views1 answer
Php insert null mysql
SQL
6 votes139 views1 answer
Sqlite foreign key
SQL
0 vote147 views1 answer
Mssql last day of month
SQL
0 vote140 views1 answer
Mysql terminal list table
SQL

Share