select zjm from xskh where guid_yw='e6ee44f3-98ab-4446-bd9b-db2e525d3b24' and zjm not like '%[ABCDEFGHIJKLMNOPQRSTUVWXYZ]%'--不包含a-z字母 select * from xskh where (ISNUMERIC(aname_long)=1 or isnull(aname_long,'')='')--ISNUMERIC 函数是判断该字段的值是否为数字是=1不是=0 ,但
python 获取 mac 地址 的例子,有需要的朋友可以参考下. #!/bin/python import os import re def GetMac(): if os.name == 'nt': try: ret = '' CmdLine = 'ipconfig /all' r = os.popen(CmdLine).read() if r: