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

mysql ²åÈë¶àÌõÊý¾Ý?

Ïë×ö'¶ÌÏûÏ¢'µÄϵͳÏûÏ¢¹¦ÄÜ(ÊôÓÚȺ·¢°É!)

µ±¹ÜÀíÔ±ÔÚºǫ́·¢ËÍϵͳÏûÏ¢µÄʱºò ËùÓлáÔ±½«ÊÕµ½´ËÏûÏ¢!

ÎÊÌâ:

ÈçºÎÏòÊý¾Ý·¢¸øËùÓлáÔ±?(sqlÓï¾äÈçºÎд?)

Ó¦ÓòåÈëÑ­»·Ã´?
PHP code:

²éѯËùÓÐÓû§ ½øÐÐÑ­»·
while($rs=mysql_fetch_array($result)){
insert into info (ÄÚÈÝ,·¢ËÍÈË,$rs[½ÓÊÕÈË],ʱ¼ä) values ('ÄÚÈÝ','·¢ËÍÈË',$rs[½ÓÊÕÈË],'ʱ¼ä')";
}


ÓÐûÓÐÆäËû¸üºÃµÄ·½·¨?

Çó½Ì¸ßÊÖ
ÊÇÏëÕâÑùЧ¹ûÂð£¿

insert into info (ÄÚÈÝ,·¢ËÍÈË,$rs[½ÓÊÕÈË],ʱ¼ä)
select 'ÄÚÈÝ','·¢ËÍÈË',»áÔ±×Ö¶Î,'ʱ¼ä' from »áÔ±±í;

ÎÒÏëʵÏÖȺ·¢Ð§¹û !

ÎÒÔÚºǫ́·¢ËÍϵͳÏûÏ¢,ËùÓÐÓû§¶¼»áÊÕµ½.SQLÓï¾ä¸ÃÔõôд?

ÎÒûÓÐÉè¼Æ¹ý ²»ÖªÊý¾Ý¿âÔõôÉè¼Æ

ÎÒ³õ²½Ïëµ½µÄÊÇÓ¦ÓÃÑ­»·²åÈë(Ç°ÃæµÄ·½·¨)

°ÑÏûÏ¢²åÈëµ½ÏûÏ¢±í Óû§Óû§²éѯµÄʱºò¸ù¾ÝÓÃID²éѯ!

²»ÖªÓÐûÓÐÆäËû¸üºÃµÄ·½·¨?

ѰÇó˼·

Â¥Ö÷׿±ÁË¡£

ÒýÓÃÎÒÔÚºǫ́·¢ËÍϵͳÏûÏ¢,ËùÓÐÓû§¶¼»áÊÕµ½.SQLÓï¾ä¸ÃÔõôд?

ÎÒûÓÐÉè¼Æ¹ý ²»ÖªÊý¾Ý¿âÔõôÉè¼Æ


Èç¹ûÕâÑù£¬ºÜ¸´ÔÓ¡£ ÄãÐèÒªÏȶ¨Òå³öÄãµÄ±í£¬È»ºóÄã×Ô¼ºÐèÒªÇå³þµÄÖªµÀÄãÏëÔÚÄĸö±í²åÈëʲôÑùµÄÊý¾Ý¡£
·ñÔòÈç¹ûÄãµÄÎÊÌâÊÇ¡°Èç¹ûÉè¼ÆÒ»¸ö¡¶ÏûÏ¢¹ÜÀíϵͳ¡·²¢ÊµÏÖºǫ́·¢ËÍϵͳÏûÏ¢,ËùÓÐÓû§¶¼»áÊÕµ½¡° Õâ¸ö¿ÎÌâ¾Í±È½Ï´óÁË


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ