Mysql. Find Tables With Specific Field_name

Reading time ~1 minute

Нужно анйти все таблицы содержащие поля с определенным именем.

SELECT DISTINCT concat(TABLE_SCHEMA,'.',TABLE_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%server%'

Вывод

+---------------------------------------------+
| concat(TABLE_SCHEMA,'.',TABLE_NAME)         |
+---------------------------------------------+
| database1.accounts                          |
| database2.servers                           |
+---------------------------------------------+
Read More

Solve Screen Error Cannot Open Your Terminal /dev/pts/0 - Please Check

При попытке открытия терминала screen можно получить ошибку```Cannot open your terminal '/dev/pts/0' - please check.```Это бывает когда п...… Continue reading

How to Install GoLang 1.5 on Ubuntu

Published on April 29, 2016

Dpkg Error Processing Package Libapache2-mpm-itk

Published on April 06, 2016