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