mdc101 15 Posted July 15, 2014 Report Share Posted July 15, 2014 HI guysI'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. Quote Link to post Share on other sites
mdc101 15 Posted July 15, 2014 Author Report Share Posted July 15, 2014 OK figured this one outWhen you create the insert statement you must wrap the number with the FORMAT function example FORMAT(column_name,2) Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.