Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 adminÔõôҲûÓн¨¿âµÄȨÏÞ£¿

mysql adminÔõôҲûÓн¨¿âµÄȨÏÞ£¿
Ôõô´´½¨Êý¾Ý¿â
¹À¼ÆÄãÊÇ´ÓÆäËü»úÆ÷ÉϵǼµÄ¡£

£Í£Ù£Ó£Ñ£ÌµÄÕ˺ÅÓÉ username@hostname À´×é³É£¬Ò²¾ÍÊÇ¾Í usera@localhost ºÍ usera@cctv.com ËäÈ»Óû§ÃûÒ»Ñù£¬µ«ËüÃÇÊDz»Í¬µÄÕ˺š£

Äã¿ÉÒÔ´Ó±¾»úÒԣңϣϣԵǼºó grant all on *.* to root@% À´ÊÚȨ

¹ØÓڣͣ٣ӣѣ ......

mysqlµÄdate_formatº¯ÊýÎÊÌâ

sql = "select a.vou_no, a.client_id, b.name as client_name, c.user_name, a.record_date "+
"from t_flow_card_master a, t_client b, t_user c " +
"where a.client_id=b.client_id and a.recorder_id=c.user_id and a.vou_sts='N' and date_format(a.record_date, ' ......

MYSQL¹ØÓÚ¶ÔXMLµÄÖ§³ÖÌáÎÊ

ÎÒÏëÇë½ÌϹØÓÚÔÚMYSQL½Å±¾ÖУ¬¶ÔXMLÖнáµãÊôÐԵIJéѯ¡¢Ð޸ġ¢É¾³ý£¬
ÄÄλÈÊÐÖ¿ÉÒÔÌṩ¸öÑùÀý²Î¿¼¡£Ð»Ð»
ÀýÈ磺
set @xmldoc='<config><dblist timeout="7"></dblist><logpige><logfile dir="c:\data" getnum="10000" profromtime="0" prototime=&q ......

¹ØÓÚVC Ó¦ÓÃMYSQL C API µÄÎÊÌâ¡£

ÎÒÊǸտªÊ¼Ñ§Ï°¡£ÏëÓÃVC6.0Á¬½Ó MYSQL¡£ ÎÊÌâÊÇ
1.ÎÒÏÂÔØÁËlibmysql£¬ÔÚÒ»¸öLIBÎļþ¼ÐÖÐÓÐÁ½¸öÎļþ¼Ð£¬·Ö±ðÊÇdebug,opt. Àï±ß·Ö±ð¶¼ÓÐ libmysql.dll£¬libmysql.lib£¬ÎÒµÄÎÊÌâÊÇ£¬Õâ2Á½¸öÎļþÓÃVCÔõôµ¼ÈëµÄ£¿±ÈÈçÏÖÔÚÕâ2Á½¸öÎļþÔÚÏîÄ¿¸ùĿ¼Ï¡£Â·¾¶Ôõôд£¿

2.ÎÒ×Ô¼ºÃþË÷×ŵ¼ÈëÄÇÁ©¸öÎļþ£¨¹À¼ÆÊÇ´íÁË£©¡£µ±È» ......

Çó½ÌÒ»¸öphpÏòmysql²åÈëʱ¼äµÄÎÊÌâ

ÎÒ¿ÉÒÔ´Óxml¶Áµ½Ò»¸öʱ¼ä£º1235716200000
ËÆºõÓõÄdateµÄʱºòÐèÒª³ý1000
ËùÒÔÎÒÓÃ$start_time = $post->getElementsByTagName("StartTime")->item(0)->nodeValue/1000;

È»ºó$query="INSERT INTO `test` (`start_time`) VALUES (".$start_time.")";
½á¹û±¨´íYou hav ......

Èç¹û¶à¸ö PHP Ò³Ãæ¹²Ïí mysql ²éѯ½á¹û£¿

±ÈÈ磺

ÎÒÔÚ  1.php ÖнøÐÐÊý¾Ý²éѯ£¬±£´æµ½Êý×é  $data  ÖС£


ÎÒÔÚ  2.php 3.php 4.php 5.php µÈ¶à¸ö PHP ÎļþÖÐÐèҪʹÓÃÕâ¸ö²éѯ½á¹û£¬
Èç¹ûÔÚÿ¸öÎļþÖж¼ÔÚÖ´ÐÐÒ»´Î²éѯ£¬¸Ð¾õÌ«ÀË·Ñ×ÊÔ´ÁË£¬ÓÐʲô±È½ÏºÃµÄ·½·¨½â¾öÕâ¸öÎÊÌâÂð£¿


ÕâÑùµÄ»°£¬ÄǾͱ£´æÔÚÁÙʱ»á»°sessio ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [75] [76] [77] [78] 79 [80] [81] [82] [83] [84]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ