- #include <stdio.h>
- #include <stdlib.h>
- #include <sys/stat.h>
- #include <sys/types.h>
- #include <fcntl.h>
- #include <string.h>
- #include <mysql/mysql.h>
- int main(int argc,char *argv[])
- {
- MYSQL my_connection;
- mysql_init(&my_connection);
- int res,use;
- if(mysql_real_connect(&my_connection,"localhost","ma","123456ma",
- "student",0,0,0))
- {
- printf("connect success\\n");
- res = mysql_query(&my_connection,"set names utf8");
- if(res)
- {
- fprintf(stderr,"Init char fail %s\\n",mysql_error(&my_connection));
- return -1;
- }
- printf(" char success\\n");
- use = mysql_query(&my_connection,"use student");
- if(use)
- {
- fprintf(stderr,"use database fail %s",mysql_error(&my_connection));
- return -2;
- }
- write(1,"use database student\\n",strlen("use database student\\n"));
- }else
- abort();
- res = mysql_query(&my_connection,"UPDATE Student SET sname='mana' where sno = '201101001'");
- if(!res)
- {
- printf("Updated %lu rows\\n",(unsigned long)mysql_affected_rows(&my_connection));
- }else
- printf("updated data fail %s \\n",mysql_error(&my_connection));
- mysql_close(&my_connection);
- return 0;
- }
- //该片段来自于http://www.codesnippet.cn/detail/0906201512809.html
来源: http://www.codesnippet.cn/detail/0906201512809.html