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

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

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

È»ºóÔÙÔÚÕâ¸öDOS´°ÌåÖУ¬ cd C:\Program Files\MySQL\MySQL Server 5.1\bin (»Ø³µ)  ×¢Òâºì×־Ͳ»Òª´ò³Éºº×ÖÁË£¬ÊÇÈÃÄã°´»Ø³µ¼ü£¬Èç¹û²»ÖªµÀ»Ø³µ¼üÔÚÄĶù£¬Çë×ÔÐвéÒ»ÏÂGOOGLE¡£

È»ºóÔÙmysql -u root -p (»Ø³µ) ÕâÀïµÄºì×ÖͬÉÏ¡£

ÒýÓÃ
ÔÚÄãµÄWINDOWSÉÏ£¬ÏÈ°´ [¿ªÊ¼], È»ºó [ÔËÐÐ] ,ÊäÈëcmd È»ºó»Ø³µ

È»ºóÔÙÔÚÕâ¸öDOS´°ÌåÖУ¬ cd C:\Program Files\MySQL\MySQL Server 5.1\bin(»Ø³µ)  ×¢Òâºì×־Ͳ»Òª´ò³Éºº×ÖÁË£¬ÊÇÈÃÄã°´»Ø³µ¼ü£¬Èç¹û²»ÖªµÀ»Ø³µ¼üÔÚÄĶù£¬Çë×ÔÐвéÒ»ÏÂGOOGLE¡£

È»ºóÔÙmysql -u root -p(»Ø³µ) ÕâÀïµÄºì×ÖͬÉÏ¡£


D:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
mysql: Character set 'UTF-8' is not a compiled character set and is not specified in the 'C:\mys
ql\\share\charsets\Index.xml' file

D:\Program Files\MySQL\MySQL Server 5.0\bin>






acmain£¬Ð»Ð»¡£ÎÒÖØÐÂÅäÖÃÁËһϿÉÒÔÁË£¬ºÇºÇ¡£

лл£¬ÓÖѧ»áÒ»Õйþ¹þ

Æäʵ£¬Ö±½ÓÈ¥MySQL°²×°Ä¿Â¼ÏÂÆô¶¯MySQLÒ²ÐС£¾ÍÔÚbinÎļþ¼ÐÏ£¬¾ÍÊÇMySQL.exeË«»÷¾ÍokÁË¡£È»ºó¿´¿´½ø³ÌÀïÊÇ·ñÆô¶¯·þÎñÁ˾ÍÐС£ÎÒÓÐÂÌÉ«°æµÄ·þÎñÆ÷ÄãÒª²»Òª°¡¡£»¹ÓÐÆƽâ°æµÄͼÐνçÃæŶ£¬²»¹ýÌ«´óÁËÉÏ´«²»ÁË£¬120¶àM¡£

ÒýÓÃ
лл£¬ÓÖѧ»áÒ»Õйþ¹þ


Ïà¹ØÎÊ´ð£º

javaµ÷ÓÃmysqlÃüÁîµ¼ÈëÊý¾Ý

Java code:

public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......

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

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

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 °²È«ÎÊÌâ

×î½üÔÚÑо¿Êý¾Ý¿âµÄ°²È«ÎÊÌ⣬·¢ÏÖMYSQLÓкܶలȫ©¶´£¬ÏëÇë½Ì´ó¼Ò£¬ÔÚ¹ÜÀí·½ÃæÈçºÎÀ´·ÀÖ¹°²È«Òþ»¼¡£

ÎÒÁ˽⵽ÓÐ×¢Èë¹¥»÷£¬¸ÃÈçºÎ·ÀÖ¹£¿

»¹ÓйØÓÚÕ˺š¢ÃÜÂëµÄ¹ÜÀí¡¢ÎļþÊôÐÔµÈ
1. ²Ù×÷ϵͳµÄ°²È«£¬ ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ