求一正则表达式解析sql语句

[echoxue]

如何用正则表达式，把上面的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;

[EnForGrass]

不知所谓，

[devmiao]

“上面的sql语句”在哪里？天花板上？

[echoxue]

sorry，

sql语句如下
insert into contract(ContractName,ContractRole,CtUpdate)
values("echo2","admin",now());

update contract set ContractName='echo3',ContractRole='Web master1',CtUpdate=now(),
update=now();
where `Id`=2;

delete from contract where id=2

[echoxue]

[Quote=引用 1 楼 的回复:]

不知所谓，
[/Quote]

http://topic.csdn.net/u/20120802/18/c7cef8a1-4e91-4661-90f5-f245865138ed.html?seed=1056889195&r=79305858#r_79305858

再看看，谢谢了！！

[echoxue]

有人看看吗？