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

MySQLȨÏÞ¹ÜÀí



/* CSS Document */
body {
font: normal 11px auto "Trebuchet MS", verdana, arial, helvetica, sans-serif;
color: #4f6b72;
background: #e6eae9;
}
a {
color: #c75f3e;
}
table{
padding: 0;
margin: 0;
border-left: 1px solid #c1dad7;
}
caption {
padding: 0 0 5px 0;
width: 700px;
font: italic 11px "Trebuchet MS", verdana, arial, helvetica, sans-serif;
text-align: right;
}
th {
font: bold 11px "Trebuchet MS", verdana, arial, helvetica, sans-serif;
color: #4f6b72;
border-right: 1px solid #c1dad7;
border-bottom: 1px solid #c1dad7;
border-top: 1px solid #c1dad7;
letter-spacing: 2px;
text-transform: uppercase;
text-align: left;
padding: 6px 6px 6px 12px;
background: #cae8ea url(images/bg_header.jpg) no-repeat;
}
th.nobg {
border-top: 0;
border-left: 0;
border-right: 1px solid #c1dad7;
background: none;
}
td {
border-right: 1px solid #c1dad7;
border-bottom: 1px solid #c1dad7;
background: #fff;
font-size:11px;
padding: 6px 6px 6px 12px;
color: #4f6b72;
}
td.alt {
background: #f5fafa;
color: #797268;
}
th.spec {
border-left: 1px solid #c1dad7;
border-top: 0;
background: #fff url(images/bullet1.gif) no-repeat;
font: bold 10px "Trebuchet MS", verdana, arial, helvetica, sans-serif;
}
th.specalt {
border-left: 1px solid #c1dad7;
border-top: 0;
background: #f5fafa url(images/bullet2.gif) no-repeat;
font: bold 10px "Trebuchet MS", verdana, arial, helvetica, sans-serif;
color: #797268;
} MySQLÓÃGRANT,REVOKEÃüÁîÊÚÓèºÍÒƳýÓû§È¨ÏÞ
CODE:
GRANT USAGE ON * TO 'will'@'localhost' IDENTIFIED BY 'will';
MySQL´æ´¢¹ý³ÌµÄȨÏÞ¿ØÖÆ: 
½¨Á¢´æ´¢¹ý³ÌʱÕâÑù½¨Á¢:

CODE:

   
CREATE PROCEDURE p()
¡¡¡¡SQL SECURITY INVOKER


Ïà¹ØÎĵµ£º

jBPM4ÖÐÅäÖÃMySQLµÄhibernate·½ÑÔ

×î³õµÄjbpm.hibernate.cfg.xmlÖУ¬¶ÔMySQLµÄ·½ÑÔÅäÖóÉÁËorg.hibernate.dialect.MySQLDialect£¬·¢²¼Á÷³ÌµÄʱºòÓöµ½ÏÂÊö´íÎó£º
Cannot delete or update a parent row: a foreign key constraint fails
Could not synchronize database state with session
½«MySQL·½ÑÔÐÞ¸ÄΪorg.hibernate.dialect.MySQLInnoDBDialectÎÊ ......

mysqlµÄ±È½ÏÔËËã

ÔÚmenzhi007µÄblogÀï¿´µ½·Ç³£ÓÐÒâ˼µÄ¶«Î÷£ºhttp://hi.baidu.com/menzhi007/blog/item/c2e98551a18754848c54301c.html
ÔÚmysqlÊÖ²áÀ
http://www.phpchina.com/manual/mysql/functions.html#comparison-operators
MySQL°´ÕÕÒÔϹæÔò½øÐÐÊýÖµ±È½Ï£º
ÈôÓÐÒ»¸ö»òÁ½¸ö²ÎÊýΪ NULL£¬³ý·ÇNULL-safe <=> µÈËã·û£¬Ôò±È ......

MySQL µÄ´¥·¢Æ÷¡¢´æ´¢¹ý³Ì¡¢º¯Êý¡¢ÊÓͼʵÑé

    ±¾ÊµÑéÍê³ÉÈçϽá¹û£º
    0. testÊý¾Ý¿â,userinfo Óû§ÐÅÏ¢±í ºÍ userinfolog Óû§ÐÅÏ¢ÈÕÖ¾±í
    1. ½¨Á¢Ò»¸öuserinfo±íÐÂÔö¼Ç¼ʱµÄ´¥·¢Æ÷,½«ÐÂÔöÈÕÖ¾¼ÓÈëµ½userinfolog
    2. ½¨Á¢Ò»¸öÏòuserinfo±íÐÂÔö¼Ç¼µÄ´æ´¢¹ý³Ì
    3. ¸ù¾ ......

mysql root ÃÜÂëÍü¼Ç£¿£¿£¿£¿

½ñÌì¸øÐÂÀ´µÄÔ±¹¤Á¬½ÓÊý¾Ý¿â£¬ÐÞ¸ÄÁËÒ»ÏÂmysql rootÓû§µÄÃÜÂ룬ÎÒÏÂÔصÄÊÇ´ò°üµÄredMine£¬Ä¬ÈÏÃÜÂëÊÇ¿Õ£¬ÐÞ¸ÄÃÜÂëÖ®ºóÖØÆôredmine£¬phpAdmin Á´½Ó²»ÉÏmysqlÊý¾Ý¿âÁË£¬ÎÒÒ²ÐÞ¸ÄÁËphpadminÎļþ¼ÐϵÄconfig.inc.phpµÄÃÜÂ룬»¹ÊDz»ÐУ¬Ìáʾ#1130 - Host 'localhost' is not allowed to connect to this MySQL server´íÎó£¬Ã÷ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ