擅长:python、mysql、java
<p>使用python2.7测试以下各项:</p>
<pre><code>>>> table_string = """
... CREATE TABLE 'dhcpr_dhcprelayinterface' (
... 'vrId' integer default 0,
... 'ifName' string ,
... PRIMARY KEY(ifName,vrId),
... FOREIGN KEY (vrId) REFERENCES 'vr_vr'(vrId) ON DELETE CASCADE ON UPDATE CASCAD
E);"""
>>> p = r'CREATE TABLE\s+\'([^\']+)[\s\S]+PRIMARY KEY\(([^,]+),([^\)]+)\)'
>>> re.findall(p,table_string)
[('dhcpr_dhcprelayinterface', 'ifName', 'vrId')]
</code></pre>
<p>解释可以在<a href="https://regex101.com/r/nJ7yW3/1" rel="nofollow">here.</a></p>