Sunday, 22 November 2020

Database changes

 In order to add a new table by the "CREATE TABLE" in create.sql, you need to remove the existing data directory and create a new with the same name. To be sure, run docker-compose build too

Render HTML in NodeJS

https://vegibit.com/render-html-in-node-js/

MySQL Data Type DECIMAL issue:

DECIMAL(19,9) has 9 digits for the fractional part and 19-9 = 10 digits for integer part

Replaced REAL with DECIMAL because of small fractional digits (eg. 1201.2200000345)

No comments:

Post a Comment