navicat+mysql,float¾«¶ÈÎÊÌâ
ÎÒÓõÄnavicat+mysql,ÔÚnavicatÀィÁ˸öfloat×Ö¶Î,µ«ÊÇËûÀÏÊÇËÄÉáÎåÈë,Ö»±£ÁôÕûÊý²¿·Ö.ÇëÎÊÔõôÔÚnavicatÉèÖøÃ×ֶεľ«¶È?
Èç¹ûÄãÓõÄÊÇfloat £¬Óɸ¡µãÊý±¾Éí¾Í´æÔÚ¾«¶ÈÎÊÌ⣬ËùÓÐÎÞ·¨×¼È·µÄ±íʾһЩСÊý¡£µ«Ëü¼ÆËã¿ì¡£
Èç¹ûÒª¾«È·µÄ±íʾСÊý£¬Äã¿ÉÒÔʹÓà decimal (n,m) ÕâÖÖÊý¾ÝÀàÐÍ¡£
ÓÃfloatºÍdecimal¶¼Ò»Ñù,ÎÒÓÃnavicatÖ±½Ó½¨Á¢µÄ×Ö¶Î,ÎÒ¾ÍÊÇÆæ¹ÖÈçºÎÓÃnavicatÀ´ÉèÖÃ,ÕÒ²»µ½ÄÄÀïÉèÖÃ,СÊý¶¼»á±»ËÄÉáÎåÈë³ÉÕûÊý
show create table xxx
ÌùÒ»ÏÂÄãµÄ±í½á¹¹¡£
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| r_id | varchar(8) | NO | | id | |
| r_content | varchar(200) | NO | | | |
| r_stan1 | varchar(60) | NO | | | |
| r_tscore | float(4,0) | NO | | | &nb
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......