Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySqlͨÓô洢·ÖÒ³

DELIMITER $$
DROP PROCEDURE IF EXISTS `hotel`.`prc_page_hotel_result`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE  `hotel`.`prc_page_hotel_result`(
in currpage      int,
in columns       varchar(500),
in tablename     varchar(500),
in sCondition    varchar(500),
in order_field   varchar(100),
in asc_field     int,
in Primary_field varchar(100),
in pagesize      int
)
begin
    declare sTemp  varchar(1000);
    declare sSql   varchar(4000);
    declare sOrder varchar(1000);
   
    if asc_field = 1 then
        set sOrder = concat(' order by ', order_field, ' desc ');
        set sTemp  = '<(select min';
    else
        set sOrder = concat(' order by ', order_field, ' asc ');
        set sTemp  = '>(select max';
    end if;
   
    if currpage = 1 then
        if sCondition <> '' then
            set sSql = concat('select ', columns, ' from ', tablename, ' where ');
            set sSql = concat(sSql, sCondition, sOrder, ' limit ?');
        else
            set sSql = concat('select ', columns, ' from ', tablename, sOrder, ' limit ?');
        end if;
    else
        if sCondition <> '' then
          &nb


Ïà¹ØÎĵµ£º

MYSQL¸ß²¢·¢¼Ü¹¹

L1¡¢HTML¾²Ì¬»¯
Æäʵ´ó¼Ò¶¼ÖªµÀ£¬Ð§ÂÊ×î¸ß¡¢ÏûºÄ×îСµÄ¾ÍÊÇ´¿¾²Ì¬»¯µÄhtmlÒ³Ãæ£¬ËùÒÔÎÒÃǾ¡¿ÉÄÜʹÎÒÃǵÄÍøÕ¾ÉϵÄÒ³Ãæ²É Óþ²Ì¬Ò³ÃæÀ´ÊµÏÖ£¬Õâ¸ö×î¼òµ¥µÄ·½·¨ÆäʵҲÊÇ×îÓÐЧµÄ·½·¨¡£µ«ÊǶÔÓÚ´óÁ¿ÄÚÈݲ¢ÇÒÆµ·±¸üеÄÍøÕ¾£¬ÎÒÃÇÎÞ·¨È«²¿ÊÖ¶¯È¥°¤¸öʵÏÖ£¬ÓÚÊdzöÏÖÁËÎÒÃdz£¼ûµÄÐÅÏ¢ ·¢²¼ÏµÍ³CMS£¬ÏñÎÒÃdz£·ÃÎʵĸ÷¸öÃÅ»§Õ¾µãµÄÐ ......

MySQLÔÓ

MySQLµÄtimestampÀàÐÍ×Ô¶¯¸üÐÂÎÊÌâ
 ½ñÌ콨ÁËÒ»¸ö±í£¬ÀïÃæÓÐÒ»¸öÁÐÊÇtimestampÀàÐÍ£¬ÎÒ±¾ÒâÊÇÔÚÊý¾Ý¸üÐÂʱ£¬Õâ¸ö×ֶεÄʱ¼äÄÜ×Ô¶¯¸üС£ÆñÖª¶ÔÕâ¸öÀàÐ͵ÄÖµ»¹²»ÉõÁ˽⣬µ¼Ö³ö´í¡£·¢ÏÖÕâ¸ö×Ö¶ÎÖ»ÊÇÔÚÕâÐÐÊý¾Ý½¨Á¢µÄʱºòÓÐÖµ£¬ÔÚ¸üеÄÈ´Îޱ仯¡£
    ²éÕÒ×ÊÁÏ£¬·¢ÏÖÊÇÎÒ½¨±íµÄÓï¾äÓÐÎÊÌ⣺
ÒÔÏÂÊÇ´ú ......

ÍêÃÀ¸ã¶¨phpMyAdmin¡°ÎÞ·¨ÔØÈëmysqlÀ©Õ¹¡±

°²×°Íêphpmyadmin
´ó¼Ò¾­³£³öÏÖµÄÎÊÌâ¾ÍÊDZ¨´í£º“ÎÞ·¨ÔØÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÔ¡£
Èç¹ûÄãʹÓõÄÊÇphp5.2ÒÔÉϵİ汾£¬Çë×¢Ò⣺php¶Ô·þÎñµÄÀ©Õ¹¹¦ÄÜ×öÁËÒ»¶¨µÄ¸Ä¶¯£¬Ò²¾ÍÊÇ˵£¬Äã°²×°phpºÍÀ©Õ¹µÄ·½Ê½Ò²Òª×öµ÷ÕûÁË¡£
Ö÷ÒªµÄµ÷ÕûÓÐÁ½·½Ã棬һÊÇPHP5.2ÒÔÉϵİ汾ÖУ¬PHP.INIÎļþÎÞÐèÌí¼Óµ½WINDOWSĿ¼Ï¡£¶þ ......

MySQL Êý¾Ý¿â InnoDBÒýÇæµÄ²åÖµÎÊÌâ

InnoDBÊÇmysqlÊý¾Ý¿âÖÐΨһһ¸öÖ§³ÖÍâ¼üµÄÒýÇæ£¬µ«ÊDzîÖµµÄʱºòÈ´µÃ×¢ÒâÒ»ÏÂ
±ÈÈçÓÐÁ½ÕÅ±í£¬album(id,name,path) £¬picture(id,name,path,parent_album)£¬ÆäÖбí2ÖÐparent_albumÊÇÍâ¼ü
´Ëʱ²îÖµinsert into picture (name,path,parent_album) values ("pic","path",68) (68ÊÇÒ»¸öÏà²áµÄid)
mysql»á±¨´í"Failed to read a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ