mysqlÊý¾Ý¿âµ¼ÈëºÍµ¼³öµÄÎÊÌâ
mysqlÊý¾Ý¿âµ¼ÈëºÍµ¼³öµÄÎÊÌ⣡ ´Ó±¾µØÏòÔ¶³Ì·þÎñÆ÷µ¼ÈëÊý¾Ý£¬µ¼ÈëÒ»ÇÐÕý³£ ÓÃmyeclipseµÄ¹¤¾ßDB Browser²é¿´£¬Êý¾ÝÒ²Õý³££¬ µ«ÊÇÍøÒ³·ÃÎÊʱ±¨org.apache.jasper.JasperException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query ÔÚmyeclipseÖÐÓÃhibernateÐÂÉú³ÉÔ¶³ÌÊý¾Ý¿â±íʱ£¬È´ÄÜÕý³£·ÃÎÊ ´ó¼ÒÖªµÀÕâÊÇʲôÔÒòÂð£¿
MY SQL °ï¶¥ÏÂÒýÓà mysqlÊý¾Ý¿âµ¼ÈëºÍµ¼³öµÄÎÊÌ⣡ ´Ó±¾µØÏòÔ¶³Ì·þÎñÆ÷µ¼ÈëÊý¾Ý£¬µ¼ÈëÒ»ÇÐÕý³£ ÓÃmyeclipseµÄ¹¤¾ßDB Browser²é¿´£¬Êý¾ÝÒ²Õý³££¬ µ«ÊÇÍøÒ³·ÃÎÊʱ±¨org.apache.jasper.JasperException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query ÔÚmyeclipseÖÐÓÃhibernateÐÂÉú³ÉÔ¶³ÌÊý¾Ý¿â±íʱ£¬È´ÄÜÕý³£·ÃÎÊ ´ó¼ÒÖªµÀÕâÊÇʲôÔÒòÂ𣿠MYSQL? ÕâÀïÊÇMSSQL. À´´íµØ·½ÁË,°ï¶¥.
Ïà¹ØÎÊ´ð£º
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶® ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ· ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar ºÃ¶«Î÷,ϸö¿´¿´ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿ ÃÜÂëÐ޸ķ½·¨£º 1.ÒÔϵͳ¹ ......