/SQL/String to int mysql

String to int mysql

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

22 votes353 views4 answers
Mysql date_format
SQL
0 vote328 views1 answer
Mysql coonect sample code
SQL
-1 vote338 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
2 votes323 views1 answer
Postgresql transaction
SQL
3 votes308 views1 answer
What is having clause
SQL
0 vote317 views1 answer
Get created time of database psql 8
SQL
0 vote323 views1 answer
We are intrested to work with your organization
SQL
0 vote346 views1 answer
Query by column for substring sql
SQL
5 votes322 views4 answers
Sql check
SQL
7 votes347 views3 answers
Convert ansi sql
SQL

Share