V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
CUPAIR

求助:正则获取 sql 语句中的表名

  •  
  •   CUPAIR · Dec 29, 2022 via Android · 1645 views
    This topic created in 1225 days ago, the information mentioned may be changed or developed.
    * 取出所有在 from 和 join 后面的表名

    * 表名有单词字母.和_

    * 目前写法:`const fromTable = lowerSql.match(new RegExp('\\b(from)\\b[\\s\\S]*?\\s+([\\w._]+)\\', "gi")) || []`

    但 safari 不兼容零宽断言
    wsWmsw
        1
    wsWmsw  
       Jan 19, 2023 via Android
    Safari 兼容前瞻不兼容后瞻断言吧
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   5829 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 47ms · UTC 02:42 · PVG 10:42 · LAX 19:42 · JFK 22:42
    ♥ Do have faith in what you're doing.