制作工资表并修改数据的命令

不会写啊，哪位大神教教我！！！！！！！！！！！！！！！！！！！！！！！！！

表结构提供一下。

create table wage
(
id bigint primary key not null,
name varchar(20) not null,
base_pay float(5) not null,
merit_pay float(5) not null,
add_pay float(5) not null,
sj_salary float(5) not null,
date datetime not null,
card char(19) not null
);

insert into wage (id,name,base_pay,merit_pay,add_pay,sj_salary,date,card) values(1,'张三','2500','160','200','2860',now(),'6217003850011428958');

insert into wage (id,name,base_pay,merit_pay,add_pay,sj_salary,date,card) values(2,'李四','2500','150','200','2850',now(),'6217003850011428960');

insert into wage (id,name,base_pay,merit_pay,add_pay,sj_salary,date,card) values(3,'王五','2500','180','200','2880',now(),'6217003850011428962');

insert into wage (id,name,base_pay,merit_pay,add_pay,sj_salary,date,card) values(4,'陆六','2500','170','200','2870',now(),'6217003850011428964');