/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

23 votes327 views1 answer
How remove column in mysql
SQL
0 vote333 views1 answer
Connecting to my cloud sql server with c#
SQL
4 votes294 views1 answer
Mac install mysql
SQL
0 vote340 views1 answer
Flush user resource mysql
SQL
2 votes324 views1 answer
Get first 2 letter in sql
SQL
6 votes363 views2 answers
Subtr Oracle ?
SQL
0 vote336 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
11 votes314 views2 answers
Set default column value sql
SQL
0 vote355 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
6 votes351 views2 answers
Mysql concatenate two columns into one
SQL

Share