/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 vote296 views4 answers
Stored procedure sql
SQL
3 votes164 views2 answers
Postgres download
SQL
1 vote170 views1 answer
Right outer vs left outer join
SQL
1 vote228 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote164 views2 answers
Clear window pl sql
SQL
0 vote188 views1 answer
View psql output in horizontal scrolling
SQL
0 vote272 views1 answer
SQL query to verify the size of the table
SQL
0 vote196 views1 answer
Hour differeence in mysql
SQL
11 votes177 views2 answers
Having in sql
SQL
1 vote141 views2 answers
Delete auto increment mysql
SQL

Share