ÏÖÔÚÓÐmySqlµÄºó׺ÃûΪsqlµÄºÃ¶àÎļþ£¬ÎļþÀïÄÚÈÝ¿´²»Ì«¶®£¬µ«ÊÇÄÜ¿´¶®µÄÊÇÿ¸öÎļþÀï¶¼ÊÇÓбí½á¹¹ºÍÕâ¸ö±íµÄÊý¾ÝµÄ¡¡
ÏÖÔÚÏë°ÑÕâÑùµÄÎļþµ¼Èëµ½sql05ÖÐÈ¥£¬¶øÇÒÏÖÔÚÔÚ05ÀïÒѾ°ÑÓÐЩ±í½¨³öÀ´ÁË£¬µ«Á½¸öÊý¾Ý¿â¶ÔÓÚͬһÕűíµÄ½á¹¹¿ÉÄܲ»Ò»Ñù£¨ÒòΪÊÇÁ½¸öÈË×öµÄ£©£¬Äܲ»ÄÜÔÚµ¼ÈëµÄʱºò¶ÔMyÀïµÄ×Ö¶ÎÓÐÑ¡ÔñÐԵĵ¼Èëµ½SQLÀï ......
²É¼¯ÏµÍ³£¬Ïë°ÑÓб仯µÄÊý¾Ý²åÈëÊý¾Ý¿â¡£
´ó¸Å1ÃëÖÓÓб仯µÄÁ¿2000¸ö×óÓÒ¡£ÊýÖµÊÇfloatÐÍ£¬Ò²¾ÍÊÇ8000¸ö×Ö½Ú¡£
ÏÖÔÚÓÐÁ½ÖÖ·½·¨£º
1 ÅúÁ¿ insert£¬Ã¿¸ö±ä»¯±£´æ1Ìõ¼Ç¼£¨²éѯ·½±ã£©£¬insert into values£¨£©£¨£©Ò»¹²2000¸ö£¬ ºÄʱ120ms¡£
2 °ÑÒ»¸ö¶þ½øÖÆÊý×éÖ±½Ó±£´æµ½longblob ×ֶΣ¬·¢ÏÖ380000¸ö×Ö½Ú£ ......
mysql±í½á¹¹
CPTL_ID 񅧏
CPTL_NAME Ãû³Æ
TYPE_ID Àà±ðID
DEPT_ID ²¿ÃÅID
KEEPER ¸ºÔðÈË
excel½á¹¹
Ãû³Æ ²¿ÃÅ ¸ºÔðÈË Àà±ð ¼Èëʱ¼ä ¼¶±ð »¹ÓÐÆäËûÏîÄ¿¡£¡£¡ ......
ÎÒÏë²éѯһЩÊý¾Ý£¬ÏÂÃæµÄÓï¾ä
select a,b from test where a=0 and b=0 union all
select a,b from test where a=1 and b=1 union all
select a,b from test where a=2 and b=2
ÎÒµÄÄ¿µÄÊÇÏëÄܰ´Ë³Ðò·µ»ØÎÒ3ÌõÓï¾äµÄ½á¹û £¬µ«ÊÇÆäÖпÉÄÜÓÐ1ÌõûÓзûºÏÌõ¼þµÄ½á¹û£¬¾Í»áµ¼Ö½á¹ûÖ»ÓÐ2Ìõ¡£
ÓÐÊ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË sql server
²»»á£¬²»Í¬¹¤¾ßÖ®¼äµÄ»·¾³±äÁ¿Ö®¼ä²»»áÏ໥ӰÏ죡
ÄãÒªÏȸ㶮£¬Ê²Ã´ÊÇ»·¾³±äÁ¿
²»»áÓ ......
±í1 content
content_id name(str)
1 ÕÅÈý
2 ÀîËÄ
±í2 illcate
illcate_id cate(str)
1 µç¹¤
2 ľ¹¤
3 ÔÓ¹¤
±í3 content_ills
id content_id illcate_id
1 1 &nbs ......