alter table printInvoiceConfig alter column toussegroupconfig varchar(4000); update InvoiceItem set isPrint = '是' where invoice_id in ( select id from Invoice where isPrint = '是' ) and ( isPrint = '否' or isPrint is null );