/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 vote174 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
6 votes144 views2 answers
Oracle trigger
SQL
1 vote187 views1 answer
Add time to date sql
SQL
0 vote173 views1 answer
Get initials name in sql
SQL
0 vote139 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote146 views1 answer
Oracle procedure teamplate
SQL
0 vote123 views1 answer
Sub blocks in sql
SQL
0 vote145 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote159 views1 answer
Mysql dump with table query
SQL
0 vote162 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL

Share