Regular Expressions 101

Community Patterns

MySQL : table structure info

0

Regular Expression
PCRE2 (PHP >=7.3)

/
^(\w+)\s+(\w+)(\(\d*\))?.*$
/
gm

Description

MySQL : table structure parser

mysql command : SHOW COLUMNS FROM edn_work_order_event

Submitted by dobri - 2 years ago