Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â³öÏÖÂÒÂ룡£¡£¡

rt-----------

ÕûºÏÁËs2sh ¿ò¼Ü£¬jsp Ò³Ãæ ±àÂëgb2312£¬mysql±àÂëutf-8£»


Ò³Ãæ·¢À´µÄÐÅϢͨ¹ýÈçÏÂתÂ룬ÔÚºǫ́´òÓ¡Äܳɹ¦³öÀ´ÁËÖÐÎÄ¡£

  rolememo = new String(rolememo.getBytes("ISO8859-1"),"gb2312");
---------------------------------------------------- ......

ÇóÒ»¸ömysql ×ֶβð·ÖËÑË÷sqlÓï¾ä

±êÌâ½²²»Çå³þ¹þ¡­¡­¡­¡­


Êý¾Ý´æ´¢¸ñʽ

×Ö¶ÎÃû      Êý¾Ý
year      2009
month      11
days      |2:40|3:23|4:21|  ......    (½âÊÍ,Ç°ÃæÊÇÈÕÆÚ£¬ºóÃæÊǼ۸ñ  ÈÕÆÚ:¼Û¸ñ)

ÎÒÏë²»³öÆäËûµÄÊý¾Ý½á¹¹Á ......

¹ØÓÚÔÚDOS(CMD)ÖÐʹÓÃmysqlÃüÁî²éѯµÄһЩÎÊÌ⣬

ÎÒÔÚCMDÀïÃæÐ´ÁËSQLÓï¾äÁË£¬ÎªÊ²Ã´ÎÒÒ»°´ÏÂenter¼üµÄʱºò£¬ÄÇô¼´Ê¹°´ÁËɾ³ý¼ü£¬È´ÎÞ·¨°ÑÉÏÒ»ÐеĸøÉ¾³ý,ÈçºÎ²Å¿ÉÒÔ½«ÉÏÒ»ÐÐɾ³ý¡£
ÎÒÒѾ­Ð´Á˵ÄÒѾ­Ö´ÐÐÁ˵ÄÔõôÐ޸İ¡¡£
ÊDz»ÊÇCMDÖÐ ÓÐÊ²Ã´ÌØ±ðµÄʹÓ÷½·¨£¬mysqlÓõ½µÄCMDµÄС¼¼ÇÉÓÐÄÄЩ°¡¡£
ûÓа취ɾ³ýÉÏÒ»Ðеġ£

mysql> select test from ssad
& ......

¸ßÊִͽ̡£aspºÍmysqlÁ¬½ÓµÄÎÊÌ⣡

ÎÒдµÄÓï¾äÈçÏ£º
<table border="2"> <tr> <td>
<%   
Dim sConnection,  Conn , objRS   
 
'SERVERΪÊý¾Ý¿âÖ÷»úÃû£¨±¾µØÖ÷»úÓÃlocalhost,Ô¶³ÌÓÃIPµØÖ·£©£»DATABASEΪÊý¾Ý¿âÃû£»UIDΪÓû§Ãû£»PASSWORDΪÃÜÂë   
......

aspÎÞ·¨¶Á³ömysqlÊý¾Ý¿âµÄtext,longtextµÈ×Ö¶ÎÄÚÈÝ

Á¬½Ó×Ö·û´®
<%
Set Conn=Server.CreateObject("adodb.Connection")
Str="driver={mysql odbc 5.1 driver};database=web;server=localhost;uid=root;password=root;OPTION=3;stmt=SET NAMES GB2312"
conn.cursorlocation=3
Conn.Open Str
%>
Êä³ö1
<%
Set Rs = ......

Linux mysql ÎÊÌâ

bash-2.05b# gcc -o oo oo.c -I /usr/local/mysql/include -L /usr/local/mysql/lib
/tmp/ccEQAkDG.o(.text+0x1f): In function `main':
: undefined reference to `SQLAllocHandle'
/tmp/ccEQAkDG.o(.text+0x58): In function `main':
: undefined reference to `SQLSetEnvAttr'
/tmp/ccEQ ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [162] [163] [164] [165] 166 [167] [168] [169] [170] [171]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ