price decimal(10,2)
The (8,2) data type definition for a DECIMAL column in MySQL refers to:

8 = Total digits in the number (including before and after decimal point)
2 = Digits after the decimal point
So in this case:

The column can store numbers with a TOTAL of 8 digits
Of those 8 digits, 2 will be after the decimal point
Leaving 6 digits before the decimal point
Some examples of values that would fit:

23.45
123.12
987.65
But these would be too large:

1234.56 ( exceeds 8 total digits )
1023.456 ( exceeds 2 decimal places )
The (p,d) format allows you to define the precision needed for currency or measurements to avoid floating point rounding errors.

So DECIMAL(8,2) in MySQL declares a fixed 8 digit number with 2 digits reserved for the fractional portion, perfect for monetary values stored in cents.

select *, 'Please fix it'  from category Where cat_name='';

select *,'Please fix it' from product where prod_name='';

select *,'Please fix it' from pkg_master where pkg_name='';

select *,'Please fix it' from pkg_detail where pkg_desc='';


