/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 vote126 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote145 views2 answers
Jsonb
SQL
0 vote148 views1 answer
Delete a record from a table sqlite3
SQL
0 vote123 views3 answers
Joins and views sql
SQL
14 votes201 views1 answer
How to export db from mysql
SQL
1 vote140 views1 answer
Display total number of tables in mysql
SQL
2 votes123 views1 answer
Oracle cpu per session
SQL
0 vote124 views2 answers
Mysql disable foreign key checks
SQL
4 votes165 views1 answer
Mysql query first character
SQL
7 votes123 views3 answers
Add primary key to database sql
SQL

Share