¸ßÊÖÇë½ø£ºlinux mysql C api£» Á¬½ÓÊý¾Ý¿âÎÊÌâ
ÔËÐл·¾³£º redhat£º 4
gcc£º 3.4
mysql£º 5.1
#include <stdio.h>
#include "/usr/include/mysql/mysql.h"
MYSQL_RES* res_ptr;
MYSQL_ROW sqlrow;
unsigned int num_rows = 0;
char ch_sql[200];
MYSQL my_conn;
int main(){
mysql_init(&my_conn);
if (!mysql_real_connect(&my_conn, "localhost", "root", "123456","test",0,NULL,CLIENT_FOUND_ROWS)) {
printf( "ERROR: connect database error\n" );
return 0;
}
printf( "Successful!\n\n" );
return 0;
}
±àÒ룺gcc sqltest.c $(mysql_config --cflags) $(mysql_config --libs) -o sqltest
ÔËÐУº./sqltest
´íÎó£ºcan't connect to localmysql server through socket '/tmp/mysql.sock'
Áí£º 1./tmp/mysql.sockȷʵ´æÔÚ£¬¶øÇÒmysqlÔËÐÐÕý³£
2.ͬһÓû§Ï£¬Í¨¹ýÃüÁîÐУºmysql -u root -p123456; ¿ÉÒÔÕý³£½øÈë
3.ÔÚ±¾µØ»úÆ÷UbuntuÏ£¬±àÒëÔËÐÐÕý³££»Î¨Ò»²»Í¬µÄ¾ÍÊÇgcc°æ±¾
¼±£¡Çë¸ßÊÖÖ
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÇëÎÊVFPÖÐÈçºÎµ÷ÓÃC/C++º¯Êý£¿
ÄãÒªµ÷ÓÃʲô¹¦Äܵĺ¯Êý£¿Òª¿´¿´VFPÖÐÓÐûÓжÔÓ¦µÄº¯Êý£¬Èç¹ûÓоÍÊ¡×ÅÔÙµ÷ÓÃÁË¡£Èç¹ûûÓУ¬¿ÉÒÔ½«C/C++º¯Êýд¸öDLL»òFLL£¬È»ºóÔÚVFPµ÷Óü´¿É¡£
Ê®¶¹Èý ÀÏʦ£¬Ôõô²ÅÄÜÐÞ¸Ä×Ô¼ºµÄ ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......