/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 vote284 views1 answer
Redshift running queries
SQL
1 vote230 views1 answer
Sql server epoch to datetime
SQL
1 vote244 views1 answer
Quit mysql
SQL
0 vote218 views1 answer
Sql get guid
SQL
0 vote254 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
2 votes207 views3 answers
Mysql cheat sheet
SQL
5 votes244 views4 answers
Start postgres server
SQL
6 votes280 views3 answers
Check if string contains substring sql
SQL
0 vote209 views1 answer
Sql min
SQL
0 vote243 views1 answer
Drop-toys-table
SQL

Share