一、建表语句
create table test_payment(
year varchar(10),
month varchar(10),
day varchar(10),
hour varchar(10),
product_code varchar(30),
money varchar(20)
);
CREATE TABLE test_payment_two (
paytime varchar(20) NULL,
product_code varchar(30) NULL,
money varchar(20) NULL
);
CREATE TABLE test_payment_three (
paytime varchar(20) NULL,
product_code varchar(30) NULL,
money varchar(20) NULL
);
create table test_payment_four(
paytime date,
product_code varchar(30),
money varchar(20)
);
create table test_payment_five(
paytime date,
product_code varchar(30),
money varchar(20)
);
insert into test_payment values('2019','1','3','12','M2202','89');
insert into test_payment values('2019','2','4','13','M2201','90');
insert into test_payment values('2019','3','5','14','M2201','91');
insert into test_payment values('2019','4','3','12','M2202','89');
insert into test_payment values('2019','5','4','13','M2201','90');
insert into test_payment values('2