Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = "">
  <Resource name = "jdbc/pos" auth = "Container" ......

mysql¿Í»§¶ËÈçºÎÔËÐÐbegin...end¸´ºÏÓï¾ä

begin...end¸´ºÏÓï¾ä²»Ð´Èë´æ´¢¹ý³Ì£¬Ö±½ÓÔÚmysql¿Í»§¶ËÔËÐУ¬¿ÉÒÔÂð£¿ÓÐË­°ïæ½â´ðһϣ¬Ð»Ð»£¡
²»¿ÉÒÔ¡£

Á¬Ðø¶à¸öÓï¾äдÔÚÒ»¸öÎļþÀµ¼Èëmysql¿Í»§¶ËÊÇ¿ÉÒÔÒ»´ÎÖ´Ðеİ¡£¿ÎªÊ²Ã´begin...end¸´ºÏÓï¾ä¾Í²»¿ÉÒÔÄØ£¿

²»¿ÉÒÔ£¡

ÒýÓÃΪʲôbegin...end¸´ºÏÓï¾ä¾Í²»¿ÉÒÔÄØ£¿
ÕâÊÇMYSQLµÄÏÞÖÆ£¬Ã»Ê²Ã´ÀíÓÉ£¬Ë ......

ÇómysqlÊý¾Ý¿â±¾»ú±¸·ÝºÍ·Ö²¼Ê½±¸·ÝµÄ½â¾ö·½°¸!!

ÏîÄ¿¾­ÀíÌá³öÁËÒ»¸öÎÊÌâ,ÔõôÑùдһ¸ö½Å±¾Îļþ Äܹ»ÊµÏÖmysqlÊý¾Ý¿âµÄ±¾»ú±¸·ÝºÍÔ¶³ÌµÄ·Ö²¼Ê½±¸·Ý;¹«Ë¾ÊÇÕâÑùµÄ ±¾¹«Ë¾ÓÐÒ»¸ö·þÎñÆ÷ Äܹ»±¸·ÝÊý¾Ý¿â,»¹ÔÚÆäËû³ÇÊеÄÒ»¸ö·Ö¹«Ë¾Ò² Ūһ¸ö·þÎñÆ÷ Ó²Å̹»´ó ÔÙ±¸·ÝÊý¾Ý¿âÊý¾Ý,ÓÐwindows ºÍlinuxÁ½ÖÖϵͳµÄ Òª¿¼ÂǼ¸ÖÖÒòËØ? ÈçºÎдһ¸ö½Å±¾Îļþ¾Í¼ÈÄܱ¸·Ý±¾µØ·þÎñÆ÷£¬ ÓÖÄܱ¸·Ýµ½ ......

mysqlÖ÷¼üµÄÊý¾ÝÀàÐÍÒ»¶¨ÒªintÂð£¿

ÈçÌ⣬ÎÒ·¢ÏÖÈç¹ûÖ÷¼ü²»ÊÇintµÄ»° £¬ÎÒÓÃÅÅÐò×Ö¶Îmenu_order(ÓõÄÊÇÀàÐÍ) ɸѡ³öÀ´µÄ½á¹û ²»ÊÇÕýÈ·µÄ˳Ðò¡£

ºÃ£¬Ð»Ð»Á½Î»¡£ÎÒÒѾ­×Ô¼ºÕÒ³öÎÊÌâÁË¡£

Ô­À´mysql²éѯsqlÓï¾äµÄ´óСдÃô¸Ð ÊDz»Êǰ¡£¿
......

mysql¶Ïµç.myd¶ªÊ§

    windows»·¾³£¬¶ÏµçÖØÆôºó³öÏÖmysqlÒ»¸ö±íµÄ.mydÎļþ(ÇÒ³Ætab_test.myd)²»¼ûÁË¡£
    windowsÖØÆôʱ£¬ÆÁÄ»ÉÏ´ÅÅ̼ì²âÐÅÏ¢ÓÐtab_test.myd×ÖÑù¡£
    ¶Ïµçʱ³öÏÖ½ÏÆµ·±¡£

    ÇëÎÊÊÇʲôԭÒòÒýÆð£¬ÊÇselect,delete,insert¡£¡£¡£ÄÄÖÖsqlÓï¾äÒýÆðµÄ¿ÉÄÜÐÔ×î´ó
&nbs ......

ÔÚÏߵȣºphp²åÈëmysql´íÎó

insert into dcr_data(cardid,zcid,czmoney,fcbl,tc) values('m10515993755','尛ؼ羙','0','1','0')

mysqlÌáʾ´íÎóΪ£ºData too long for column 'zcid' at row 1

ÎҵıíÓÃÁËgb2312 µ«ÓÃgbkҲûÓà utf8ҲûÓÃ

Ϊʲô£¿

ÁíÍâ zcid ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [135] [136] [137] [138] 139 [140] [141] [142] [143] [144]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ