CODEWITHSUNDEEP
mysqlsql
D.P D.P
D.P D.P

Reputation: 1

Change type column

how in mysql, i can change the range of DECIMAL in already created table

CREATE TABLE Confectionery (
Price DECIMAL(20),
DateOfMaking DATE
);

I want to change it to: DECIMAL (5,2)

Upvotes: 0

Views: 43

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133360

for mysql you could try

ALTER TABLE tablename MODIFY Price DECIMAL (5,2);

Upvotes: 1

Related Questions