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

MySQL·¢³ö½ÐÉù

MySQLÃüÁîÊäÈë´íÎóºó,Ö´ÐдíÎóÃüÁî·¢³ö¿ÉŵĽÐÉù
ÔõôÑù½â¾ö???
ÄǽÐÉùÒô¸úÖ¸Õë¶ÁÊý¾Ý¶Á´íÁË,·¢³öÒ»Ñù¿ÉÒÔŵĽÐÉù
¸ãµÄÎÒ²»¸ÒÓÃÃüÁîÐÐ


ºÇºÇ£¡lzÕæ¿É°®£¡

·½·¨Ò»£¬°ÑÄãµÄPCÉϵÄÀ®°È²ð³ý
·½·¨¶þ£¬°ÑÄã¶ú¶ä¹Ø±Õ






ÒýÓÃ
·½·¨Ò»£¬°ÑÄãµÄPCÉϵÄÀ®°È²ð³ý
·½·¨¶þ£¬°ÑÄã¶ú¶ä¹Ø±Õ





ÍÆ¼ö:µ±Ëü½Ðʱ£¬ÄãÎÂÈáµØ¸æËßËü£º¡°Ð¡±¦±¦£¬¹Ô¹Ô˯¾õÁË¡±


ÓÐÒâ˼

ÒýÓÃ
ÐÞ¸Ämy.iniÅäÖÃÎļþ£¬
ÔÚ[mysql]ϼÓÈëÒ»ÐÐno-beep£¬ÖØÆômysql·þÎñ

[mysql]
no-beep

ÎÒ¶¥Ä㣡

ÔÚCMOSÀïÉèÖÃһϵÃÁË£¬°Ñϵͳ±¨¾¯¸ødisabledà¶¡£»òÕß¾ÍÊǰÑÀ®°ÈÏß¶Ï¿ª£¬°Îµô¾ÍÐС£ÎÒµ¹Í¦Ï²»¶ÕâÖÖÉùÒôµÄ¡£


Ïà¹ØÎÊ´ð£º

100·ÖÇóÖú£¬¹ØÓÚJSPÏÂÌá½»ÖÐÎÄ×Ö·ûÈ¥MYSQLÂÒÂëÎÊÌâ¡£

jspÌá½»Ò³±àÂëÊÇUTF-8£¬MYSQL¿âÒ²ÊÇUTF-8,ΪʲôÌá½»ÁËÖÐÎÄ×Ö·ûÔÚÊý¾Ý¿âÀï±ä³ÉÂÒÂëÁËÄØ£¿

ÕâÖÖÎÊÌâÔõô½â¾ö£¿Ð»Ð»

ÁíÍ⣬JSPµ¯³ö¶Ô»°¿ò£¨±ÈÈ絯³ö¡°XXXÉóºËͨ¹ý¡±ÏÂÃæ¸úÈ·¶¨°´Å¥£©ºÍ·µ»ØÉÏÒ»Ò³ÒÔ¼°×ªµ ......

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ʱ
......

mysqlµÄ sequence µÄÎÊÌâ¡£ÔÚÏߵȴý¡£¡£

ÇëÎÊһϣ¬mysqlµÄsequenceÊÇ×Ô¶¯µÝÔöµÄ£¬²»ÐèÒª½øÐвÙ×÷¡£
ÄÇÎÒÔÚ²åÈëÒ»ÌõÖ÷¼Ç¼µÄʱºò£¬Í¬Ê±Òª¸øÕâ¸öÖ÷¼üµÄÆäËû±í½øÐвåÈëÊý¾Ý¡£Õâʱºò£¬ÎÒ¸ù±¾È¡²»µ½Õâ¸öµÝÔöµÄsequence°¢¡£¡£

Õâ¸öÎÊÌâÔõô½â¾ö°¢¡£¡£ ......

MySql command line clientÎÊÌ⣬¼±£¡

mySql5.1µÄ mysql command line clientÃüÁî´°¿Úÿ´ÎÒ»µãËü,Ëü¾ÍÒ»ÉÁ¶ø¹ý,²»»áÏÔʾÁË.ÕâÊÇʲôÎÊÌâ?
ÔÚÄãµÄWINDOWSÉÏ£¬ÏȰ´ [¿ªÊ¼], È»ºó [ÔËÐÐ] ,ÊäÈë cmd È»ºó»Ø³µ

È»ºóÔÙÔÚÕâ¸öDOS´°ÌåÖУ¬ cd C:\Program ......

mysqlÁ¬½ÓÎÊÌâ

Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ

ÃÜÂë´íÁ˰ɡ£

¸Õѧmysql,ÕÕ×ÅÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ