Define A Float

[Andrea]

I am trying to define a float(10,6) as datatype but I cannot do that from the GUI.

How am I supposed to do that?

Thanks

Andrea

[Shalmali]

Hello Andrea,

In the Create New Table/ Alter Table window, in the length column, we can add precision.

Please take a look at the screen shot.

-Shalmali

[Shalmali]

Oops, here is the screen shot.

[peterlaursen]

An advice: consider using a DECIMAL type instead because of this

http://www.webyog.com/faq/conteant/29/162/en/tables-with-floating-point-datatypes-fail-to-update.html

If you need to use FLOAT/DOUBLE type (because the numbers are 'astronomical' or 'microscopical') then always have a Primary Key on the table defined on non-floating columns.

This FAQ should help you operating the GUI (it also applies to FLOATS with specified precision):

http://www.webyog.com/faq/content/29/90/en/how-do-i-control-the-parameters-of-decimal-data-types-with-sqlyog.html

.. you specify the parameters in the 'length' column.

[Author]

Posts