日期:2014-05-18  浏览次数:20889 次

求一正则表达式解析sql语句
如何用正则表达式,把上面的sql语句拆分成
1,insert
string tableName = contract
string fileds = ContractName,ContractRole,CtUpdate
string values="echo2","admin",now()

2, update
string tableName = contract
string fileds = ContractName,ContractRole,CtUpdate,update
string where = `Id`=2;

3, delete
 string tableName = contract
string where = `Id`=2;

------解决方案--------------------
不知所谓,
------解决方案--------------------
“上面的sql语句”在哪里?天花板上?