ΪMYsqlÌí¼Ó±í¡¢ÁÐ×¢ÊÍ
ÔÚOracleÖÐΪ±í¡¢ÁÐÌí¼Ó×¢ÊÍÀàËÆÈçÏ£º --Ìí¼ÓÊý¾Ý¿â±í×¢ÊÍ comment on table TB_COMMUNITY is 'ÉçÇø½á¹¹±í'; -- Ìí¼ÓÁÐ×¢ÊÍ comment on column TB_COMMUNITY.COMMUNITY_CODE is 'ÉçÇø»ò½ÖµÀ»òÐ¡Çø±àºÅ'; ÄÇôÔÚmysqlÖÐÓëÆä¶ÔÓ¦µÄ±íÁÐ×¢Ê͵ÄÌí¼ÓÊÇÈçºÎдµÄÄØ£¿£¿£¿
ß×£¬Ã´È˻شð£¿ÕâºÜÄÑô£¿ÓôÃÆ£¡ÎÒµ½GGÉϹ·È¥¡£ ÏÂÒ»¸ö¿Í»§¶Ë°¡ ÎÒÓõÄÊÇSQLyog Enterprise£¬ FIELD TYPE COLLATION NULL KEY DEFAULT Extra PRIVILEGES COMMENT ÔÚÕâ¸öÀïÃæÌí¼Ó×¢ÊÍÒýÓà ÏÂÒ»¸ö¿Í»§¶Ë°¡ ÎÒÓõÄÊÇSQLyog Enterprise£¬ FIELD TYPE COLLATION NULL KEY DEFAULT Extra PRIVILEGESCOMMENT ÔÚÕâ¸öÀïÃæÌí¼Ó×¢ÊÍ ÎÒÏÖÔÚ×öÒ»¸öÄܽ«±í¡¢Êý¾Ý´ÓOracleÇ¨ÒÆµ½mysqlÖУ¬ËùÒÔ²ÅÐèҪдcomment¡£ ÎÒÖªµÀÔÚ´´½¨±íʱÄÜдÈëcomment£¬µ«ÊǸöÈ˸оõÕâÑùµÄ»°¾ÍÓеã»ìÂÒ£¬ËùÒÔÐèÒª·Ö¿ªÐ´¡£ °ïÄãup ²»ÖªµÀÕâ¸ö¡°Êý¾Ý´ÓOracleÇ¨ÒÆµ½mysqlÖС± 9.5. ×¢ÊÍÓï·¨ http://dev.mysql.com/doc/refman/5.1/zh/language-structure.html#comments 9.5. ×¢ÊÍÓï·¨ MySQL·þÎñÆ÷Ö§³Ö3ÖÖ×¢ÊÍ·ç¸ñ£º · ´Ó¡®#¡¯×Ö·û´ÓÐÐβ¡£ · ´Ó¡®-- ¡¯ÐòÁе½ÐÐβ¡£Çë×¢Òâ¡®-- ¡¯(Ë«ÆÆÕÛºÅ)×¢ÊÍ·ç¸ñÒªÇóµÚ2¸öÆÆÕۺźóÃæÖÁÉÙ¸úÒ»¸ö¿Õ¸ñ·û(ÀýÈç¿Õ¸ñ¡¢tab¡¢»»ÐзûµÈµÈ)¡£¸ÃÓï·¨Óë±ê×¼SQL×¢ÊÍÓï·¨ÉÔÓв»Í¬£¬ºóÕß½«ÔÚ1.8.5.7, ¡°¡®--¡¯×÷ΪעÊÍÆðʼ±ê¼Ç¡±
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿ ÃÜÂëÐ޸ķ½·¨£º 1.ÒÔϵͳ¹ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿ PHP code: <?php $str="select * from product wh ......