数据库插入数据，修改数据，删除数据

插入数据

插入单项

insert into table(branch_name,balance,account_number)
    values('Perriridge',1200,'A-9732')

插入多项

insert into account
    select loan_number,branch_name,200
    from loan
    where branch_name='Perryridge'

修改表项

update account
set balance=balance*0.05
where balance>10000

遇到条件语句

update account
set balance = case
                 when balance<=10000 then balance*1.05
                 else balance*1.06
              end

删除表项

delete from table

delete from table
where branch_name='Perryridge'