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

mysql Ð޸IJéѯÊý¾ÝµÄÎÊÌâ

select time from table

time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15

Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
2009-09-12 15ʱ

Ôõôֱ½ÓÁ¬½Ó£¿select time+¡®Ê±¡¯ from table ÕâÑù²»ÐÐ

½â¾öÁË¡£¡£¡£select DATE_FORMAT(time,'%Y-%m-%d %Hʱ') from table


Ïà¹ØÎÊ´ð£º

phpÈçºÎµ÷ÓÃmysql´æ´¢¹ý³Ì?

ÎÒ´æ´¢¹ý³ÌÏë
begin
select * from newsys;
end

µ«´æ´¢¹ý³ÌµÄ²ÎÊýÓ¦¸ÃÔõôд?


phpÓÖÔõôµ÷Óã¬Çë¸øÎÒÍêÕûµÄʵÀý£¬ÎÒÔÚÍøÉÏËÑÁËÒ»´ó¶Ñ£¬½á¹û¶¼Ã»³É¹¦£¬Ð»Ð»¸÷λ£¡

ûÓùý£¬¶¥Ò»Ï£¡ ......

php¶ÁÈ¡mysqlÊý¾Ý±íÖеÄͼƬÎÞ·¨ÏÔʾ

°´µÀÀíÀ´Ëµ£¬Í¼Æ¬ÊÇÓ¦¸Ã°´ÕÕ·¾¶´æÔÚÊý¾Ý±íÖеģ¬ÓÉÓÚ¹¤×÷ÐèÒª£¬ÐèÒª½«Í¼Æ¬ÒÔ¶þ½øÖÆÁ÷µÄÇé¿ö´æÈëÊý¾Ý¿â£¬ÏÖÔÚ½«Êý¾Ý±ítableÖÐÒ»¸ö×Ö¶Îpicture£¬ÀàÐ͸ÄΪ longblob£¬ÒѾ­Äܳɹ¦½«¶þ½øÖÆÁ÷дÈë¸Ã×ֶΣ¬¿ÉÊÇÎÒÐèÒª½«¸ÃÍ ......

PHPÁ¬½ÓMYSQLÐèÒªÁ¬½ÓÆ÷Âð

ÎÒ°²×°µÄÊÇappserv-win32-2.4.4a.exe×éºÏ°ü£¬ÎÒÔÚmysqlÖд´½¨ÁËÒ»¸ödb_bookÊý¾Ý¿â,²¢ÔÚdb_bookÊý¾Ý¿âÖд´½¨ÁËÒ»¸ötb_book±í£¬ÎÒÏëдһ¸öphp³ÌÐòÏòtb_book±íÖвåÈëÊý¾Ý£¬¿ÉÊdzöÏÖ¡°Ñ¡ÔñÊý¾Ý¿âʧ°Ü£¡¡±µÄÌáʾ£¬²»ÖªÊÇÊ ......

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......

ÕÒmysql·þÎñͻȻµ±µôÔ­Òò

linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔ­Òò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔ­Òò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔ­Òò£¬²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ