mysql °²×°
ÔÚwindowsϰ²×°Ò»¸öMySQLµÄ¶þ½øÖÆ·Ö·¢Ê®·ÖµÄÈÝÒס£Ê×ÏÈÄã±ØÐëͨ¹ýǰÎÄËùÊöµÄ·½·¨»ñµÃÏàÓ¦µÄÈí¼þ°ü£¬ÆäÎļþÃûÓ¦¸ÃÀàËÆÓÚmysql-x.xx.xx-beta-win.zip»òÕßmysql-x.xx.xx-win.zip¡£Èç¹ûÄãÏÂÔØµÄÊǹ²Ïí°æ±¾£¬Ó¦¸ÃÀàËÆÓÚmysq-shareware-x.xx.xx-win.zip¡£ÓÉÓÚMySQLµÄwindows°æ±¾±ØÐÞ¸¶·ÑʹÓ㬹²Ïí°æ±¾ÓÐÉÙÐí¹¦ÄÜÏÞÖÆ£¬Òò´ËÈç¹ûÖ»ÊÇÓÃÀ´Ñ§Ï°Êý¾Ý¿âµÄʹÓ㬽¨Òé°²×°²âÊÔ°æ±¾¡£°²×°MySQLÊ×ÏÈÔÚij¸ö¿ÕĿ¼½âѹËõ°²×°Îļþ£¬²¢ÇÒÔËÐÐSetup.exe³ÌÐò¡£È±Ê¡µØ£¬MySQL-Win32±»ÅäÖð²×°ÔÚ¡°C:\mysql¡±¡£Èç¹ûÄãÏëÒªÔÚÆäËüµØ·½°²×°MySQL£¬ÔÚ¡°C:\mysql¡±°²×°Ëü£¬È»ºó½«°²×°ÒƵ½ÄãÏëÒªµÄµØ·½¡£»òÕßÄãÒ²¿ÉÒÔÔÚ°²×°Ê±Ñ¡ÔñÆäËüĿ¼¡£*******Èç¹ûÄãÕæµÄÒÆ×ßMySQL£¬Äã¿ÉÄÜÐèҪͨ¹ýÌṩѡÏî¸ømysqld¸æËßmysqldÐèÒªµÄ²ÎÊýÐÅÏ¢£¬ÓÈÆäÊÇÊý¾Ý¿âĿ¼µÄλÖá£Ê¹ÓÃC:\mysql\bin\mysqld --helpÏÔʾËùÓеIJÎÊýÑ¡ÏîµÄÐÅÏ¢¡£ÀýÈ磬Èç¹ûÄãÒÆ¶¯MySQL·Ö·¢µ½¡°D:\programs\mysql¡±£¬Äã¿ÉÒÔÓÃD:\programs\mysql\bin\mysqld --basedir D:\programs\mysqlÀ´Æô¶¯mysqld¡£µ±È»ÓÐʱÄã²»±ØÕâô×ö£¬·þÎñÆ÷Ò²¿ÉÒÔÕý³£ÔË×÷£¬²»¹ýÕâÊÇÒ»¸ö±£Ïյķ½·¨¡£ÓõǼǵÄMySQL°æ±¾,ÄãÒ²¿ÉÒÔ´´½¨Ò»¸ö¡°C:\my.cnf¡±ÎļþÀ´±£´æÓÃÓÚMySQL·þÎñÆ÷µÄÈκÎȱʡѡÏî¡£¿½±´Îļþ¡°\mysql\my-example.cnf¡±µ½¡°C:\my.cnf¡±²¢ÇÒ±à¼ËüÀ´ÊÊÓÃÓÚÄãµÄ°²×°¡£×¢ÒâÄãÓ¦¸ÃÓÃ"/"¶ø²»ÊÇ"\"Ö¸¶¨ËùÓеÄ·¾¶¡£Èç¹ûÄãʹÓá°\¡±£¬ÄãÐèÒªÖ¸¶¨Á½´Î(¡°\\¡±)£¬ÒòΪÔÚMySQLÖС°\¡±ÊÇתÒå×Ö·û¡£********
--------------------
****ÄÚµÄÄÚÈݲ»ÖªµÀʲôÒâ˼ѽ £¿
{{
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......