我是在win2k下做的,编译器为vc
建如下的表
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| year | int(11) | YES | | NULL | |
| month | int(11) | YES | | NULL | |
| day | int(11) | YES | | NULL | |
| thing | varchar(50) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
加入一行数据
+------+-------+------+-------+
| year | month | day | thing |
+------+-------+------+-------+
| 2005 | 8 | 31 | today |
+------+-------+------+-------+程序也很简单
#include <windows.h>
#include <stdio.h>
#include <string.h>
#include <mysql.h>int main( int argc, char * argv[] )
{
MYSQL mysql;
MYSQL_RES *result;
MYSQL_ROW row;
mysql_init(&mysql);
mysql_real_connect(&mysql,"localhost","root","123456","library",3306,NULL,0);
mysql_query(&mysql,"select * from date");
result=mysql_store_result(&mysql);
while(row=mysql_fetch_row(result))
{
printf("%4d-%02d-%02d %s\n",row[0],row[1],row[2],row[3]);
}
mysql_free_result(result);
mysql_close(&mysql);
}
编译运行都很正常,但结果却显示
3854420-3854425-3854427 today
不知程序哪边有错,多谢指教!
建如下的表
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| year | int(11) | YES | | NULL | |
| month | int(11) | YES | | NULL | |
| day | int(11) | YES | | NULL | |
| thing | varchar(50) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
加入一行数据
+------+-------+------+-------+
| year | month | day | thing |
+------+-------+------+-------+
| 2005 | 8 | 31 | today |
+------+-------+------+-------+程序也很简单
#include <windows.h>
#include <stdio.h>
#include <string.h>
#include <mysql.h>int main( int argc, char * argv[] )
{
MYSQL mysql;
MYSQL_RES *result;
MYSQL_ROW row;
mysql_init(&mysql);
mysql_real_connect(&mysql,"localhost","root","123456","library",3306,NULL,0);
mysql_query(&mysql,"select * from date");
result=mysql_store_result(&mysql);
while(row=mysql_fetch_row(result))
{
printf("%4d-%02d-%02d %s\n",row[0],row[1],row[2],row[3]);
}
mysql_free_result(result);
mysql_close(&mysql);
}
编译运行都很正常,但结果却显示
3854420-3854425-3854427 today
不知程序哪边有错,多谢指教!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货