Çë½Ì¸÷λ:Ò»¸öMySQLÊý¾Ý¿â±í¸´ÖƺóÎÞ·¨¶ÁÈ¡µÄÎÊÌâ?
¸÷λºÃ£¬ÎÒ½«Áíһ̨µçÄÔÉϵÄMySQLÊý¾Ý¿âµÄÒ»¸ö±í¸´Öƺ󵽱¾µØ»úÉÏMySQLÊý¾Ý¿âÏàӦĿ¼(\dataĿ¼Ï£©£¬µ«ÊÇÔÚmysqlÃüÁîÌáʾ·ûÏÂÓÃshow tablesÃüÁî¿ÉÒÔÏÖʾ´æÔÚµ±Ç°±í£¬µ«ÊÇÓÃdescibe »òselect ÃüÁîʱȴ³öÏÖÎÞ·¨¶ÁÈ¡µÄÎÊÌâ,ϵͳÌáʾ¡°²»´æÔÚÕâ¸ö±í¡±µÄ´íÎó£»²»ÖªµÀÊDz»ÊDZ¾µØ»úÉÏÏàÓ¦Êý¾Ý¿âÉÏdb.optµÄÔÒò£¬ÏëÇë¸÷λ¸ßÊÖ½â¾öһϣ¬²»Ê¤¸Ðл£¡{{--
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
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 ......
ÈçÌâ¡£ÎÒÒѾ°²×°ÁËmysqlodbcÇý¶¯¡£
adodc¿Ø¼þÊôÐÔÀïÃæ£¬Á¬½Ó×ÊÔ´£¬
ÓÐ
ʹÓÃDataLinkÎļþ
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
ʹÓÃÁ¬½Ó×Ö·û´®
ÊÇÑ¡ÔñÄĸö£¿
È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿
HTML code:
http://www.connectionst ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ÏñoracleµÄ·µ»ØÖµÊÇsqlcode£¬
mysqlÓзµ»ØÖµÃ´£¿Âé·³ÄÄλ¸æËßһϡ£
°ï¶¥ MYSQL½¨ÒéÈ¥ÆäËûÊý¾Ý¿â¿ª·¢°æ¿é
mysqlÓзµ»ØÖµÃ´£¿
---
ÎÒÖªµÀmssqlÓУ¬@@error
²»ÖªµÀÓÐûÓÐÀàË ......