ÎʸömysqlȨÏÞÎÊÌâ
ÎÒÊÇÕâô۵ģº
ÔÚrootÕË»§µÇ¼ʱ£¬grant show view on exp04.student to exp04; ³É¹¦£¨exp04.studentÊÇexp04ϵÄview£¬ºóÃæµÄexp04ÊÇÒ»¸öÕË»§Ãû£©
È»ºóÓÃexp04ÕË»§µÇ¼£¬select * from exp04.student; ±¨´í£¬¡°select command denied¡¡¡±
Õⱨ´í¾ÍÊÇ˵exp04ûÓжÔÄǸöÊÓͼµÄȨÏÞô£¿ ÕâÊÇÎªÊ²Ã´ÄØ£¿
show view ȨÏÞ ÊÇ ÔÊÐíÄãʹÓà SHOW CREATE VIEW xxx;
SQL code:
grant select on exp04.student to exp04;
Á½¸öÔÒò
1. ÄãÐèÒª¸øexp04;µÄÊÇ select µÄȨÏÞ
2. MYSQLÓû§Õ˺ÅÊÇÓÉ Óû§Ãû@Ö÷»úÃû ¹¹³É £¬¼ì²éÒ»ÏÂÄãµÄʵ¼ÊµÇ¼Óû§Õ˺Š, show grants ; ¿´Ò»Ï¡£
http://www.diysys.comÓÐºÜ¶à¹ØÓÚphp£¬mysql£¬js£¬cssµÄÐÅÏ¢,ÊʺÏÐÂÊֺͽø½×Õß
¹þ¹þ£¬¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
û·ÖÁË£¬·¢²»ÁËÌû£¬½èÂ¥Ö÷µÄÌû×Ó£¬·¢ÏÂÎÒµÄÎÊÌ⣬MYSQLÎÒÏëͨ¹ýÁкŷµ»Ø±íÖÐijÁеÄÊý¾Ý£¬Ôõôд£¿
ÄÇÕâ¸öshow viewÊÇʲô×÷ÓÃÄØ ÎÒÔÚÖÐÎIJο¼ÊÖ²áÖÐÖ»¿´µ½Õâ¸öºÍcreate view¡¡
¶¥Ò»Ï »¹ÓÐÁ½¸öÎÊÌâδ½â¾ö~~~
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......