编辑代码

-- create database test;
-- use test;
create table egg_record (
    id INT AUTO_INCREMENT PRIMARY KEY,
    egg_name VARCHAR(10) NOT NULL,
    sold DATE NULL
);
-- insert into 数据库名.表格名
insert into test.egg_record (id, egg_name, sold) 
values(1, '鸡蛋', '2020-01-01')