Why are decimals dropped when inserted into Mysql table?

[mdc101 15]

HI guys

I'm doing a simple insert into a database table from a ubot table using table cells.

In the ubot table I see 13.2 as an example.

Using set the insert statement is generated as seen two lines down.

When I run the insert into mySql table the decimal is dropped and the value is rounded down to 13.

#inset_record: INSERT INTO sometable
(
sometable.profileid,
sometable.theme_keywords,
sometable.ID,
sometable.Flag,
sometable.kwSource,
sometable.LARI,
sometable.PPC_CostclickMonthly,
sometable.PPC_clickMonthly,
sometable.TrafficForecast,
sometable.CompetingPages
)
VALUES
(
'5060',
'dysfunction',
'0000',
'xxxxxx',
'xxxxxxxx',
'100',
'13,2',
'12643,995',
'71769,96',
'13500000'
)

All decimals are being dropped.

Why is this happening?

The table in mysql is set to double.

 

Any help will be appreciated.

[mdc101 15]

OK figured this one out

When you create the insert statement you must wrap the number with the FORMAT function

 

example

 

FORMAT(column_name,2)