求一正则表达式解析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语句”在哪里?天花板上?