RedJini Blog
http://blog.redjini.com/
2024-03-19T21:15:30+09:00
Textcube 1.9.3 : poco a poco
[MySQL] Table Copy
나그네
http://blog.redjini.com/218
2014-01-02T12:58:43+09:00
2008-11-10T17:39:44+09:00
테이블 스키마 복사 CREATE TABLE table_new LIKE table_old; 테이블 데이타 복사 INSERT table_new SELECT * FROM table_old;
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/218">글 전체보기</a></strong></p>
[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기
나그네
http://blog.redjini.com/197
2014-01-02T12:57:50+09:00
2008-07-08T15:26:22+09:00
EUC-KR로 작성된 웹페이지에서 MySQL 5.0 기본 설정으로 사용할경우 한글깨짐 현상 DB Character Set을 euckr로 설정하고 사용할경우 "똠, 샾"등과 같은 단어 입력시 해당 단어 이후의 단어들이 Insert가 되지 않는 문제가 생김. DB Character Set을 utf8로 설정하고 euckr을 Insert할경우 MySQL Front등에서 한글이 깨저 보임. 조치 방법 1. my.cnf 수정 [mysqld] init_conn...
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/197">글 전체보기</a></strong></p>
[MySQL] DATE_FORMAT
나그네
http://blog.redjini.com/176
2014-01-02T12:55:03+09:00
2008-01-28T19:52:08+09:00
DATE_FORMAT (date,format) 예) SELECT DATE_FORMAT(now(), "%Y-%m-%d %H:%i:%S") 참고 : http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/176">글 전체보기</a></strong></p>
[MySQL] Slow Query Log
나그네
http://blog.redjini.com/168
2014-01-02T12:52:10+09:00
2007-12-06T12:44:02+09:00
MySQL 버젼 : 5.X- my.cnf 파일에 다음사항 추가 [mysqld]...log_slow_queries = /data/log/mysql-slow.log <= 로그파일 경로long_query_time = 1 <= 로그 기록 시간(초)... - 동작여부 확인하기 mysql> show global variables like '%slow%';+------------------+-------+| Variable_name | Valu...
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/168">글 전체보기</a></strong></p>
[MySQL] MySQL dump 오류
나그네
http://blog.redjini.com/161
2014-01-02T12:51:40+09:00
2007-11-15T19:01:18+09:00
$ mysqldump -uroot -p drupal5 > /tmp/drupal5.dumpPassword: mysqldump: Got error: 1016: Can't open file: './mydb/mytable.frm' (errno: 24) when using LOCK TABLES my.cnf파일 [mysqld]섹션에 아래 내용추가 open-files-limit=15000
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/161">글 전체보기</a></strong></p>
[MySQL] MySQL Client 4.0에서 5.0접속문제
나그네
http://blog.redjini.com/141
2014-01-02T12:51:31+09:00
2007-03-30T13:12:01+09:00
원격에있는 혹은 4.0 Lib로 컴파일된 프로그램에서 MySQL 접속시 5.0부터 Password Hash값이 변경되어 "Client does not support authentication protocol" 라는 오류메세지가 출려됩니다. ※ 해결방법mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'som...
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/141">글 전체보기</a></strong></p>
[MySQL] 정규식
나그네
http://blog.redjini.com/140
2014-01-09T12:41:14+09:00
2007-03-29T20:09:10+09:00
SELECT * FROM MyTable WHERE MyField REGEXP '^자바.*소스$' 정규식을 이용하면 LIKE보다 좀더 융통성있는 쿼리를 작성할수 있습니다.하지만 성능면에서는 좀 떨어지는듯합니다. 참고 사이트 http://dev.mysql.com/doc/refman/5.0/en/regexp.html
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/140">글 전체보기</a></strong></p>
[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제
나그네
http://blog.redjini.com/135
2014-01-02T12:50:56+09:00
2007-03-12T14:01:42+09:00
Tabel 문자셋 : UTF-8/etc/my.cnf 에 아래내용을 추가후 MySQL 재기동.[client]character-set = utf8[mysqld]init_connect = SET collation_connection = utf8_general_ciinit_connect = SET NAMES utf8default-character-set = utf8character-set-server = utf8collation-server = utf8_...
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/125">[MySQL] 렌덤하게 레코드 가저오기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/02/15</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/135">글 전체보기</a></strong></p>
[MySQL] 렌덤하게 레코드 가저오기
나그네
http://blog.redjini.com/125
2014-01-02T12:50:42+09:00
2007-02-15T22:55:21+09:00
server_info table에서 임의의 레코드 가저오기. <pre name="CODE" class="brush:sql">SELECT * FROM server_info ORDER BY rand() LIMIT 1;</pre> server_info table에서 가중치를 적용한 임의의 레코드 가저오기. <pre name="CODE" class="brush:js highlight:[1,3]">SELECT * FROM server_info ORDER BY rand()*100+weight DESC LIMIT 1;</pre> ※ weight...
<!-- ACEPRO -->
<div class='google_ad_line_top' id='google_ad_line_top'></div>
<div class='google_ad' id='google_ad'>
<script type='text/javascript'>
<!--
google_ad_client = 'ca-pub-8164287241783066';
/* 블로그 468*60 */
google_ad_slot = '6132571865';
google_ad_width = 468;
google_ad_height= 60;
//-->
</script>
<script type='text/javascript' src='http://pagead2.googlesyndication.com/pagead/show_ads.js'></script>
</div>
<div class='google_ad_line_bottom' id='google_ad_line_bottom'></div>
<div class="scposts">
<h4>"<a href="http://blog.redjini.com/category/2">프로그래밍</a> / <a href="http://blog.redjini.com/category/9">MySQL</a>" 분류의 다른 글</h4>
<table>
<tr><td><a href="http://blog.redjini.com/218">[MySQL] Table Copy</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/11/10</td></tr>
<tr><td><a href="http://blog.redjini.com/197">[MySQL] EUC-KR로 작성된 웹페이지 수정없이 MySQL 5.0 사용하기</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/07/08</td></tr>
<tr><td><a href="http://blog.redjini.com/176">[MySQL] DATE_FORMAT</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2008/01/28</td></tr>
<tr><td><a href="http://blog.redjini.com/168">[MySQL] Slow Query Log</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/12/06</td></tr>
<tr><td><a href="http://blog.redjini.com/161">[MySQL] MySQL dump 오류</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/11/15</td></tr>
<tr><td><a href="http://blog.redjini.com/141">[MySQL] MySQL Client 4.0에서 5.0접속문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/30</td></tr>
<tr><td><a href="http://blog.redjini.com/140">[MySQL] 정규식</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/29</td></tr>
<tr><td><a href="http://blog.redjini.com/135">[MySQL] Java에서 한글(UTF-8) 저장시 깨지는 문제</a> <span class="scp_cm">(0)</span></td><td class="scp_date">2007/03/12</td></tr>
</table></div><p><strong><a href="http://blog.redjini.com/125">글 전체보기</a></strong></p>