About Table creation

Question

what will happen if we give float type rather than integer?
it will accept but memory wastage ha ?

Answer 1

It depends on your scenario. If you want to store decimal floating point number, you should go with float. If you need integers, than use INT.

Answer 2

yeah you required float vales into the table than u insert float. otherwise int.