SELECT * FROM `material` where transfer > "2022-04-01 00:00:00" and pgi='e'
UPDATE material set pgi=null where transfer > "2022-04-01 00:00:00" and pgi='e'
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
参考
https://blog.csdn.net/Olivia_Vang/article/details/100290032