이응기역

select * from TABLES where table_name like '%ABC%'

* 에러가 나는 경우

SELECT 1 FROM

(SELECT 1);

* 조치 : subquery 에 alias 를 붙인다

SELECT 1 FROM

(SELECT 1) AS FOO --   <-- AS ... 

;

http://download.cnet.com/Vim/3055-2352_4-10525454.html?tag=pdl-redir

http://sourceforge.net/projects/cream/files/

http://www.baremetalsoft.com/baretail/index.php

http://sourceforge.net/projects/tailforwin32/

http://stackoverflow.com/questions/187587/looking-for-a-windows-equivalent-of-the-unix-tail-command

조인(join) 순서를 지시하는 힌트(hint)

보기:

SELECT /*+ LEADING(e2 e1) USE_NL(e1) INDEX(e1 emp_emp_id_pk) 
           USE_MERGE(j) FULL(j) */
    e1.first_name, e1.last_name, j.job_id, sum(e2.salary) total_sal
  FROM employees e1, employees e2, job_history j
  WHERE e1.employee_id = e2.manager_id
    AND e1.employee_id = j.employee_id
    AND e1.hire_date = j.start_date
  GROUP BY e1.first_name, e1.last_name, j.job_id
  ORDER BY total_sal;

http://docs.oracle.com/cd/B19306_01/server.102/b14211/hintsref.htm

아래 글도 참고

http://www.dbguide.net/db.db?mobile&cmd=view&boardUid=148222&boardConfigUid=9&categoryUid=216&boardIdx=140&boardStep=1

http://www.dbguide.net/db.db?cmd=view&boardUid=148218&boardConfigUid=9&categoryUid=216&boardIdx=139&boardStep=1

* query 실행 : CTRL + ENTER

* 주석 : --

해결 방법: (오른쪽 마우스) 관리자로 실행

jpg, gif 등만 올릴 수 있는 제한 풀기

$wgFileExtensions = array('png','gif','jpg','jpeg','doc','xls','mpp','pdf','ppt','tiff','bmp','docx', 'xlsx', 'pptx','ps','odt','ods','odp','odg');

(http://www.mediawiki.org/wiki/Manual:Configuring_file_uploads)

php.ini

upload_max_filesize  값 변경