5,838
edits
MX on Linux: Difference between revisions
m
→Populating your database tables on your Pi
| Line 637: | Line 637: | ||
#if the table name is defined in the admin interface, and the table already exists in the database with the correct columns defined, then the executable will use that table. | #if the table name is defined in the admin interface, and the table already exists in the database with the correct columns defined, then the executable will use that table. | ||
#There is an optional second parameter that specifies the log file name to read. | #There is an optional second parameter that specifies the log file name to read. | ||
#*if the second parameter is not specified, this executable will look at every log file (in "data" folder and with file name that starts with month, then has "log.txt", | #*if the second parameter is not specified, this executable will look at every log file (in "data" folder and with file name that starts with month, then has "log.txt"), | ||
# for each line in the log file the executable will try to insert a row in the database table | # for each line in the log file the executable will try to insert a row in the database table | ||
#*the SQL syntax used is "insert ignore", so if the row for that log file line already exists in the table, it will skip onto next line of log file. | #*the SQL syntax used is "insert ignore", so if the row for that log file line already exists in the table, it will skip onto next line of log file. | ||