Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

MYSQL character_set_server Ôõô¸Ä

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

mysql ÔõÑù²ÅÄܶÔͬһÕűí²éѯºóÔÙ¸üÐÂ?

Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ