Answers for "convert mysql column type"

SQL
6

alter table column change data type to text mysql

ALTER TABLE tablename MODIFY columnname INTEGER;
Posted by: Guest on September-12-2020
1

mysql text to decimal

SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName
Posted by: Guest on August-11-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language