which way is better- one or two tables?
Posted by: Simon Hiaubeng
Date: October 03, 2022 01:28AM

There are a number of html files, which have tables I am to process. My application codes are to read a file, get the tables, and append the information to a table in MySQL. Problem is that some html files have EoF error, and some miss a couple tables.

I have created a MySQL table that has columns for filenames, primary_key, and 'is_good'. It looks like

filename_table
pk INT % autogenerated
filename VARCHAR(45)
is_good TINYINT % default 1: good
error_comment VARCHAR(180) % default null

And whenever a bad file is encountered, the 'is_good' is updated to be 0, and 'error_comment' are updated with some error message.

Or is it better to create a new table to store the error information and use foreign key to relate it to the filename_talbe? There shouldn't be many 'bad' html files in the source.

Options: ReplyQuote


Subject
Written By
Posted
which way is better- one or two tables?
October 03, 2022 01:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.