473,322 Members | 1,259 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

server notify client to update MySQL table

Hi,

I've made some changes to my coding..but unfortunately, there were errors when compiling it..dunno how to solve it..hope anyone can help me...the errors:

client.c: In function senddata:
client.c:147: error: incompatible implicit declaration of function UpdateStatus
client.c:37: error: previous implicit declaration of UpdateStatus was here

The code is as below:

Expand|Select|Wrap|Line Numbers
  1. #include <mysql.h>
  2. #include <stdio.h>
  3. #include <sys/types.h>
  4. #include <sys/socket.h>
  5. #include <netinet/in.h>
  6. #include <netdb.h>
  7. #include <string.h>
  8. #include <stdlib.h>
  9.  
  10. MYSQL *conn;
  11. MYSQL_RES *res;
  12. MYSQL_ROW row;
  13.  
  14. char *host = "192.168.2.11";
  15. char *user = "daily1a";
  16. char *password = "daily2006";
  17. char *database = "28882db";
  18.  
  19. int tbuf;
  20.  
  21. void error(char *msg)
  22. {
  23.     perror(msg);
  24.     exit(0);
  25. }
  26.  
  27.  
  28. int main(int argc, char *argv[]) 
  29. {
  30.  
  31.    char string1[500], query[500], transid[50];
  32.    int i, j;
  33.  
  34.    void senddata(char* SendString, char* transID);
  35.    //void senddata(char *SendString, *transID);
  36.    //void UpdateStatus(char *transID);
  37.    void UpdateStatus(char transID[100]);
  38.    void timebuffer();
  39.  
  40.    conn = mysql_init(NULL);
  41.  
  42.    j=1;
  43.  
  44.    while (j=1)
  45.    {
  46.  
  47.    /* Connect to database */
  48.    if (!mysql_real_connect(conn, host,
  49.          user, password, database, 0, NULL, 0)) {
  50.       fprintf(stderr, "%s\n", mysql_error(conn));
  51.       exit(0);
  52.    }
  53.  
  54.    /* send SQL query */
  55.    if (mysql_query(conn, "SELECT TransID, MobileNumber, StartDate, EndDate FROM Subscriptions where Status=0")) {
  56.       fprintf(stderr, "%s\n", mysql_error(conn));
  57.       exit(0);
  58.    }
  59.  
  60.    res = mysql_use_result(conn);
  61.  
  62.  
  63.    /* output fields 0, 1 and 2 of each row */
  64.    while ((row = mysql_fetch_row(res)) != NULL)
  65.    {
  66.       if (i==11)
  67.       { 
  68.     timebuffer();
  69.     i=1;
  70.  
  71.       bzero(string1, sizeof(string1)); }
  72.       else
  73.       {
  74.            //transid = row[0];
  75.           sprintf(string1,"%s,%s,%s,%s", row[0], row[1], row[2], row[3]);
  76.           printf ("%s\n",string1);
  77.           senddata(string1, transid);
  78.     i++;
  79.       }
  80.  
  81.     }
  82. }
  83.    /* Release memory used to store results and close connection */
  84.    mysql_free_result(res);
  85.    mysql_close(conn);
  86.  
  87.    return 0;
  88. }
  89.  
  90. void senddata(char* SendString, char* transID)
  91. {
  92.  
  93.   char buf[8192];
  94.   //char *update;
  95.   char message[256];
  96.   int socket_descriptor;
  97.   struct sockaddr_in pin;
  98.   struct hostent *server_host_name;
  99.  
  100.   char * host_name = "127.0.0.1";
  101.   int port = 8000;
  102.   char * str = "A default test string";
  103.   char * trans = "123456";
  104.  
  105.   str = SendString;
  106.   trans = transID;
  107.  
  108.   if ((server_host_name = gethostbyname(host_name)) == 0) {
  109.   perror("Error resolving local host\n");
  110.   exit(1);
  111.   }
  112.  
  113.   bzero(&pin, sizeof(pin));
  114.   pin.sin_family = AF_INET;
  115.   pin.sin_addr.s_addr = htonl(INADDR_ANY);
  116.   pin.sin_addr.s_addr = ((struct in_addr *)(server_host_name->h_addr))->s_addr;
  117.   pin.sin_port = htons(port);
  118.  
  119.   if ((socket_descriptor = socket(AF_INET, SOCK_STREAM, 0)) == -1) {
  120.    perror("Error opening socket\n");
  121.    exit(1);
  122.   }
  123.  
  124.   if (connect(socket_descriptor, (void *)&pin, sizeof(pin)) == -1) {
  125.    perror("Error connecting to socket\n");
  126.    exit(1);
  127.   }
  128.  
  129.    printf("Sending message %s to server...\n", str);
  130.  
  131.   if (send(socket_descriptor, str, strlen(str), 0) == -1) {
  132.    perror("Error in send\n");
  133.    exit(1);
  134.   }
  135.  
  136.    printf("...Sent message.. wait for response...\n");
  137.  
  138.   if (recv(socket_descriptor, buf, 8192, 0) == -1) {
  139.     perror("Error in receiving response from server\n");
  140.     exit(1);
  141.   }
  142.  
  143.     printf("\nResponse from server:\n\n%s\n", buf);
  144.  
  145.     UpdateStatus(TransID);
  146.     //update=buf;
  147.     //UpdateStatus(update);
  148.  
  149.    close(socket_descriptor);
  150.  
  151. }
  152.  
  153. void UpdateStatus(char transID[100])
  154. {
  155.     char query[2000];
  156.           char query1[2000];
  157.           char id;
  158.         char TransID;
  159.  
  160.     conn = mysql_init(NULL);
  161.  
  162.        /* Connect to database */
  163.        if (!mysql_real_connect(conn, host, user, password, database, 0, NULL, 0)) {
  164.           fprintf(stderr, "%s\n", mysql_error(conn));
  165.           exit(0);
  166.        }
  167.  
  168.     bzero(query1, sizeof(query1));
  169.         id = atoi(TransID);
  170.      sprintf(query1, "UPDATE Subscriptions SET Status = 1 WHERE TransID = '%s'",id);
  171.  
  172.     #ifdef DEBUG
  173.     printf("%s\n",query1);
  174.     #endif
  175.  
  176.  
  177.      /* Release memory used to store results and close connection */
  178.        mysql_free_result(res);
  179.        mysql_close(conn);
  180.  
  181. }
  182.  
  183.  
  184. void timebuffer()
  185. {
  186.     struct timeval tv;
  187.  
  188.        tv.tv_sec=tbuf;
  189.     tv.tv_usec=0;
  190.  
  191.     #ifdef TRACE
  192.     printf ("time buffer: %d\n", tv.tv_sec);
  193.     #endif
  194.  
  195.     select (0,0,0,0,&tv);
  196. }
  197.  
Supposedly, this program..after receiving response from server, this client program should update MySQL table.

Thanks
Sep 14 '06 #1
4 3143
tyreld
144 100+
Hi,

I've made some changes to my coding..but unfortunately, there were errors when compiling it..dunno how to solve it..hope anyone can help me...the errors:

client.c: In function senddata:
client.c:147: error: incompatible implicit declaration of function UpdateStatus
client.c:37: error: previous implicit declaration of UpdateStatus was here

The code is as below:

Expand|Select|Wrap|Line Numbers
  1. #include <mysql.h>
  2. #include <stdio.h>
  3. #include <sys/types.h>
  4. #include <sys/socket.h>
  5. #include <netinet/in.h>
  6. #include <netdb.h>
  7. #include <string.h>
  8. #include <stdlib.h>
  9.  
  10. MYSQL *conn;
  11. MYSQL_RES *res;
  12. MYSQL_ROW row;
  13.  
  14. char *host = "192.168.2.11";
  15. char *user = "daily1a";
  16. char *password = "daily2006";
  17. char *database = "28882db";
  18.  
  19. int tbuf;
  20.  
  21. void error(char *msg)
  22. {
  23.     perror(msg);
  24.     exit(0);
  25. }
  26.  
  27.  
  28. int main(int argc, char *argv[]) 
  29. {
  30.  
  31.    char string1[500], query[500], transid[50];
  32.    int i, j;
  33.  
  34.    void senddata(char* SendString, char* transID);
  35.    //void senddata(char *SendString, *transID);
  36.    //void UpdateStatus(char *transID);
  37.    void UpdateStatus(char transID[100]);
  38.    void timebuffer();
  39.  
  40.    conn = mysql_init(NULL);
  41.  
  42.    j=1;
  43.  
  44.    while (j=1)
  45.    {
  46.  
  47.    /* Connect to database */
  48.    if (!mysql_real_connect(conn, host,
  49.          user, password, database, 0, NULL, 0)) {
  50.       fprintf(stderr, "%s\n", mysql_error(conn));
  51.       exit(0);
  52.    }
  53.  
  54.    /* send SQL query */
  55.    if (mysql_query(conn, "SELECT TransID, MobileNumber, StartDate, EndDate FROM Subscriptions where Status=0")) {
  56.       fprintf(stderr, "%s\n", mysql_error(conn));
  57.       exit(0);
  58.    }
  59.  
  60.    res = mysql_use_result(conn);
  61.  
  62.  
  63.    /* output fields 0, 1 and 2 of each row */
  64.    while ((row = mysql_fetch_row(res)) != NULL)
  65.    {
  66.       if (i==11)
  67.       { 
  68.     timebuffer();
  69.     i=1;
  70.  
  71.       bzero(string1, sizeof(string1)); }
  72.       else
  73.       {
  74.            //transid = row[0];
  75.           sprintf(string1,"%s,%s,%s,%s", row[0], row[1], row[2], row[3]);
  76.           printf ("%s\n",string1);
  77.           senddata(string1, transid);
  78.     i++;
  79.       }
  80.  
  81.     }
  82. }
  83.    /* Release memory used to store results and close connection */
  84.    mysql_free_result(res);
  85.    mysql_close(conn);
  86.  
  87.    return 0;
  88. }
  89.  
  90. void senddata(char* SendString, char* transID)
  91. {
  92.  
  93.   char buf[8192];
  94.   //char *update;
  95.   char message[256];
  96.   int socket_descriptor;
  97.   struct sockaddr_in pin;
  98.   struct hostent *server_host_name;
  99.  
  100.   char * host_name = "127.0.0.1";
  101.   int port = 8000;
  102.   char * str = "A default test string";
  103.   char * trans = "123456";
  104.  
  105.   str = SendString;
  106.   trans = transID;
  107.  
  108.   if ((server_host_name = gethostbyname(host_name)) == 0) {
  109.   perror("Error resolving local host\n");
  110.   exit(1);
  111.   }
  112.  
  113.   bzero(&pin, sizeof(pin));
  114.   pin.sin_family = AF_INET;
  115.   pin.sin_addr.s_addr = htonl(INADDR_ANY);
  116.   pin.sin_addr.s_addr = ((struct in_addr *)(server_host_name->h_addr))->s_addr;
  117.   pin.sin_port = htons(port);
  118.  
  119.   if ((socket_descriptor = socket(AF_INET, SOCK_STREAM, 0)) == -1) {
  120.    perror("Error opening socket\n");
  121.    exit(1);
  122.   }
  123.  
  124.   if (connect(socket_descriptor, (void *)&pin, sizeof(pin)) == -1) {
  125.    perror("Error connecting to socket\n");
  126.    exit(1);
  127.   }
  128.  
  129.    printf("Sending message %s to server...\n", str);
  130.  
  131.   if (send(socket_descriptor, str, strlen(str), 0) == -1) {
  132.    perror("Error in send\n");
  133.    exit(1);
  134.   }
  135.  
  136.    printf("...Sent message.. wait for response...\n");
  137.  
  138.   if (recv(socket_descriptor, buf, 8192, 0) == -1) {
  139.     perror("Error in receiving response from server\n");
  140.     exit(1);
  141.   }
  142.  
  143.     printf("\nResponse from server:\n\n%s\n", buf);
  144.  
  145.     UpdateStatus(TransID);
  146.     //update=buf;
  147.     //UpdateStatus(update);
  148.  
  149.    close(socket_descriptor);
  150.  
  151. }
  152.  
  153. void UpdateStatus(char transID[100])
  154. {
  155.     char query[2000];
  156.           char query1[2000];
  157.           char id;
  158.         char TransID;
  159.  
  160.     conn = mysql_init(NULL);
  161.  
  162.        /* Connect to database */
  163.        if (!mysql_real_connect(conn, host, user, password, database, 0, NULL, 0)) {
  164.           fprintf(stderr, "%s\n", mysql_error(conn));
  165.           exit(0);
  166.        }
  167.  
  168.     bzero(query1, sizeof(query1));
  169.         id = atoi(TransID);
  170.      sprintf(query1, "UPDATE Subscriptions SET Status = 1 WHERE TransID = '%s'",id);
  171.  
  172.     #ifdef DEBUG
  173.     printf("%s\n",query1);
  174.     #endif
  175.  
  176.  
  177.      /* Release memory used to store results and close connection */
  178.        mysql_free_result(res);
  179.        mysql_close(conn);
  180.  
  181. }
  182.  
  183.  
  184. void timebuffer()
  185. {
  186.     struct timeval tv;
  187.  
  188.        tv.tv_sec=tbuf;
  189.     tv.tv_usec=0;
  190.  
  191.     #ifdef TRACE
  192.     printf ("time buffer: %d\n", tv.tv_sec);
  193.     #endif
  194.  
  195.     select (0,0,0,0,&tv);
  196. }
  197.  
Supposedly, this program..after receiving response from server, this client program should update MySQL table.

Thanks

The problem is that your function isn't visible until its defined in your source code. You try and call UpdateStatus from senddata, but you don't define the UpdateStatus until after senddata. You either need to rearrange where the order of your functions in your code, or even better is to let the compiler know about the existance of your functions ahead of time using function prototypes. You can either place these prototypes in seperate header file, or at the top of your source file with includes and global data.

Expand|Select|Wrap|Line Numbers
  1.  
  2. // includes and variable declerations
  3.  
  4. void senddata(char* SendString, char* transID);
  5. void UpdateStatus(char transID[100]);
  6.  
  7. // remainder of your code to follow
  8.  
  9.  
Sep 14 '06 #2
Banfa
9,065 Expert Mod 8TB
You have put in function prototypes but you have put them inside main instead of putting them at file scope
Sep 14 '06 #3
Hi All,

I already put the prototypes outside the main and i can compile it but it seems like the UpdateStatus function didnt work at all because it did not update the Status field of table as I query in that function...what's the problem with that function actually?..

Many2 thanks..
Sep 15 '06 #4
Expand|Select|Wrap|Line Numbers
  1. #include <mysql.h>
  2. #include <stdio.h>
  3. #include <sys/types.h>
  4. #include <sys/socket.h>
  5. #include <netinet/in.h>
  6. #include <netdb.h>
  7. #include <string.h>
  8. #include <stdlib.h>
  9.  
  10. MYSQL *conn;
  11. MYSQL_RES *res;
  12. MYSQL_ROW row;
  13.  
  14. char *host = "192.168.2.11";
  15. char *user = "daily2a";
  16. char *password = "daily2006";
  17. char *database = "28882db";
  18.  
  19.  
  20. int tbuf;
  21.  
  22. void senddata(char* SendString, char* transID);
  23. void UpdateStatus(char transID[1600]);
  24. void timebuffer();
  25.  
  26.  
  27. void error(char *msg)
  28. {
  29.     perror(msg);
  30.     exit(0);
  31. }
  32.  
  33.  
  34. int main(int argc, char *argv[]) 
  35. {
  36.  
  37.    char string1[500], query[500], transid[50];
  38.    int i, j;
  39.  
  40.    //void senddata(char* SendString, char* transID);
  41.    //void UpdateStatus(char transID[1600]);
  42.    //void timebuffer();
  43.  
  44.    conn = mysql_init(NULL);
  45.  
  46.  
I alter the code something like above. I can compile it but when I run it..I got this kind of message:

Expand|Select|Wrap|Line Numbers
  1. 1234567,0192426699,2006-07-17 01:00:00,2006-07-18 00:59:59
  2. Sending message 1234567,0192426699,2006-07-17 01:00:00,2006-07-18 00:59:59 to server...
  3. ...Sent message.. wait for response...
  4.  
  5. Response from server:
  6.  
  7. 1234567,0192426699,2006-07-17 01:00:00,2006-07-18 00:59:59
  8. *** glibc detected *** ./test: corrupted double-linked list: 0x08626628 ***
  9. ======= Backtrace: =========
  10. /lib/libc.so.6[0x572e71]
  11. /lib/libc.so.6[0x57408d]
  12. /lib/libc.so.6(malloc+0x74)[0x575792]
  13. /usr/lib/mysql/libmysqlclient.so.14(my_malloc+0x27)[0xa40cc7]
  14. /usr/lib/mysql/libmysqlclient.so.14(my_net_init+0x38)[0xa64a88]
  15. /usr/lib/mysql/libmysqlclient.so.14(mysql_real_connect+0x150)[0xa60c74]
  16. ./test[0x8048a74]
  17. /lib/libc.so.6(__libc_start_main+0xc6)[0x524de6]
  18. ./test[0x8048985]
  19. ======= Memory map: ========
  20. 00111000-0011a000 r-xp 00000000 fd:00 516149     /lib/libnss_files-2.3.5.so
  21. 0011a000-0011b000 r-xp 00008000 fd:00 516149     /lib/libnss_files-2.3.5.so
  22. 0011b000-0011c000 rwxp 00009000 fd:00 516149     /lib/libnss_files-2.3.5.so
  23. 004ac000-004e1000 r-xp 00000000 fd:00 649001     /lib/libssl.so.0.9.7f
  24. 004e1000-004e4000 rwxp 00035000 fd:00 649001     /lib/libssl.so.0.9.7f
  25. 004f2000-0050c000 r-xp 00000000 fd:00 648996     /lib/ld-2.3.5.so
  26. 0050c000-0050d000 r-xp 00019000 fd:00 648996     /lib/ld-2.3.5.so
  27. 0050d000-0050e000 rwxp 0001a000 fd:00 648996     /lib/ld-2.3.5.so
  28. 00510000-00634000 r-xp 00000000 fd:00 648997     /lib/libc-2.3.5.so
  29. 00634000-00636000 r-xp 00124000 fd:00 648997     /lib/libc-2.3.5.so
  30. 00636000-00638000 rwxp 00126000 fd:00 648997     /lib/libc-2.3.5.so
  31. 00638000-0063a000 rwxp 00638000 00:00 0 
  32. 0063c000-0063e000 r-xp 00000000 fd:00 517790     /lib/libdl-2.3.5.so
  33. 0063e000-0063f000 r-xp 00001000 fd:00 517790     /lib/libdl-2.3.5.so
  34. 0063f000-00640000 rwxp 00002000 fd:00 517790     /lib/libdl-2.3.5.so
  35. 00642000-00664000 r-xp 00000000 fd:00 648998     /lib/libm-2.3.5.so
  36. 00664000-00665000 r-xp 00021000 fd:00 648998     /lib/libm-2.3.5.so
  37. 00665000-00666000 rwxp 00022000 fd:00 648998     /lib/libm-2.3.5.so
  38. 00668000-0067a000 r-xp 00000000 fd:00 401321     /usr/lib/libz.so.1.2.2.2
  39. 0067a000-0067b000 rwxp 00011000 fd:00 401321     /usr/lib/libz.so.1.2.2.2
  40. 00691000-006a0000 r-xp 00000000 fd:00 516098     /lib/libresolv-2.3.5.so
  41. 006a0000-006a1000 r-xp 0000e000 fd:00 516098     /lib/libresolv-2.3.5.so
  42. 006a1000-006a2000 rwxp 0000f000 fd:00 516098     /lib/libresolv-2.3.5.so
  43. 006a2000-006a4000 rwxp 006a2000 00:00 0 
  44. 0077c000-00785000 r-xp 00000000 fd:00 516127     /lib/libgcc_s-4.0.2-20051126.so.1
  45. 00785000-00786000 rwxp 00009000 fd:00 516127     /lib/libgcc_s-4.0.2-20051126.so.1
  46. 0093f000-00940000 r-xp 0093f000 00:00 0 
  47. 009fd000-00a02000 r-xp 00000000 fd:00 649003     /lib/libcrypt-2.3.5.so
  48. 00a02000-00a03000 r-xp 00004000 fd:00 649003     /lib/libcrypt-2.3.5.so
  49. 00a03000-00a04000 rwxp 00005000 fd:00 649003     /lib/libcrypt-2.3.5.so
  50. 00a04000-00a2b000 rwxp 00a04000 00:00 0 
  51. 00a2d000-00a71000 r-xp 00000000 fd:00 582971     /usr/lib/mysql/libmysqlclient.so.14.0.0
  52. 00a71000-00b37000 rwxp 00044000 fd:00 582971     /usr/lib/mysql/libmysqlclient.so.14.0.0
  53. 00b37000-00b3a000 rwxp 00b37000 00:00 0 
  54. 00d52000-00d54000 r-xp 00000000 fd:00 648999     /lib/libcom_err.so.2.1
  55. 00d54000-00d55000 rwxp 00001000 fd:00 648999     /lib/libcom_err.so.2.1
  56. 00d8d000-00d8f000 r-xp 00000000 fd:00 398328     /usr/lib/libkrb5support.so.0.0
  57. 00d8f000-00d90000 rwxp 00001000 fd:00 398328     /usr/lib/libkrb5support.so.0.0
  58. 00d92000-00db5000 r-xp 00000000 fd:00 401325     /usr/lib/libk5crypto.so.3.0
  59. 00db5000-00db6000 rwxp 00023000 fd:00 401325     /usr/lib/libk5crypto.so.3.0
  60. 00db8000-00dca000 r-xp 00000000 fd:00 649002     /lib/libnsl-2.3.5.so
  61. 00dca000-00dcb000 r-xp 00011000 fd:00 649002     /lib/libnsl-2.3.5.so
  62. 00dcb000-00dcc000 rwxp 00012000 fd:00 649002     /lib/libnsl-2.3.5.so
  63. 00dcc000-00dce000 rwxp 00dcc000 00:00 0 
  64. 00dd0000-00de6000 r-xp 00000000 fd:00 401327     /usr/lib/libgssapi_krb5.so.2.2
  65. 00de6000-00de7000 rwxp 00016000 fd:00 401327     /usr/lib/libgssapi_krb5.so.2.2
  66. 03f9e000-0400d000 r-xp 00000000 fd:00 401326     /usr/lib/libkrb5.so.3.2
  67. 0400d000-04010000 rwxp 0006e000 fd:00 401326     /usr/lib/libkrb5.so.3.2
  68. 04012000-0410a000 r-xp 00000000 fd:00 649000     /lib/libcrypto.so.0.9.7f
  69. 0410a000-0411c000 rwxp 000f8000 fd:00 649000     /lib/libcrypto.so.0.9.7f
  70. 0411c000-0411f000 rwxp 0411c000 00:00 0 
  71. 08048000-0804a000 r-xp 00000000 08:11 327955     /home/appz/ujie/test
  72. 0804a000-0804b000 rw-p 00001000 08:11 327955     /home/appz/ujie/test
  73. 0861d000-0863e000 rw-p 0861d000 00:00 0          [heap]
  74. b7e00000-b7e21000 rw-p b7e00000 00:00 0 
  75. b7e21000-b7f00000 ---p b7e21000 00:00 0 
  76. b7f70000-b7f74000 rw-p b7f70000 00:00 0 
  77. b7f85000-b7f87000 rw-p b7f85000 00:00 0 
  78. bfe71000-bfe87000 rw-p bfe71000 00:00 0          [stack]
  79. Aborted
  80.  
  81.  
Sep 15 '06 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Google Mike | last post by:
After a lot of thought and research, and playing with FreeTDS and InlineTDS, as well as various ODBC connections, I have determined that the fastest and cheapest way to get up and going with PHP on...
0
by: Fraser Hanson | last post by:
Hello, I have a table which has a foreign key relationship with itself. I want and expect my updates to cascade (deletes definitely cascade as expected) but instead I just get error 1217:...
2
by: Filippo | last post by:
Hi, i have a problem about the CLIENT-SERVER architecture procedure. Well , i have an application in VB with ADO connection to a table in a database on a SQLSERVER 7.0 . Is possible to do that...
14
by: MLH | last post by:
I have a friend with a database application on a web server. He has invited me to attach to it so I can extract data from it periodically. I have a few questions... 1) I have a DSL connection to...
5
by: Carlo Tambuatco | last post by:
I have set up MySQL on my home computer, and I am writing a PHP enabled web site to run queries on this database. I have created a database called 'weather' on mysql that I want to access via my...
5
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
39
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.