¶ÁÈ¡mysqlÊý¾ÝµÄÎÊÌâ
mysqlÀïÓÐÒ»ÕűíµÄÒ»¸öÈÕÆÚ×Ö¶Îdate£¬µ«ÊÇÓõÄint¡£ ÎÒÓÃÈçÏÂsqlÓï¾ä¶Á³öÀ´Ìî³äµ½datasetÀÎÒÒª°ÑÕâ¸öֵת»»³ÉdatetimeÀàÐÍ£¬µ«ÊÇʧ°Ü¡£SQL code: select from_UNIXTIME(date) from table1 C# code: //ÏÈÌî³äDataSet ds DateTime dt = Convert.ToDateTime(ds.Tables[0].Rows[0]["date"]); ³ÌÐò±¨´í£ºÎÞ·¨½«ÀàÐÍΪ¡°System.Byte[]¡±µÄ¶ÔÏóÇ¿ÖÆ×ª»»ÎªÀàÐÍ¡°System.IConvertible¡±¡£
´Ó¿âÖжÁ³öÀ´µÄ¶«Î÷ÒªÏÔʾת»»Ò»ÏÂÀàÐÍÔÙʹÓà ¸ñʽÎÊÌâ ¿´¿´ds.Tables[0].Rows[0]["date"]Êý¾Ý C# code: DateTime dt = Convert.ToDateTime(ds.Tables[0].Rows[0]["date"].ToString()); ÒªtostringÔÙת»»Îªdatetime Ö÷ÒªÊÇ¿´Êý¾ÝµÄ¸ñʽ ÄãÄܲ»Äܷż¸¸öÊý¾Ý³öÀ´¿´¿´Ñ½? 2009101? 20091001?? ѧϰһÏ ........ ²Î¿¼£º http://school.itzcn.com/special-spid-51.html ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£ÒýÓà ¸ñʽÎÊÌâ ¿´¿´ds.Tables[0].Rows[0]["date"]Êý¾Ý object£¬byte[19] ±ÈÈç2010-02-07 10:20:00 ÒýÓà C# codeDateTime dt= Convert.ToDateTi
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8 ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
ÔÌûÇë¿´ http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601 ×ܽáϾÍÊÇ apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......