Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¶ÁÈ¡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


Ïà¹ØÎÊ´ð£º

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

¹ØÓÚMySQLɾ³ý¼Ç¼ºóIDÈçºÎÁªÏµ

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ