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

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("|newtech@sina.com |

");

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

即可。。。不用我在说了吧？

小编推荐：欲学习电脑技术、系统维护、网络管理、编程开发和安全攻防等高端IT技术，请 点击这里注册账号，公开课频道价值万元IT培训教程免费学，让您少走弯路、事半功倍，好工作升职加薪！

免责声明：本站系公益性非盈利IT技术普及网，本文由投稿者转载自互联网的公开文章，文末均已注明出处，其内容和图片版权归原网站或作者所有，文中所述不代表本站观点，若有无意侵权或转载不当之处请从网站右下角联系我们处理，谢谢合作！