编辑代码

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

        INSERT INTO person
        VALUES (1, 'Bob', 'Beijing', 'lisigebi', 'Norway');
        INSERT INTO person
        VALUES (2, 'Alice', 'ShangHai', 'zhangsangebi', 'Norway');
        Insert into person
        values (3,'Ma','HongWei','TongJiYiYuan','WuHan');

        SELECT *
        FROM person;