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

mysql>show databasesû·´Ó¦

ÈçÌ⣺ÎÒÔÚDOSÏÂÔËÐÐmysqlÖ¸ÁîÔõôһµãЧ¹ûҲûÓа¡£¿

»¹ÓÐÎÒÔÚphpÖÐ mysql_query("show tables");ҲûÓÐЧ¹û£¬ÊDz»ÊÇÎÒÅäÖÃÓÐÎÊÌâ°¡£¿

СµÜ¸Õѧphp£¬Çë¸ßÊÖÖ¸½Ìһϣ¡
ÔÚmysql¿ØÖÆÌ¨£¬½øÈëÖ®ºóÊäÈëÃÜÂë
  ¿ªÊ¼mysql>µÄ±êÖ¾
²é¿´Êý¾Ý¿â£ºshow databases;  //»áÁгöËùÓÐÊý¾Ý¿â
Ñ¡ÔñÒ»¸öÊý¾Ý¿â:  use databasename(Êý¾Ý¿âÃû);  //Ñ¡ÔñÒ»¸öÊý¾Ý¿âÖ®ºó²ÅÄܶԸÃÊý¾Ý¿â½øÐÐÏìÓ¦²Ù×÷
²é¿´¸ÃÊý¾Ý¿âËùÓбí: show tables;  //ÁгöËùÓбí
»¹ÓÐÆäËûµÄһЩÃüÁ¥Ö÷ÉÏÍøÕÒ°É£¬²»È»Ï¸ömysqlµÄÃüÁîÊֲῴ¿´


ÒýÓÃmysql>show databasesû·´Ó¦


ÄãÊÇÒÔʲô·½Ê½½øÈë mysql> µÄ£¿


ÏÂÃæ´ÖÌåΪ¼üÅÌÊäÈë

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p123 csdn
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.33-community-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| csdn              |
| db_m1234          |
| examples          |
| mysql 


Ïà¹ØÎÊ´ð£º

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

MYSQL character_set_server Ôõô¸Ä

ÎÒ¿ª·¢ASP.netʱ 
²åÈëÍâÎÄÂÒÂë 
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8 
character_set_connection utf8 
character_set_database utf8 
ch ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ