数据库|mysql教程数据库-mysql教程#include#include#includeintmain(){MYSQLmysql;MYSQL_RES*res;MYSQL_ROW
数据库|mysql教程
数据库-mysql教程
#include
#include
#include
int main()
{
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
char *query;
int t;
mysql_init(&mysql);
/*connection*/
if(!mysql_real_connect(&mysql,”localhost”,”root”,””,”test”,0,NULL,0)){
printf(“Connect failed/n”);
}else{
printf(“Connect successful/n”);
}
无线订餐系统源码,vscode运行输入,ubuntu cras,tomcat 读写分离,sqlite格式文件打开,wordpress下拉翻页插件,网站开发用的框架前端,花盆怎样才杜绝有爬虫,iis php 上传,漯河seo推广排名,懒人模板网站,软件官网网页源码下载,angular模板循环lzw
/*select*/
query=”select * from t1;”;
if(mysql_real_query(&mysql,query,(unsigned int)strlen(query))==0){
printf(“query successful/n”);
}else{
printf(“query failed/n”);
}
res=mysql_store_result(&mysql);
while(row=mysql_fetch_row(res)){
for(t=0;t
{
printf(“%s/t”,row[t]);
}
}
/*create table*/
/* query=”create table t2(name char(15),age int);”;
if(mysql_real_query(&mysql,query,(unsigned int)strlen(query))==0){
printf(“create table successful/n”);
}else{
printf(“create table failed/n”);
}
*/
/*insert*/
/* query=”insert into t1(name,age) values (‘zhang’,32);”;
if(mysql_real_query(&mysql,query,(unsigned int)strlen(query))==0){
printf(“Insert successful/n”);
}else{
printf(“Insert failed/n”);
}
*/
/*delete*/
/* query=”delete from t1 where age=20;”;
if(mysql_real_query(&mysql,query,(unsigned int)strlen(query))==0){
printf(“Delete successful/n”);
}else{
printf(“Delete failed/n”);
}
*/
/*update*/
/* query=”update t1 set age=100 where name=’wa’;”;
if(mysql_real_query(&mysql,query,(unsigned int)strlen(query))==0){
printf(“Update successful/n”);
}else{
printf(“Update failed/n”);
}
*/
mysql_close(&mysql);
return 0;
java 语音识别源码,VSCODE设置为ES6,ubuntu安装pbc,tomcat启动秒图片,95后爬虫,php grails,湖南seo网络营销推广收费,网站flash动画下载lzw
}
互站网源码,vscode终端改名,老服务器 不支持ubuntu,tomcat添加不,sqlite 表记录关联,博客插件下载手机版下载手机版下载,2017最优雅的前端框架,使用scrapy创建爬虫工程,定界符 php,seo网络建设,中学网站系统源码,网页特效代码大全,织梦移动端模板下载地址lzw
安装
mysql-server-5.1.73-3.el6_5.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
编译
gcc -o sqlconnect sqlconnect.c -I/usr/include/mysql -L/usr/lib64/mysql -lmysqlclient