当前位置:Linux教程 - 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("" "");

printf(""MySQL host:"");scanf(""%s"",host);
printf(""Root user:"");scanf(""%s"",sid);
printf(""Password:"");scanf(""%s"",pwd);
printf(""Loading........ "");
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 %s"",mydatabase,mysqltable);
printf(table_file[i]);
//printf(""%d"",status);
if(db==0 && status==0){
printf("" Install [ OK ] "");
}else{
printf("" Install [ :( ] "");
}
i++;
}
address();
}


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


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
即可。。。不用我在说了吧?


---陈景峰(netkiller)