×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

mysql show all columns

0
0
 
0
Language: SQL
Posted by: Jorge Alcalá
Added: Dec 28, 2018 4:04 PM
Modified: Dec 28, 2018 4:05 PM
Views: 3614
Tags: mysql
  1. SELECT * FROM information_schema.columns
  2. WHERE table_schema = 'invent'
  3. AND column_name LIKE 'claprov%'

Write a comment

To post comments, please log in or register.