http://www.linuxfocus.org/ChineseGB/September2003/article304.shtml
这种网上很多啊
这种网上很多啊
解决方案 »
- 在mysql数据库已有的表中新建一列,这一列的值为另外一已有数据的列的排名。 求高手sql如何写?
- 求助mysql decode函数的使用问题
- mysql启动错误信息
- 关于mysql查询的奇怪问题~~
- 求mysql语句,导入excel
- 奇怪 我从其中一个数据库导出的普通'insert'语句,在另外一个数据库执行时,出现这种莫名奇妙的错误!
- 十万火急,谢谢大家帮帮忙,帮我优化下sql语句
- 大哥大姐帮帮我,一个sql语句
- vb怎么连接mysql数据库?
- 是不是TYPE=INNODB 可以建外建,但不能建auto_imcrement字段,
- mysql象Postgresql 一样支持数据的完整性和存储过程吗
- 求助 pro*c 方面的问题!
Name: MySQLClientTest
Author: Kip Warner ([email protected])
Date: 24/11/03 13:15
Description: Example to show usage of MySQL databases from client end.
I did not have much time. Sorry...
*/// Includes...
#include <windows.h>
#include <MySQL\mysql.h>
#include <stdlib.h>
#include <stdio.h>
#include <conio.h>// Database name...
char g_szHost[] = "localhost";
UINT g_unPort = MYSQL_PORT;
char g_szUserName[] = "charlieface";
char g_szPassword[] = "pudgy";
char g_szDatabase[] = "Candy";
char g_szSQLStatement[] = "SELECT * chocolates";// Entry point...
int main(int nArguments, char *pszArguments[])
{
// Variables...
MYSQL *myDatabase = NULL;
MYSQL_RES *myResult = NULL;
MYSQL_FIELD *myField = NULL;
MYSQL_ROW myRow = NULL;
UINT unRecords = 0;
UINT unFields = 0;
UINT unIndex = 0;
UINT unFieldIndex = 0;
// Initialize MySQL...
myDatabase = mysql_init(NULL);
// Failed...
if(!myDatabase)
{
// Alert user...
printf("] Error: Unable to initialize MySQL API...\n"); // Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
} // Connect to server and check for error...
if(mysql_real_connect(myDatabase, g_szHost, g_szUserName, g_szPassword,
NULL, g_unPort, NULL, 0) != 0)
{
// Alert user...
printf("] Error: Unable to connect to server...\n"); // Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
} // Select database in server and check for error...
if(mysql_select_db(myDatabase, g_szDatabase) < 0)
{
// Alert user...
printf("] Error: Unable to select database...\n");
// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
} // Query database and check for error...
if(mysql_query(myDatabase, g_szSQLStatement) != 0)
{
// Alert user...
printf("] Error: Unable to execute query...\n");
// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
} // Retrieve query result from server...
myResult = mysql_store_result(myDatabase);
// Failed...
if(!myResult)
{
// Alert user...
printf("] Error: Unable to retrieve result...\n");
// Cleanup, abort, terminate...
mysql_close(myDatabase);
getch();
return 0;
}
// How many records were returned in the result set?
// Calculate...
unRecords = mysql_num_rows(myResult);
// Alert user...
printf("] Query: %d records found...\n", unRecords);
// How many fields are present in a record?
// Calculate...
unFields = mysql_num_fields(myResult);
// Alert user...
printf("] Query: There are %d fields in each record...", unFields);
// Output records...
for(unIndex = 0; unIndex < unRecords; unIndex++)
{
// Fetch row from results...
myRow = mysql_fetch_row(myResult); // Fetch fields from row...
myField = mysql_fetch_fields(myResult); // Show record...
printf("] Record: %d / %d\n", unIndex, unRecords); // Output all fields in this row...
for(unFieldIndex = 0; unFieldIndex < unFields; unFieldIndex++)
{
// Output...
printf("\t%s", myField[unFieldIndex].name);
}
}
// Free result...
mysql_free_result(myResult);
// Close server connection...
mysql_close(myDatabase);
myDatabase = NULL;
// Alert user, exit...
printf("] Done, press any key to exit...\n");
getch();
return 0;
}
这段代码好像不能直接运行,在linux下调windows.h和conio.h没有什么意义吧?能帮忙改改?能跑的,简单点就行了