当前位置:Linux教程 - Mysql - gcc批量建mysql库表的东东我写的大家欣赏?

gcc批量建mysql库表的东东我写的大家欣赏?



         gcc批量建mysql库表的东东我写的大家欣赏?
    file 1
    my.c

    //--------------------------------------------------------
    // MySQL Database Create 1/13/2001. Netkiller Chen
    //--------------------------------------------------------
    #include
    #include
    main()
    {
    char host[16]; //mysql host address.
    char sid[15]; //root user name.
    char pwd[15]; //root password.

    /* char *table_file[]={
    \"gsxx\",
    \"bcxx\",
    \"fgxx\",
    \"hmbxx\",
    \"ltxx\",
    NULL
    };*/
    //char *mysql;
    char mydatabase[256];
    char mysqltable[256];
    int i;
    int max_table_num;
    int db,status;
    i=0;
    max_table_num=4; //max_table_num

    system(\"clear\");
    showme();printf(\"\\n\");

    printf(\"MySQL host:\");scanf(\"%s\",host);
    printf(\"Root user:\");scanf(\"%s\",sid);
    printf(\"Password:\");scanf(\"%s\",pwd);
    printf(\"Loading........\\n\\n\");
    while(table_file[i]){
    sprintf(mydatabase,\"echo \\\"create database %s\\\"|mysql -h%s -u%s -p%s\",table_file[i],host,sid,pwd);
    sprintf(mysqltable,\"mysql -h%s -u%s -p%s %s<%s.sql\",host,sid,pwd,table_file[i],table_file[i]);
    db=system(mydatabase);
    status=system(mysqltable);
    // printf(\"%s\\n%s\",mydatabase,mysqltable);
    printf(table_file[i]);
    //printf(\"%d\",status);
    if(db==0 && status==0){
    printf(\"\\t\\t\\tInstall [ OK ]\\n\");
    }else{
    printf(\"\\t\\t\\tInstall [ :( ]\\n\");
    }
    i++;
    }
    address();
    }


    //------------------- Function ------------------
    showme()
    {
    printf(\"-------------------------------------------------------------------\\n\");
    printf(\"\\tI am Netkiller Chen.\\n\");
    printf(\"\\tI am a programmer and system&net manager.\\n\");
    printf(\"\\tI am glad to be friend with you!\\n\");
    printf(\"-------------------------------------------------------------------\\n\");
    }
    address()
    {
    printf(\"\\n----------------------------------\\n\");
    printf(\"|\\[email protected] |\\n\");
    printf(\"|\\tOICQ:13721218 |\\n\");
    printf(\"|\\t 1/13/2001 |\\n\");
    printf(\"----------------------------------\\n\");
    }


    file 2
    table.h
    char *table_file[]={
    \"alxx\",
    \"bcxx\",
    \"fycx\",
    \"fyxwxx\",
    \"fyzxxx\",
    \"hwzx\",
    \"lhzxxx\",
    \"xxdexx\",
    \"xxdsxx\",
    \"xxfgxx\",
    \"xxglxx\",
    \"xxgsxx\",
    \"xxhmbxx\",
    \"xxhtxx\",
    \"xxjbxx\",
    \"xxltxx\",
    \"xxzwxx\",
    \"xxzx\",
    NULL
    };
    些程序可以方便建表。。。有什么不明白与我联系。
    程序随算不上什么。。。。。但也解决了一些批量建表的问提。
    这个程序可以做为gcc刚入门爱好的参考,因为这个程序象hello world一样间简单。而且很全包括了指针,数组,文件包含,NULL

    用户方法两个文件置于。/root/mygcc/下,将预建库mysql语句文件,文件名命名为xxxx.sql同上然后
    #gcc my.c -o my
    #my
    即可。。。不用我在说了吧?

    我的主页:http://www.9812.net
    喜欢UNIX,BSD,LINUX,gcc,SQL,PHP,JSP
    NT/2000 ASP,架站web开发
    在找一份网管兼程序员工作。

    数风流人物还看今朝。。。看我的了
    发布人:陈景峰 来自:万维新叶