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
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒ¿ª·¢ASP.netʱ ²åÈëÍâÎÄÂÒÂë SHOW VARIABLES LIKE 'character%'; Õâ¸öʱºò character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......