ÎÒµ±Ç°µÄlinuxÊÇcent0s 5.3
ÇëÎÊÓ¦¸ÃÏÂÔØÄĸö°æ±¾µÄ mysql°²×°Îļþ±È½ÏºÏÊÊ£¿£¿
* Windows
* Windows x64
* Linux (non RPM packages)
* Linux (non RPM, Intel C/C++ compiled, glibc-2.3)
* Red Hat Enterprise Linux 3 RP ......
ÎÒҪʵÏÖ18£º00ǰÏÔʾ×òÌìÊý¾Ý18£º00ºóÏÔʾ½ñÌìÊý¾Ý£¬°ïÎÒ¿´¿´Õâ¸öÓï¾äÓÐʲôÎÊÌ⣡£¡
where newstime>=concat(date_format(date_add(now(),interval -1 day),'%Y-%m-%d'),' 18:00:00')
Õâ¸öֻʵÏÖÁË18£º00ǰÏÔʾ×òÌìÊý¾Ý£¬µ«ÊÇ18£º00ºó·¢µÄ½ñÌìÊý¾ÝµÈµ½24£º00²Å»áÏÔʾ¡£¡£¡£¸ÃÔõôд²Å ......
пªÒ»¸öÐéÄâ»úÆ÷ ÍøÉÏÏÂMySQL-server-community-5.0.89-0.rhel5.i386.rpm;
MySQL-client-community-5.0.89-0.rhel5.i386.rpm;
·¢ÏÖʧ°Ü
²»ÖªµÀÔÒò£¿
Ö´Ðйý³ÌÈçÏÂ
[root@localhost mysql]# rpm -ivh MySQL-server-community-5.0.89-0.rhel5.i386.rpm;
warning: MySQL-server-community-5.0.89-0.rh ......
s_user ±íÖк¬id loginTime¡¡¶þ×Ö¶Î
ÏÖÏëͨ¹ý¡¡idµÄ´óµ½Ð¡£¬Í¬Ê±ÓÖÒª°´loginTimeµÄ×î½üµ½×î¾ÃͬʱÅÅÐò
ÔõôʵÏÖѽ£¬
£¨ÎÒ×Ô¼ºÐ´µÄselect id from s_user order by loginTime desc ,id desc ÔËÐв»³É¹¦¡¡£©¶àл
¿´²»³öÓÐʲôÎÊÌâ.ÄãдµÄSqlÓ¦¸ÃÊÇÕýÈ·µÄ...ÄãÔËÐдíÎóµÄÐÅÏ¢ÊÇʲô
ûÓдíÎóÐÅÏ¢£¬Ö»ÊÇÔËÐÐ ......
ÈçºÎ½«mysqlÊý¾ÝÒÆÖ²µ½sql server£¿ËµËµ½â¾ö·½°¸ºÍÒÆÖ²¹ý³ÌËùÓõ½µÄ¹¤¾ß£¡Ð»Ð»
µ¼Èëµ¼³ö¹¤¾ß
¹Ø×¢£¬°ï¶¥£¡
ÒýÓÃ
µ¼Èëµ¼³ö¹¤¾ß
77 ¸ÕºÃÎÊÏ£¬ÏÖÔÚ³£Óõĵ¼Èëµ¼³ö¹¤¾ß¶¼ÓУ¿£¿£¿£¿
²éºÃ¾Ã£¬Ã»Óеõ½ÏëÒªµÄ¹¤¾ß£¬Í´¿à°¡¡£ÔËÐÐÁ˼¸ÄêµÄϵͳ£¬Í»È»¼äËµÒªÒÆÖ²£¬°¥£¬´ó¼ÒÀ´°ï°ïæ°É£¡
......
ÔÚredhat ÆóÒµ°æ±¾3 °²×°³É¹¦
MySQL-server-community-5.1.42-0.rhel3.i386
MySQL-client-community-5.1.42-0.rhel3.i386
ûÓб¨´íÎó¡£
Êý¾Ý¿âÆô¶¯Ò²Êdzɹ¦µÄ
ÏÖÔÚÓиöÎÊÌâ £¬ºÃÆæ¹Ö
ÎÒÓÃmysql £uroot £p
×ÜÊÇÌáʾÎÒ ÈçÏ bash £ºmysql £º command not found
ÉõÖÁÎÒÖ ......