/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

2 votes214 views1 answer
Sql create database
SQL
4 votes232 views1 answer
Postgresql list sequences
SQL
0 vote209 views1 answer
Limiting query result using where in sql
SQL
2 votes220 views1 answer
Oracle calculated column
SQL
0 vote207 views2 answers
Drop check constraint in ms sql
SQL
2 votes254 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
1 vote221 views1 answer
Postgresql escape single quote
SQL
0 vote216 views2 answers
Sql drop view if exists
SQL
0 vote202 views1 answer
Oracle drop default value
SQL
0 vote216 views1 answer
Opening xampp mysql in cmd ubuntu
SQL

Share