Mysql½ø»¯ÂÛ1
1.Ëü¿ÉÒÔ±»·ÖΪÈýÀࣺÊý×ÖÀàÐÍÈÕÆÚÀàºÍʱ¼äÀàÐÍ£¬×Ö·û´®ÀàÐÍ¡£
ÁÐÀàÐÍÓÃÓÚÃèÊö:
M£ºÖ¸³ö×î´óµÄÏÔʾ³ß´ç¡£×î´óµÄºÏ·¨ÏÔʾ³ß´çΪ255.
D£ºÊÊÓÃÓÚ¸¡µãÀàÐͲ¢Ö®³õ¸úËæÔÚÊ®½øÖÆСÊýµãºóµÄÊýÂëµÄÊýÁ¿¡£×î´óµÄ¿ÉÄÜÖµÊÇ30£¬µ«ÊDz»Ó¦´óÓÚM.
2.·½À¨ºÅ("[","]")Ö¸³ö¿ÉÑ¡µÄÀàÐÍÐÞÊηûµÄ²¿·Ö£®
£ªÈôÖ¸¶¨ÁËÁÐÀàÐÍΪZEROFILL,MYSQL½«¸ÃÁÐ×Ô¶¯µØÔö¼ÓUNSIGNEDÊôÐÔ¡£
TINYINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öºÜСµÄÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-128µ½127£¬ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½255.
SMALLINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öСÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-32768µ½32767,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½65535.
MEDIUMINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öÖеȴóСÕûÊý.ÓзûºÅ¶î·¶Î§ÊÇ-8388608µ½2147483647,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½16777215.
INT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öÕý³£´óСÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-2147483648µ½2147483647,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½4294967295.
INTEGER[(M)][UNSIGNED][ZEROFILL]:
ÕâÊÇÒ»¸öintµÄͬÒå´Ê¡£¿ÉÒÔ˵ÊÇINTµÄ¼ò³Æ.
BIGINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸ö´óÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-9223372036857754775808µ½9223372036854775807,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½18446744073709551615¡£
FLOAT[(M,D)][ZEROFILL]:Ò»¸öС£¨µ¥¾«ÃÜ£©¸¡µãÊý×Ö¡£²»ÄÜÎÞ·ûºÅ.ÔÊÐíµÄÖµÊÇ-3.402823466E+38µ½-1.175494351E-38£¬0 ºÍ1.175494351E-38µ½3.402823466E+38¡£MÊÇÏÔʾ¿í¶È¶øDÊÇСÊýµÄλÊý¡£Ã»ÓвÎÊýµÄFLOAT»òÓÐ<24µÄÒ»¸ö²ÎÊý±íʾһ¸öµ¥¾«Ãܸ¡µãÊý×Ö¡£
DOUBLE[(M,D)][ZEROFILL]:Ò»¸öÕý³£´óС£¨Ë«¾«ÃÜ£©¸¡µãÊý×Ö¡£²»ÄÜÎÞ·ûºÅ¡£ÔÊÐíµÄÖµÊÇ-1.7976931348623157E+308µ½-2.2250738585072014E-308¡¢ 0ºÍ2.2250738585072014E-308µ½1.7976931348623157E+308¡£MÊÇÏÔʾ¿í¶È¶øDÊÇСÊýλÊý¡£Ã»ÓÐÒ»¸ö²ÎÊýµÄDOUBLE»òFLOAT(X)£¨25 < = X < = 53£©´ú±íÒ»¸öË«¾«Ãܸ¡µãÊý×Ö¡£
DOUBLE PRECISION[(M,D)][ZEROFILL];REAL[(M,D)][ZEROFILL]:ÕâЩ¶¼ÊÇDOUBLEµÄͬÒå´Ê.
DECIMAL[(M[,D])][ZEROFILL]:Ò»¸öδѹËõ(unpack)µÄ¸¡µãÊý×Ö¡£²»ÄÜÎÞ·ûºÅ¡£ÐÐΪÈçͬһ¸öCHARÁУº“δѹËõ”Òâζ×ÅÊý×Ö×÷Ϊһ¸ö×Ö·û´®±»´æ´¢£¬ÖµµÄÿһλʹÓÃÒ»¸ö×Ö·û¡£Ð¡Êýµã£¬²¢ÇÒ¶ÔÓÚ¸ºÊý£¬“-”·ûºÅ²»ÔÙMÖмÆËã¡£Èç¹ûDÊÇ0£¬Öµ½«Ã»ÓÐСÊýµã»òÕßСÊý²¿·Ö¡£DECIMALÖµµÄ×î´ó·¶Î§ÓëDOUBLEÏàͬ£¬µ«ÊǶÔÒ»¸ö¸ø¶¨µÄDECIMALÁУ¬Êµ¼ÊµÄ·¶Î§¿ÉÒÔͨ¹ýMºÍDµÄÑ¡Ôñ±»ÏÞÖÆ¡£Èç¹ûD±»Ê¡ÂÔ£¬Ëü±»ÉèÖÃΪ0¡£Èç¹ûM±»Ê¡µô£¬Ëü±»ÉèÖÃΪ10¡£ÔÚMysql3.22À
Ïà¹ØÎĵµ£º
http://blog.csdn.net/iamstillzhang/archive/2007/04/01/1548377.aspx
ÓÃmysqlÔ´Âë½øÐÐSQL½âÎö
MysqlÊÇͨ¹ýyacc½øÐÐSQLÓï¾ä½âÎöµÄ£¬ÕâÀï½éÉÜÒ»ÏÂÈçºÎʹÓÃmysqlµÄÔ´Âë½øÐÐSQLÓï¾ä½âÎö¡£ÓÉÓÚMysqlµÄÔ´´úÂë×¢ÊͱȽÏÉÙ£¬¶øÇÒȱÉÙ×ÊÁÏ£¬ËùÓÐЩµØ·½Ñо¿²»¹»ÉîÈë¡£
1 Filed½éÉÜ
MY ......
×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳ(jboss)°²×°Î¬»¤ÊÖ²á
1.Èí¼þ¸ÅÊö
1.1×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳÊÇ»ùÓÚASPÔËӪģʽµÄÆóÒµÔËÓª¹ÜÀíƽ̨ϵͳ£¬ÓɶÀÁ¢µÄÓ¦Ó÷þÎñÆ÷·Ö±ðÌṩͳһÔËÓª¹ÜÀí¹¦ÄÜ¡¢
¸÷²úÆ·ÔËӪϵͳµÄ¹¦ÄÜ¡£
1.2¿ª·¢ÓïÑÔ
±¾ÏµÍ³²ÉÓÃJ2EE¼¼Êõ¼Ü¹¹£¬Ê¹Óõ½java, xml, xsl£¬javascript£¬htmlµÈ¸÷Ïî¼¼Êõ£¬Êý¾Ý¿âÊ¹Ó ......
²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½ÓÉ¿Í»§¶Ë·¢À´µÄSQLÓï¾äºó£¬Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ø ......
<!--#include file="zheboconn.asp"-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>aspºÍmysql·ÖÒ³´úÂë</title>
<style type="text/css">
<!--
.STYLE3 {
fon ......