编辑代码

CREATE TABLE person
                 (
                     id         int,
                     last_name  varchar(255),
                     first_name varchar(255),
                     address    varchar(255),
                     city       varchar(255),
                     status     int
                 );

        INSERT INTO person
        VALUES (1, 'Bob', 'Beijing', 'lisigebi', 'Norway',3);
        INSERT INTO person
        VALUES (1, 'Alice', 'ShangHai', 'zhangsangebi', 'Norway',1);

        SELECT * FROM person where status>1;