Answers for "get backup from database with empty tables"

SQL
3

create a table with an id in mysql

CREATE TABLE DemoT (
    Personid int NOT NULL AUTO_INCREMENT,
    LastName varchar(111) NOT NULL,
    FirstName varchar(111),
    Age int,
    PRIMARY KEY (Personid)
);
Posted by: Guest on April-27-2020
0

compare list from db and list from request

List<String> compareObjects(PartInfo filePart, PartInfo dbPart) {
    List<String> different = new LinkedList<String>();

    if (!filePart.getNumber().equals(dbPart.getNumber())) {
        different.add("number");
    }
    //repeat for all your fields
    return different;
}


#Note: Check differences for each field ob each object from 2 list only
Posted by: Guest on May-07-2020

Code answers related to "get backup from database with empty tables"

Code answers related to "SQL"

Browse Popular Code Answers by Language