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

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


Ïà¹ØÎÊ´ð£º

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

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

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

Java code:

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

javaÔõôµ÷ÓÃmysql´´½¨µÄ±í

Õâ¸öÎÊÌâÀ§ÈÅÎҺþÃÁË£¬ÎÒÒ²²»ÖªµÀÔõôÎÊ£¬Ö»ÄÜ´óÖÂ˵һÏ£º
ÎÒÓÃMySQL´´½¨ÁËÒ»¸öÊý¾Ý¿â bookinfo±í£¬ÒªÓÃJavaµ÷ÓÃÕâÕÅ±í£¬µ«Êǵ÷Óò»³öÀ´£¬ÒªÊ²Ã´¾ä×Ó²ÅÄܵ÷ÓÃMySQL´´½¨µÄÊý¾Ý¿âÄØ¡£
Java code:
String url = ......

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

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

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

MySQL±àÂëµÄÎÊÌâ

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