We have say a item that goes through multiple tests and over a day we have say 100 items.
I want to have a row in a table for each item under column date, Id, testA, testB, testC, comment.
Most of the time the data will be; date, “incremented number”, pass, pass, pass, none.
The user would then select to say enter 100 records. If everything passed that day no further action is required. If one or two items failed that day he could select that item by the id and amend a test to fail and enter the comment.
After the insert query what is the method to duplicate the rows or entry ‘x’ number of times ?
To save NULLS in the comments sections what is the best thing to enter for later on to perform a query on any item has a comment. Use 0 and query against greater then. Or use ‘none’ and a query against does not equal none?
It’s a MySQL database.