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

mysql ÃüÁîʹÓÃ

mysql ÃüÁîѧϰ£º
1. mysql -uroot  ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ;                 //ÏÔʾËùÓеÄÊý¾Ý¿â ;
4.show tables ;                       //ÏÔʾËùÓеıí ;
5.set names gbk ;                   //ÉèÖÃ×Ö·û¼¯ ;
6.desc tmonthfees201004 ;    //ÏÔʾ±í½á¹¹ ;
7.alter table tcontents change cVersion cVersion varchar(128) null ;   //ÐÞ¸Ämysql±íÖÐ×ֶεÄÊôÐÔ ;
8. show index from tcontents from newdrmdb;
    show index from newdrmdb.tcontents ;
    show keys from tcontents ;                         
    show indexes from tcontents ;                     //²é¿´±íµÄË÷Òý ;


Ïà¹ØÎĵµ£º

ÈÃMySQLÖ§³ÖInnoDB

ÔÚmysqlÖÐÊäÈëSHOW variables like "have_%"²é¿´£¬ÏÔʾÈçÏ£º
mysql> SHOW variables like "have_%";
  
+-----------------------+----------+
| Variable_name         | Value    |
+-----------------------+----------+
| have_archive     ......

mysqlµÄÅäÖÃÎļþmy.ini

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Li ......

PowerDesignerÉ趨MySQL×Ö¶ÎidentityÀàÐÍ

×ÔÔö³¤ÀàÐÍÔö¼Ó
1.Èç¹ûdbmsÊÇMsSql,ÔòÑ¡¶¨±íºó£¬database-> edit   current   dbms-> ³öÏÖDBMS   properties¶Ô»°¿ò£¬Ñ¡ÔñGeneralÒ³£¬×ó²àµÄÊ÷Ñ¡ÔñSQL   2000-> Profile-> Column-> Extended   Attributes   ÏÂÃæµÄExtIdentityIncrementÊDz½½ø ......

mysql ×Ó²éѯɾ³ý¼Ç¼

    mysql ¿ÉÒÔͨ¹ý×Ó²éѯµÃµ½ÒªÉ¾³ýµÄ¼Ç¼Ìõ¼þ£¬È»ºóͨ¹ý×Ó²éѯµÃ½á¹ûÆ¥ÅäҪɾ³ýµÄ¼Ç¼¡£µ«ÊÇ mysql ²»ÄÜÖ±½Óɾ³ý×Ó²éѯ±íÖеÄÊý¾Ý£¬±ØÐëͨ¹ýÒ»¸öÁÙʱ±íÀ´½â¾ö¡£ÀýÈ磺
    delete from t_transaction where exists
    (select d.* from t_ti_category a,t_category b,t_ ......

MySql³£ÓÃÃüÁî

MySql³£ÓÃÃüÁî
 
¡¾MySqlÃüÁî´°¿ÚÆô¶¯£ºÇëÖ´ÐÐ\bin\mysql.exe¡¿
 
1:ʹÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES;
2:´´½¨Ò»¸öÊý¾Ý¿âMYSQLDATA
mysql> CREATE DATABASE MYSQLDATA;
3:Ñ¡ÔñÄãËù´´½¨µÄÊý¾Ý¿â
mysql> USE MYSQLDATA; (°´»Ø³µ¼ü³öÏÖDatabase changed Ê±Ë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ