/SQL/Mysql cast to varchar

Mysql cast to varchar

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 vote334 views1 answer
Sql examples from framework
SQL
1 vote332 views1 answer
Moodle query item quiz
SQL
0 vote318 views1 answer
Recover deleted data from mysql database
SQL
0 vote346 views1 answer
Shortcut run sql pgadmin
SQL
0 vote302 views1 answer
Strat with in sql
SQL
0 vote320 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote366 views1 answer
Dataframe lambda elif
SQL
3 votes338 views2 answers
Sql server current date without time
SQL
0 vote352 views1 answer
Sql server user permissions and roles
SQL
0 vote314 views1 answer
Order by monthly in sql
SQL

Share