mysqlÖÐunionºÍunion allµÄÇø±ðºÍ×¢Òâµã
×òÌìÓиö¹¦ÄÜҪʵÏÖÅÅÐÐЧ¹û£¬¶øÇÒÊÇËæ»ú°´ÕÕijЩ×ֶεÄ×ÜÖµ£¬µ«ÊǵÚÒ»¸öÓÖÒª²»Ò»Ñù£¬ÒòΪµÚÒ»¸öÈ˸øÁËÇ®£¬ËùÒÔÒªÅŵÚÒ»¡£
´ò¸ö±È·½°É£¬±í(userinfo)ÖÐÓÐÕ⼸¸ö×ֶΣºusername,isvalid,givedmoney,sumip,dayip,monthip,visitcount,regdate
ÏÖÔÚҪʵÏÖÏÔʾÅÅÐÐÇ°10λÓû§£¬
³öÏÖÔÚÅÅÐеÚһλµÄÒªÊÇgivedmoneyΪ1µÄÓû§£¨±íʾ¸øÁËÇ®£©£¬ ¶øÇÒisvalidΪ1£¨±íʾͨ¹ýÈÏÖ¤£©
ÆäËüµÄ9¸öÓû§ÄØ£¬ÒªÔÚ×ֶΣ¨sumip,dayip,monthip,visitcount£©ÖÐËæ»úÑ¡ÔñÒ»¸ö×÷ΪÅÅÐòµÄÒÀ¾Ý
ÕâÑùµÄsqlÓï¾ä¸ÄÔõôдÄØ?
ÏÂÃæÊÇÎҵĴ𰸣º
<?php
$arr_orderby=array("sumip","dayip","monthip","visitcount");
$orderby_filed=$arr_orderby(array_rand($arr_orderby) ); //µÃµ½Ëæ»ú×Ö¶Î
$sql="(select username,".$orderby_filed." from userinfo where isvalid=1 and givedmoney=1 limit 1) union (select username,".$orderby_filed." from userinfo where isvalid=1 and givedmoney!=1 limit 9) order by rand(),".$orderby_filed." desc";
?>
ÕâÀïÐèҪעÒâµÄ¼¸µãÊÇ£¬
1£ºunionÇ°ºóµÄselect×Ö¶ÎÒ»¶¨ÒªÒ»Ñù£¬¶øÇÒ˳ÐòÒªÒ»Ñù£¬Èç¹ûÄã²»ÊÇselect * µÄ»°
2£ºµÚ¶þ¸öselectÖУ¬ÊÔÊÔlimit 9ºÍlimit 10ÓÐʲô²»Ò»ÑùµÄЧ¹û
unionºÍunion allµÄÇø±ð¾ÍÊǺóÃæÄÜÌß³öÖظ´µÄ½á¹û£¬Èç¹ûÈ·¶¨±íÖÐûÓÐÖظ´µÄ×ֶΣ¬½¨ÒéʹÓÃunion all
Ò» UNIONÓï·¨
´úÂë ¸´ÖÆ´úÂë
SELECT ...
UNION [ALL | DISTINCT]
SELECT ...
[UNION [ALL | DISTINCT]
SELECT ...]
SELECT ...
UNION [ALL | DISTINCT]
SELECT ...
[UNION [ALL | DISTINCT]
SELECT ...]
UNIONÓÃÓÚ°ÑÀ´×ÔÐí¶à
Ïà¹ØÎĵµ£º
ËùÐèÈí¼þÔ´´úÂë°ü£º
httpd-2.2.4.tar.gz mysql-5.0.27.tar.gz php-5.2.1.tar.bz2
freetype-2.3.2.tar.gz gd-2.0.34.tar.gz jpegsrc.v6b.tar.gz
libpng-1.2.8.tar.bz2 libxml2-2.6.24.tar.bz2 zlib-1.2.2.tar.gz
°²×°Ë³Ðò£ºapache -> mysql ......
Ò»Ö±ÒÔΪmysqlËæ»ú²éѯ¼¸ÌõÊý¾Ý£¬¾ÍÓÃ
SELECT
*
from
`
table
`
ORDER
BY
RAND
() LIMIT
5
¾Í¿ÉÒÔÁË¡£
µ«ÊÇÕæÕý²âÊÔһϲŷ¢ÏÖÕâÑùЧÂʷdz£µÍ¡£Ò»¸ö15ÍòÓàÌõµÄ¿â£¬²éѯ5ÌõÊý¾Ý£¬¾ÓȻҪ8ÃëÒÔÉÏ
²é¿´¹Ù·½ÊֲᣬҲ˵rand()·ÅÔÚORDER BY ×Ó¾äÖлᱻִÐж ......
/*ÑÝʾһ¸öJDBC³ÌÐò£¬´ÓMysqlµÄLMDÊý¾Ý¿âÖжÁ³ö±íadminµÄÒ»¸öÐÅÏ¢*/
import java.sql.*;
public class TestMysqlConnection {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = ......
1. ¸øroot¼ÓÃÜÂ룺/usr/bin/mysqladmin -u root password 123456
2. µ¼³ö£ºmysqldump -u root -p dbname > file.sql
3. µ¼È룺mysql -u root -p dbname < backup-file.sql
4. ÊÚȨ£ºgrant all on *.* to root@"%" identified by "ÃÜÂë";
5. ÊÕ»ØȨÏÞ£ºrevoke all privileges on *.* from root@"%";
6. µÇ¼£ºmys ......
ÔÚʹÓÃWindowsÃüÁîÐвÙ×÷MySQLÊý¾Ý¿âµÄʱºò£¬ÒÔutf8¸ñʽ´æ´¢ÔÚMySQLÊý¾Ý¿âÖеÄÊý¾Ý£¬´ÓÃüÁîÐжÁÈ¡³öÀ´×ÜÊÇÂÒÂ룬ÏÔʾȫÊÇÎʺš£»òÕß´ÓÃüÁîÐвåÈëÐÂÊý¾Ý£¬½á¹ûÏà·´£¬ÔÚÃüÁîÐÐÖÐÏÔʾÊÇÕý³£µÄ£¬µ«ÊÇÔÚPHPMyAdminÖÐÈ´ÊÇÂÒÂë¡£
¡¡¡¡¾¹ýÉÏÍø²éÕÒÑо¿£¬·¢ÏÖmysqlµÄÃüÁîÐпͻ§¶Ë¸ù±¾ÎÞ·¨ÒÔutf-8µÄÐÎʽ·µ»ØÊý¾Ý£¬½â¾öÈçÏ¡£
¡¡¡¡² ......