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

MYSQL »ñÈ¡µ±Ç°ÈÕÆÚ¼°ÈÕÆÚ¸ñʽ

MYSQL »ñÈ¡µ±Ç°ÈÕÆÚ¼°ÈÕÆÚ¸ñʽ
   »ñȡϵͳÈÕÆÚ£º  NOW()
   ¸ñʽ»¯ÈÕÆÚ£º    DATE_FORMAT(date, format)
               ×¢£º   date£ºÊ±¼ä×Ö¶Î
                         format£ºÈÕÆÚ¸ñʽ
·µ»ØÏµÍ³ÈÕÆÚ,Êä³ö 2009-12-25 14:38:59
select now();
Êä³ö 09-12-25
select date_format(now(),'%y-%m-%d');
¸ù¾Ýformat×Ö·û´®¸ñʽ»¯dateÖµ:
%S, %s  Á½Î»Êý×ÖÐÎʽµÄÃ루 00,01, ..., 59£©
%I, %i  Á½Î»Êý×ÖÐÎʽµÄ·Ö£¨ 00,01, ..., 59£©
%H  Á½Î»Êý×ÖÐÎʽµÄСʱ£¬24 Сʱ£¨00,01, ..., 23£©
%h  Á½Î»Êý×ÖÐÎʽµÄСʱ£¬12 Сʱ£¨01,02, ..., 12£©
%k  Êý×ÖÐÎʽµÄСʱ£¬24 Сʱ£¨0,1, ..., 23£©
%l  Êý×ÖÐÎʽµÄСʱ£¬12 Сʱ£¨1, 2, ..., 12£©
%T  24 СʱµÄʱ¼äÐÎʽ£¨hh:mm:ss£©
%r  12 СʱµÄʱ¼äÐÎʽ£¨hh:mm:ss AM »òhh:mm:ss PM£©
%p  AM»òPM
%W  Ò»ÖÜÖÐÿһÌìµÄÃû³Æ£¨Sunday, Monday, ..., Saturday£©
%a  Ò»ÖÜÖÐÿһÌìÃû³ÆµÄËõд£¨Sun, Mon, ..., Sat£©
%d  Á½Î»Êý×Ö±íʾÔÂÖеÄÌìÊý£¨00, 01,..., 31£©
%e  Êý×ÖÐÎʽ±íʾÔÂÖеÄÌìÊý£¨1, 2£¬ ..., 31£©
%D  Ó¢Îĺó׺±íʾÔÂÖеÄÌìÊý£¨1st, 2nd, 3rd,...£©
%w  ÒÔÊý×ÖÐÎʽ±íʾÖÜÖеÄÌìÊý£¨ 0 = Sunday, 1=Monday, ..., 6=Saturday£©
%j  ÒÔÈýλÊý×Ö±íʾÄêÖеÄÌìÊý£¨ 001, 002, ..., 366£©
%U  ÖÜ£¨0, 1, 52£©£¬ÆäÖÐSunday ΪÖÜÖеĵÚÒ»Ìì
%u  ÖÜ£¨0, 1, 52£©£¬ÆäÖÐMonday ΪÖÜÖеĵÚÒ»Ìì
%M  ÔÂÃû£¨January, February, ..., December£©
%b  ËõдµÄÔÂÃû£¨ January, February,...., December£©
%m  Á½Î»Êý×Ö±íʾµÄÔ·ݣ¨01, 02, ..., 12£©
%c  Êý×Ö±íʾµÄÔ·ݣ¨1, 2, ...., 12£©
%Y  ËÄλÊý×Ö±íʾµÄÄê·Ý
%y  Á½Î»Êý×Ö±íʾµÄÄê·Ý
%%  Ö±½ÓÖµ“%”


Ïà¹ØÎĵµ£º

mysql³ö´í´úÂëÖÐÎÄ˵Ã÷

¡¡¡¡mysql³ö´íÁË,ÒÔǰÍùÍù¿¿²Â.ÓÐÁËÕâÕűí,Ò»²é¾Í³öÀ´ÁË.·½±ã²»ÉÙ.ÌØ¹²ÏíÓÚÖÚ
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1011£ºÉ¾³ýÊý¾Ý¿âÎļþʧ ......

Mysql LOAD DATAÃüÁîµÄÏà¹ØÊÂÏî

1.ÔÚWINDOWÏ£¬¼Ç¼Êý¾ÝµÄÎı¾Îļþ±ØÐë²»ÄÜÒÔÖÐÎÄÃüÃû£¨ÃüÁîÐнçÃæÎÞ·¨ÊäÈëÖÐÎÄ£©£¬ÇÒÐè±£´æÔÚ´ÅÅ̸ùĿ¼Ï¡£
2.×Ö¶ÎÖµÖ®¼ä±ØÐëÒªÒÔLOAD DATAÃüÁîÖÐÖ¸¶¨µÄ·Ö¸ô·û·Ö¸ô£¬Ä¬ÈÏΪTAB£¬·ñÔò²»Ê¶±ð£¬Ôì³É¸Ã×Ö¶ÎֵΪNULL¡£
3.ֵΪ¿ÕµÄ×ֶΣ¬ÔÚÎı¾ÎļþÀï¿ÉÒÔÉèΪ¿Õ£¬Ò²¿ÉÒÔÉèΪ\N.
4.WINDOWÏ£¬²»¼Ó"LINES TERMINATED BY ' ......

VB6.0ÈçºÎÓà libmySQL.dll API·ÃÎÊMYSQLÊý¾Ý¿â

MYSQL Ó¦ÓÃÊ®·Ö¹ã·¶£¬ºÜ¶àÍøÕ¾¼¸ºõ¶¼ÔÚÓÃËû£¬ÒòΪËûµÄСÇɺÍÁé»îÐԵȷ½ÃæÈÃÎÒ¾ö¶¨Òª¶ÔËû½øÐÐÑо¿£¬µ½ÏÖÔÚÒѾ­³É¹¦µÄ²»Óþ­¹ýODBC£¬ADOµÈ·½Ê½¾Í¿ÉÒÔ¶ÁÈ¡ºÍ¸üÐÂÊý¾Ý¡£
 
ºÃÁ˲»¶àÂÞ࣬ÒÔÏÂÎÒÀ´½éÉÜ×ܸö³ÌÐòµÄϸ½Ú:
 
£¨Ò»£©APIÉùÃ÷
 
1.  '·ÖÅä»ò³õʼ»¯ÊʺÏmysql_real_connect()µÄÒ»¸öMYSQL¶ÔÏñ¡ ......

¹ØÓÚMySQLÊý¾Ý¿âµÄ´æ´¢ÒýÇæ

MySQLÖеÄÊý¾ÝÓø÷ÖÖ²»Í¬µÄ¼¼Êõ´æ´¢ÔÚÎļþ(»òÕßÄÚ´æ)ÖС£ÕâЩ¼¼ÊõÖеÄÿһÖÖ¼¼Êõ¶¼Ê¹Óò»Í¬µÄ´æ´¢»úÖÆ¡¢Ë÷Òý¼¼ÇÉ¡¢Ëø¶¨Ë®Æ½²¢ÇÒ×îÖÕÌṩ¹ã·ºµÄ²»Í¬µÄ¹¦ÄܺÍÄÜÁ¦¡£Í¨¹ýÑ¡Ôñ²»Í¬µÄ¼¼Êõ£¬ÄãÄܹ»»ñµÃ¶îÍâµÄËÙ¶È»òÕß¹¦ÄÜ£¬´Ó¶ø¸ÄÉÆÄãµÄÓ¦ÓõÄÕûÌ幦ÄÜ¡£
ÀýÈ磬Èç¹ûÄãÔÚÑо¿´óÁ¿µÄÁÙʱÊý¾Ý£¬ÄãÒ²ÐíÐèҪʹÓÃÄÚ´æ´æ´¢ÒýÇæ¡£ÄÚ´æ´æ´ ......

cmdÏÂmysqlÐÂÊÖÁ·ÊÖʵÀý

1,ÔÚcmdÏÂÓÃmysql¿Í»§»úÁ¬½Ómysql·þÎñÆ÷ php³ÌÐòÔ±Õ¾
´ò¿ªcmdºó,ÊäÈë php³ÌÐòÔ±Õ¾
mysql -h localhost -u root -p
phperz.com
Óï·¨: mysqlµ±È»ÊǸæËßcmd,ÕâÊÇmysqlµÄÃüÁîÁË php³ÌÐòÔ±Ö®¼Ò
²ÎÊý -h ÊÇ·þÎñÆ÷µØÖ·,ÔÚ´ËÎÒÃÇÒÔ±¾»úΪÀýÊäÈëlocalhost
-u ÊÇmysqlµÄÓû§Ãû  ÎÒÃÇÓÃmysql µÄĬÈÏÓû§Ãû root phperz ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ