Decimals in Enums MySQL/PHP

[anser316]

Hi in a table i want just one number (6.25) that i want added to all rows. e.g.

 

ID  cust_num

1      6.25

2      6.25

3      6.25

 

I would like it as the default value if it is not inserted also.

I was thinking ENUM('6.25') NOT NULL

I have some issues though with this

Can I do sums with ENUM on php or mysql?

e.g. $row2[total_quantity]*$row[cust_num]

And if so do i need quotes as it will be like a float or decimal?

 

[fenway]

ENUM? What are you thinking? What do you mean "added to all rows"?

[aschk]

If you're dealing with money where the calculations need to be penny perfect, then use NUMERIC. And if you want to specify a DEFAULT field value, then give your table a default column value.

"ENUM", i mean ??? were you thinking...

ALTER TABLE <table name here> MODIFY COLUMN cast_num NUMERIC(6,2) NOT NULL DEFAULT 6.25