/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

0 vote373 views1 answer
Close sql query vb.net
SQL
1 vote317 views2 answers
Delete auto increment mysql
SQL
1 vote351 views1 answer
Create procedure with encryption
SQL
25 votes375 views5 answers
Date in mysql
SQL
1 vote348 views1 answer
Minus vs intersect in sql
SQL
1 vote368 views1 answer
Sql server epoch to datetime
SQL
0 vote398 views1 answer
Oracle list datafiles
SQL
0 vote373 views1 answer
Get initials name in sql
SQL
17 votes360 views6 answers
Get last record in sql
SQL
0 vote355 views1 answer
Sql comand for removing data from table
SQL

Share