sql.txt

做太久,忘了什么功能了!好象取款机的功能..冒似...

select * from cardInfo
select * from userInfo
select * from transInfo

delete  from cardInfo where cardID = '1010 3576 5555 8888'
truncate table userInfo

insert cardInfo (cardID,openDate,openMoney,balance,pass)values ('1010 3576 5555 8888','2007-12-15 12:15:36',38.00,38.00,'159875')