MySQL 테이블 정의서 조회 쿼리

SELECT
IFNULL(T2.TABLE_COMMENT, T1.TABLE_NAME) AS TABLE_COMMENT
, T1.TABLE_NAME, T1.ORDINAL_POSITION, T1.COLUMN_COMMENT
, T1.COLUMN_NAME, UPPER(T1.DATA_TYPE) AS DATA_TYPE
, (CASE T1.DATA_TYPE WHEN 'varchar' THEN T1.CHARACTER_MAXIMUM_LENGTH ELSE '' END) AS DATA_LENGTH
, (CASE T1.IS_NULLABLE WHEN 'NO' THEN 'Y' ELSE '' END) AS NOT_NULL
, (CASE T1.COLUMN_KEY WHEN 'PRI' THEN 'Y' ELSE '' END) AS IS_PK
, T1.COLUMN_DEFAULT

FROM (
    SELECT
    *
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_SCHEMA = 'dbzimyung'
    AND TABLE_NAME LIKE 'm_%'
    ORDER BY TABLE_NAME ASC, ORDINAL_POSITION ASC
) T1
INNER JOIN (
    SELECT
    TABLE_NAME, TABLE_COMMENT
    FROM `INFORMATION_SCHEMA`.`TABLES`
    WHERE TABLE_NAME LIKE 'm_%'
) T2 ON T2.TABLE_NAME = T1.TABLE_NAME

MySQL schema query with comment

Table

SELECT * FROM `INFORMATION_SCHEMA`.`TABLES`
WHERE TABLE_NAME LIKE 'm_%'


Column

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'dbname'
AND TABLE_NAME LIKE 'T_%'
ORDER BY TABLE_NAME ASC, ORDINAL_POSITION ASC

MySQL "The server time zone value ‘KST’ is unrecognized or represents more than one time zone" error

MySQL JDBC로 접속시 아래와 같은 에러가 발생할 경우 처리

The server time zone value ‘KST’ is unrecognized or represents more than one time zone

원인 
mysql-connector-java 버전 6.x 이후 버전부터는 KST 타임존을 인식하지 못하는 것으로 판단됨

해결방안1
mysql-connector-java 5.x 버전 이용 (ex. mysql-connector-java-5.1.47)

apache tomcat jre requirements

http://tomcat.apache.org/whichversion.html

이클립스 버전별 JRE 요구사항

출처: https://wiki.eclipse.org/Eclipse/Installation

4.7 (Oxygen)
Java 8

4.6 (Neon)
Java 8

4.5 (Mars)
Java 7

4.4 (Luna)
Java 7

4.3 (Kepler)
Java 6

FreeBSD + openjdk8 + eclipse

# vi .cshrc
setenv  LANG ko_KR.UTF-8
setenv  LC_ALL ko_KR.UTF-8

# pkg install gnome-desktop gdm xorg xf86-video-fbdev

# vi /etc/rc.conf
gnome_enable="YES"
moused_enable="YES"
dbus_enable="YES"
hald_enable="YES"

<reboot>


# pkg install security/sudo
# visudo
alice ALL=(ALL) ALL


https://www.digitalocean.com/community/tutorials/how-to-install-and-manage-ports-on-freebsd-10-1
# sudo portsnap fetch extract
# sudo portsnap fetch update

# sudo make config fetch checksum depends extract patch configure build install

# cd /usr/ports/java && ls -d openjdk*
# sudo portmaster java/openjdk8

# pkg search openjdk
# sudo pkg install openjdk8

# pkg search eclipse
# sudo pkg install eclipse-4.5.1

아파치 에러(mod_passenger unixd_config) 처리

에러내용
$ /etc/apache2# service apache2 start
 * Starting web server apache2                                                                                  *
 * The apache2 configtest failed.
Output of config test was:
apache2: Syntax error on line 140 of /etc/apache2/apache2.conf: Syntax error on line 1 of /etc/apache2/mods-enabled/passenger.load: Cannot load /var/lib/gems/1.8/gems/passenger-4.0.46/buildout/apache2/mod_passenger.so into server: /var/lib/gems/1.8/gems/passenger-4.0.46/buildout/apache2/mod_passenger.so: undefined symbol: unixd_config
Action 'configtest' failed.
The Apache error log may have more information.

원인
Apache 2.4에서 unixd_config 이름이 ap_unixd_config 로 변경됨

해결방안
아래 바이너러를 설치하고 아파치 실행
$ apt-get install libapache2-mod-passenger

또는
./bin/passenger-install-apache2-module로 모듈 재컴파일