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

CÓïÑÔÁ¬½ÓMySQLÊý¾Ý¿â

ǰ¼¸Ì칫˾ÈÃÎÒ×öCÓïÑÔºÍMySQLÊý¾Ý¿âµÄ½»»¥²Ù×÷£¬·ÑÁ˾ÅÅ£¶þ»¢Ö®Á¦Ö®ºó×ÜËã×ö³öÀ´ÁË£¬½ñÌìÌØµØ°ÑÔ´´úÂëÌù³öÀ´¹©´ó¼Òѧϰ£»ÈçÓÐÈËÏëÒª´ò°üÏîÄ¿¿ÉÒÔ¼ÓÎÒQQ260990509,×¢Ã÷¼¼Êõ½»Á÷£¬¼´¿É»ñµÃ´ò°üÖ®ºóµÄÏîÄ¿£¡
#if defined(_WIN32) || defined(_WIN64)  //ΪÁËÖ§³Öwindowsƽ̨ÉϵıàÒë
#include <windows.h>
#endif
#include <stdio.h>
#include <stdlib.h>
#include "mysql.h"
#include <winsock.h>
#include <iostream.h>
#include <string.h>
MYSQL mysql,*sock;    //¶¨ÒåÊý¾Ý¿âÁ¬½ÓµÄ¾ä±ú£¬Ëü±»ÓÃÓÚ¼¸ºõËùÓеÄMySQLº¯Êý
MYSQL_RES *res;       //²éѯ½á¹û¼¯£¬½á¹¹ÀàÐÍ
MYSQL_FIELD *fd ;     //°üº¬×Ö¶ÎÐÅÏ¢µÄ½á¹¹
MYSQL_ROW row ;       //´æ·ÅÒ»Ðвéѯ½á¹ûµÄ×Ö·û´®Êý×é
char  qbuf[300];      //´æ·Å²éѯsqlÓï¾ä×Ö·û´®
//¶¨ÒåÊý¾Ý¿â²Ù×÷µÄºê£¬Ò²¿ÉÒÔ²»¶¨ÒåÁôןóÃæÖ±½Óд½ø´úÂë
#define MAX_STRING_LENGTH    256
//¶¨ÒåÔªËØ¸öÊý
#define MAX_ELEMENT_LENGTH    33
//¶¨ÒåÏÔʾµÄÁÐÊý
#define ELEMENTS_PER_LINE    15
typedef struct 
{
    char line[MAX_STRING_LENGTH];
    char data[ELEMENTS_PER_LINE][MAX_ELEMENT_LENGTH];
}DATA;
void main()
{
    //ÉêÃ÷Êý¾Ý¿â²Ù×÷º¯Êý
    int insertData(DATA parameter);
 //´ò¿ªÖ¸¶¨Îļþ
    FILE *fp=fopen("E:\\file.txt","r");
    //´´½¨½á¹¹ÌåÀàÐÍʵÌå
 DATA data;
    memset(&data, 0x00, sizeof(DATA));
    //µÃµ½Ò»ÐÐÊý¾Ý
    fgets(data.line, MAX_STRING_LENGTH, fp);
    while (!feof(fp))
    {
        int i=0,index=0;
        for(i=0; i<ELEMENTS_PER_LINE; i++)
        {
   //·Ö¸ô×Ö·û´® °´¶ººÅ·Ö¸ô
          &nbs


Ïà¹ØÎĵµ£º

c ÓïÑÔʵÏÖ24λbmpͼƬ¼ÓÔØ£¬¶Áд£¬·Å´óËõС

Ô­ÎÄÁ´½ÓµØÖ·£ºhttp://hi.baidu.com/erfolgreich/blog/item/ce94dbad02c0c3f7faed5010.html
c ÓïÑÔʵÏÖ24λbmpͼƬ¼ÓÔØ£¬¶Áд£¬·Å´óËõС
¿ÉÓà microsoft visual c++ 6.0 ½¨Á¢Win32 Console Application ¹¤³Ì£¬Ìí¼ÓÈçÏÂ.cpp
2010-04-30 10:24
·¢ÏֺöàÈËÍøÉϲéÕÒc ÓïÑÔ°æ±¾µÄbmpͼÏñ¶ÁÈ¡£¬±£´æ£¬·Å´ó£¬ËõС³ÌÐò£¬ºÜÄÑÕÒµ ......

mysql 4.1.12


MySQL 4.1.12°²×°Æª
[Ïà¹ØÈí¼þÏÂÔØ£º]
Mysql 4.1.12-win32 -
For Windows ( Mysql 4.1.12-win32.exe ) -- Êý¾Ý¿â·þÎñ
ÏÂÔØµØÖ·£º
http://cdgwbn.downloadsky.com:8080/down/mysql-4.1.12-win32.zip
Connector/ODBC
- MySQL ODBC driver ( MyODBC-3.51.11-1-win.exe ) -- Êý¾ÝÔ´
ÏÂÔØµØÖ·£º
http://down.21sun.ne ......

MYSQL»ù´¡Ö®Á¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ìí¼ÓÓû§

Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ ......

MySQL COUNT SUM

 select
count(*) as mcount ,
left(create_time,10) as ptime ,
count(if(receive_msg is null,id,null)) as nullcount ,
count(if(receive_msg = '1',receive_msg,null)) as apfcount ,
count(if(receive_msg = '2',receive_msg,null)) as dttcount ,
count(if(receive_msg = '3',receive_ms ......

ѧÉú¹ÜÀíϵͳ(c/cpp)

#include
using namespace std;
typedef struct lnode
{
    long sno;
    char name[20];
    struct lnode *next;
}LNode, *LinkList;
LinkList InitList()
{
    LinkList head;
    head = new LNode;
 &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ