Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡£

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


Ïà¹ØÎÊ´ð£º

100·Ö¹òÇóPHP²éѯ¸üÐÂɾ³ýMYSQLÖеÄXMLµÄÀý×Ó

¶ÔMYSQLÖд洢µÄXML¸ñʽµÄÊý¾Ý½øÐвéѯ¸üÐÂÒÔ¼°É¾³ýij½áµã´¦ÀíµÄÀý×Ó£¬Çë·¢ÎÒÓÊÏ䣬лл£¬
30367940@qq.com
·¢ËͺóÇë»ØÌû£¬ÊÕµ½¼°½áÌû
ÄãÒªmysql¸ÉÂï?

ÂãÇó¿ÉÒÔ¿¼ÂÇ!

¶¥ÉÏÈ¥

¶Á³öÀ´È»ºóÓÃSimpleXML´ ......

ÈçºÎÓÃjspʵÏÖmysqlÊý¾Ý¿â±àÂ룿

ÔÚphpÖÐÓÃÕâ¾ä¾Í¿ÉʵÏÖ¶Ô¿Í»§¶Ë×Ö·û¼¯µÄÉèÖÃ....

mysql_query("set names gb2312")

ÇëÎÊÔÚjspÖÐÈçºÎʵÏÖÕâ¾ä¹¦ÄÜ£¿£¿£¿
jspÖУº
<%@page language="java" contentType=&q ......

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

Java code:

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

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

linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔ­Òò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔ­Òò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔ­Òò£¬²» ......

MySQL±àÂëµÄÎÊÌâ

ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ