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开发
在找一份网管兼程序员工作。
数风流人物还看今朝。。。看我的了发布人:陈景峰 来自:万维新叶