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

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ


 Ô´µØÖ·: http://www.pcppc.cn/shujuku/mysql/shujuku_163919.html
 
 
ÄúÕýÔÚ¿´µÄMySQL½Ì³ÌÊÇ:MySQLÊý¾Ý¿âѧϰ±Ê¼Ç¡£
¡¡¡¡MySQLÊý¾Ý¿âѧϰ±Ê¼Ç 
(ʵÑé»·¾³:Redhat9.0,MySQL3.23.54) 
¸ÙÒª£º 
Ò»£¬Á¬½ÓMySQL 
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ 
Èý£¬Êý¾Ý¿â¼òµ¥²Ù×÷ 
ËÄ, Êý¾Ý¿â±¸·Ý 
Î壬ºó¼Ç 
Ò»£¬Á¬½ÓMySQL 
¸ñʽ£ºmysql -h Ô¶³ÌÖ÷»úµØÖ· -u Óû§Ãû -p »Ø³µ 
ÊäÈëÃÜÂë½øÈ룺 
mysql -u root -p »Ø³µ 
Enter password: ,ÊäÈëÃÜÂë¾Í¿ÉÒÔ½øÈë 
mysql> ½øÈëÁË 
Í˳öÃüÁî:>exit »òÕßctrl+D 
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ 
1.ÐÞ¸ÄÃÜÂ룺 
¸ñʽ£ºmysqladmin -u Óû§Ãû -p ¾ÉÃÜÂë password ÐÂÃÜÂë 
2.Ôö¼ÓÐÂÓû§: 
>grant create,select,update....(ÊÚÓèÏà¹ØµÄ²Ù×÷ȨÏÞ) 
->on Êý¾Ý¿â.* 
-> to Óû§Ãû@µÇ¼Ö÷»ú identified by 'ÃÜÂë' 
²Ù×÷ʵÀý£º 
¸ørootÓû§Ìí¼ÓÃÜÂë: 
# mysqladmin -u root password 52netseek 
ÒòΪ¿ªÊ¼rootûÓÐÃÜÂë,ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¿ÉÒÔÊ¡ÂÔ. 
µÇ½²âÊÔ£º 
# mysql -u root -p »Ø³µ 
ÊäÈëÃÜÂë,³É¹¦µÇ½. 
½«Ô­ÓеÄmysql¹ÜÀíµÇ½ÃÜÂë52netseek¸ÄΪ52china. 
# mysqladmin -u root -p 52netseek password '52china' 
´´½¨Êý¾Ý¿âÌí¼ÓÓû§²¢ÊÚÓèÏàÓ¦µÄȨÏÞ: 
mysql> create database phpbb; 
Query OK, 1 row affected (0.02 sec) 
mysql> use phpbb; 
Database changed 
mysql> grant create,select,update,insert,delete,alter 
-> on phpbb.* 
-> to phpbbroot@localhost identified by '52netseek'; 
Query OK, 0 rows affected (0.00 sec) 
ÊÚÓèËùÓеÄȨÏÞ: 
>grant all privileges 
>on bbs.* 
>to bbsroot@localhost identified by '52netseek' 
»ØÊÕȨÏÞ£º 
revoke create,select,update,insert,delete,alter 
on phpbb.* 
from phpbbroot@localhost identified by '52netseek'; 
ÍêÈ«½«phpbbrootÕâ¸öÓû§É¾³ý: 
>use mysql 
>delete from user 
where user='phpbbroot' and host='localhost'; 
>flush privileges; Ë¢ÐÂÊý¾Ý¿â 
Èý


Ïà¹ØÎĵµ£º

[MySQLÓÅ»¯] ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷


[MySQLÓÅ»¯] -- ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:diesou
mysql µÄ sql ÐÔÄÜ·ÖÎöÆ÷Ö÷ÒªÓÃ;ÊÇÏÔʾ sql Ö´ÐеÄÕû¸ö¹ý³ÌÖи÷Ïî×ÊÔ´µÄʹÓÃÇé¿ö¡£·ÖÎöÆ÷¿ÉÒÔ¸üºÃµÄչʾ³ö²»Á¼ SQL µÄÐÔÄÜÎÊÌâËùÔÚ¡£ ÏÂÃæÎÒÃǾÙÀý½éÉÜһϠMySQL SQL Profiler µÄʹÓ÷½·¨£º Ê×ÏÈ£¬¿ªÆô MySQL SQL ......

[MySQLÓÅ»¯] ÈçºÎ²éÕÒSQLЧÂʵØÏµÄÔ­Òò


[MySQLÓÅ»¯] -- ÈçºÎ²éÕÒSQLЧÂʵØÏµÄÔ­Òò
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chusong
²éѯµ½Ð§ÂÊµÍµÄ SQL Óï¾ä ºó£¬¿ÉÒÔͨ¹ý EXPLAIN »òÕß DESC ÃüÁî»ñÈ¡ MySQL ÈçºÎÖ´ÐÐ SELECT Óï¾äµÄÐÅÏ¢£¬°üÀ¨ÔÚ SELECT Óï¾äÖ´Ðйý³ÌÖбíÈçºÎÁ¬½ÓºÍÁ¬½ÓµÄ˳Ðò£¬±ÈÈçÎÒÃÇÏë¼ÆËã 2006 ÄêËùÓй«Ë¾µÄÏúÊ۶ÐèÒª¹ØÁª sales ......

mysql Êý¾ÝÀàÐÍvarchar ×ÓжàÉÙ

  ×òÌìÉè¼ÆÊý¾Ý¿â±íµÄʱºò£¬ÒòΪʹÓÃvarchar²úÉúÁËÒìÒ飬½á¹ûÒ»²é·¢ÏÖÎÒÃÇÁ½¸öË­¶¼Ã»´í¡£
   MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆÎª255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´
¶¨£©¡£
  
ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò ......

Óà OPTIMIZE TABLE ÓÅ»¯ mysql ±í


Óà OPTIMIZE TABLE ÓÅ»¯ mysql ±í
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:gangzhong
REPAIR TABLE `table_name` ÐÞ¸´±í OPTIMIZE TABLE `table_name` ÓÅ»¯±í myisamchk table.MYI ÐÞ¸´Ë÷Òý REPAIR TABLE ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄ±í¡£ myisamchk TABLE.MYI ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄË÷ÒýÎļþ¡£ OPTIMIZE TABLE ÓÃÓÚ»ØÊÕÏÐÖõÄÊý¾Ý ......

Mysql ³£Óú¯Êý


 
Mysql ³£Óú¯Êý
ASCII(str) 
¡¡·µ»Ø×Ö·û´®strµÄµÚÒ»¸ö×Ö·ûµÄASCIIÖµ(strÊǿմ®Ê±·µ»Ø0) 
mysql> select ASCII('2'); 
¡¡¡¡-> 50 
mysql> select ASCII(2); 
¡¡¡¡-> 50 
mysql> select ASCII('dete'); 
¡¡¡¡- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ