target_db : 새롭게 생성될 테이블이 존재하는 테이터베이스target_table_name : 새롭게 생성될 테이블 이름  source_db : 복사할 원본 테이블이 존재하는 테이터베이스source_table_name : 복사할 원본.
Topics: 테이블 복사, MySQL

{"title":"\ud14c\uc774\ube14 \ubcf5\uc0ac","post_url":"http:\/\/spaceufo.wordpress.com\/2008\/11\/23\/%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%b3%b5%ec%82%ac\/","feed_url":"http:\/\/spaceufo.wordpress.com\/feed\/","author":"spaceufo","date":"2008-11-23 23:35:49","summary":" target_db : \uc0c8\ub86d\uac8c \uc0dd\uc131\ub420 \ud14c\uc774\ube14\uc774 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ud130\ubca0\uc774\uc2a4target_table_name : \uc0c8\ub86d\uac8c \uc0dd\uc131\ub420 \ud14c\uc774\ube14 \uc774\ub984  source_db : \ubcf5\uc0ac\ud560 \uc6d0\ubcf8 \ud14c\uc774\ube14\uc774 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ud130\ubca0\uc774\uc2a4source_table_name : \ubcf5\uc0ac\ud560 \uc6d0\ubcf8."}

From : http://ajaxian.com/archives/groups-of-50-ajax-examplesNoupe keeps the roundups going with Most Wanted Ajax Techniques: 50+ Examples and Tutorials that consists of a lot of projects we have covered over time, but some new ones, and the added touch..
Topics: ajax, java, jQuery

{"title":"Most Wanted Ajax Techniques","post_url":"http:\/\/spaceufo.wordpress.com\/2008\/11\/04\/most-wanted-ajax-techniques\/","feed_url":"http:\/\/spaceufo.wordpress.com\/feed\/","author":"spaceufo","date":"2008-11-04 01:02:41","summary":"From : http:\/\/ajaxian.com\/archives\/groups-of-50-ajax-examplesNoupe keeps the roundups going with Most Wanted Ajax Techniques: 50+ Examples and Tutorials that consists of a lot of projects we have covered over time, but some new ones, and the added touch.."}

 Error code 1: 명령이 허용되지 않음 Error code 2: 그런 파일이나 디렉토리가 없음 Error code 3: 그런 프로세스가 없음 Error code 4: 중단된 시스템 호출 Error code 5: 입력/출력 오류 Error...
Topics: MySQL

{"title":"Mysql - ErrCode","post_url":"http:\/\/spaceufo.wordpress.com\/2008\/10\/11\/mysql-errcode\/","feed_url":"http:\/\/spaceufo.wordpress.com\/feed\/","author":"spaceufo","date":"2008-10-11 14:19:30","summary":" Error code 1: \uba85\ub839\uc774 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\uc74c Error code 2: \uadf8\ub7f0 \ud30c\uc77c\uc774\ub098 \ub514\ub809\ud1a0\ub9ac\uac00 \uc5c6\uc74c Error code 3: \uadf8\ub7f0 \ud504\ub85c\uc138\uc2a4\uac00 \uc5c6\uc74c Error code 4: \uc911\ub2e8\ub41c \uc2dc\uc2a4\ud15c \ud638\ucd9c Error code 5: \uc785\ub825\/\ucd9c\ub825 \uc624\ub958 Error..."}

날자와 시간을 표시할 때 보통 3가지 방법timestamp : 내부적으로는 int, 표시만 날자와 시간, 4byte datetime : 날자와 시간형식으로 입력, 표시, 8byte int : unix_timestamp를 저장,...
Topics: 날짜, 시간, MySQL, timestamp

{"title":"\ub0a0\uc790\uc640 \uc2dc\uac04\uc744 \ud45c\uc2dc\ud558\ub294 \ud544\ub4dc\uc5d0 \uad00\ud55c \uba54\ubaa8","post_url":"http:\/\/spaceufo.wordpress.com\/2008\/09\/17\/%eb%82%a0%ec%9e%90%ec%99%80-%ec%8b%9c%ea%b0%84%ec%9d%84-%ed%91%9c%ec%8b%9c%ed%95%98%eb%8a%94-%ed%95%84%eb%93%9c%ec%97%90-%ea%b4%80%ed%95%9c-%eb%a9%94%eb%aa%a8\/","feed_url":"http:\/\/spaceufo.wordpress.com\/feed\/","author":"spaceufo","date":"2008-09-17 08:03:43","summary":"\ub0a0\uc790\uc640 \uc2dc\uac04\uc744 \ud45c\uc2dc\ud560 \ub54c \ubcf4\ud1b5 3\uac00\uc9c0 \ubc29\ubc95timestamp : \ub0b4\ubd80\uc801\uc73c\ub85c\ub294 int, \ud45c\uc2dc\ub9cc \ub0a0\uc790\uc640 \uc2dc\uac04, 4byte datetime : \ub0a0\uc790\uc640 \uc2dc\uac04\ud615\uc2dd\uc73c\ub85c \uc785\ub825, \ud45c\uc2dc, 8byte int : unix_timestamp\ub97c \uc800\uc7a5,..."}

가능한한 NOT NULL로 컬럼을 선언한다. 속도가 빨라지며 각 컬럼마다 1 비트를 절약할 수 있다.default 값을 가질 때 유리하다.입력되는 값이 기본값과 다를 때만 확실하게 값이 입력된다.INSERT...
Topics: ajax, MySQL, server, table

{"title":"\ud14c\uc774\ube14\uc744 \ube60\ub974\uace0 \uc791\uac8c \ubc30\uc5f4\ud558\ub294 \ubc29\ubc95 (\ud14c\uc774\ube14 \ucd5c\uc801\ud654)","post_url":"http:\/\/spaceufo.wordpress.com\/2008\/08\/08\/%ed%85%8c%ec%9d%b4%eb%b8%94%ec%9d%84-%eb%b9%a0%eb%a5%b4%ea%b3%a0-%ec%9e%91%ea%b2%8c-%eb%b0%b0%ec%97%b4%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%b5%9c%ec%a0%81%ed%99%94\/","feed_url":"http:\/\/spaceufo.wordpress.com\/feed\/","author":"spaceufo","date":"2008-08-08 07:20:19","summary":"\uac00\ub2a5\ud55c\ud55c NOT NULL\ub85c \uceec\ub7fc\uc744 \uc120\uc5b8\ud55c\ub2e4. \uc18d\ub3c4\uac00 \ube68\ub77c\uc9c0\uba70 \uac01 \uceec\ub7fc\ub9c8\ub2e4 1 \ube44\ud2b8\ub97c \uc808\uc57d\ud560 \uc218 \uc788\ub2e4.default \uac12\uc744 \uac00\uc9c8 \ub54c \uc720\ub9ac\ud558\ub2e4.\uc785\ub825\ub418\ub294 \uac12\uc774 \uae30\ubcf8\uac12\uacfc \ub2e4\ub97c \ub54c\ub9cc \ud655\uc2e4\ud558\uac8c \uac12\uc774 \uc785\ub825\ub41c\ub2e4.INSERT..."}