Hi,
How to call a user defined function. I am using C as the programming
language. I write a small function in C. Created .dll. Then how to run it from mysql
pompt?. How to call or use it?. will any one of you help me in this.
Thanks,
Narasimha
-----Original Message-----
From: Aftab Jahan Subedar [mailto:[EMAIL PROTECTED]
Sent: Mon 9/6/2004 1:14 AM
To: [EMAIL PROTECTED]
Cc:
Subject: Re: Help needed with MySQL C API-based client (segfault)
have you tried ?
http://www.geocities.com/jahan.geo/mysql_c_by_example.html
Ruben Safir Secretary NYLXS wrote:
> On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote:
>
>>Hello,
>>
>>I need to write a simple C client for a project. I am using the MySQL C
>>API. Attached is the code. It occassionally segfaults with no visible
>>pattern. Could someone help me figure out why? Or any other comments on the
>>code to help me make it better?
>
>
> You know, I used to read this mailing list religiously before it became
> flooded with W32 questions and PHP users. And I've stay susbscribed
> but I haven't posted to it in many many months. iIn fact, I didn't notice
> I wasn't any longer subscribed. So I'm writing this application in C
> and GTK and I was thinking, it's finally time to learn to write some MYSQL
> C API stuff.
>
> I've written a lot of Oracle C programs in years past. And now I'm looking
> at the C API stuff and wow, it is not readly understandable. I open up
> the mysql mail file with mutt, and bang, this is on the top!
>
> I was going to ask the list if anyone has an exmaple of the basic needs
> for a MYSQL program which makes a connection, sends a querry. Checks the
> potention errors, and maps the most basic column types to C types.
>
> The docs say to look at examples in the source directory, but those
> aren't yet clear to me to understand.
>
>
> Ruben
>
>
>>/* client.c */
>>
>>#include <stdio.h>
>>#include <mysql.h>
>>
>>int main()
>>{
>> /* declare
>>structures and variables */
>> char query[255];
>> int i, j, count;
>>
>>MYSQL mysql;
>> MYSQL_RES *result;
>> MYSQL_ROW row;
>> MYSQL_FIELD
>>*field;
>>
>> /* initialize MYSQL structure */
>>
>>mysql_init(&mysql);
>>
>> /* connect to database */
>> if
>>(!(mysql_real_connect(&mysql, NULL, "root", "", "db1", 0, NULL, 0)))
>>
>> {
>> fprintf(stderr, "Error in connection: %s\n",
>>mysql_error(&mysql));
>> }
>>
>> for( ;; )
>> {
>>
>>printf("query? ");
>> gets(query);
>> if (strcmp(query,"exit")
>>== 0)
>> {
>> break;
>> }
>>
>> /* execute query
>>*/
>> /* if error, display error message */
>> /* else check the type of
>>query and handle appropriately */
>> if (mysql_query(&mysql, query) != 0)
>>
>>{
>> fprintf(stderr, "Error in query: %s\n",
mysql_error(&mysql));
>> }
>>
>>else
>> {
>> if (result = mysql_store_result(&mysql))
>> {
>> /* SELECT
>>query */
>> /* retrieve result set */
>> int numRecords =
>>mysql_num_rows(result);
>> int numFields = mysql_num_fields(result);
>>
>>for (i = 0; i < numRecords; i++)
>> {
>> row =
>>mysql_fetch_row(result);
>>
>> for (j = 0; j < numFields; j++)
>> {
>>
>>//field= mysql_fetch_field(result);
>> fprintf(stdout, "%s", row[j]);
>>
>> j != (numFields-1) ? printf(", ") : printf("\n");
>> }
>> }
>>
>>fprintf(stdout, "** Query successful, %d rows retrieved **\n",
>>numRecords);
>> }
>> else
>> {
>> if (mysql_field_count(&mysql) == 0)
>>
>>{
>> /* non-SELECT query */
>> fprintf(stdout, "** Query successful,
%d
>>rows affected **\n", mysql_affected_rows(&mysql));
>> }
>> else
>> {
>>
>> fprintf(stderr, "Error in reading result set: %s\n",
>>mysql_error(&mysql));
>> }
>> }
>> }
>>
>> /* clean up */
>>
>>mysql_free_result(result);
>> }
>> mysql_close(&mysql);
>>}
>>
>>--
>>I wouldn't recommend sex, drugs, and insanity for everyone, but it works
>>for me.
>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Aftab Jahan Subedar
CEO/Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
http://www.SubedarTechnologies.com
http://www.DhakaStockExchangeGame.com/
http://www.CEOBangladesh.com/
http://www.NYSEGame.com
tel://+88027519050
EMail://[EMAIL PROTECTED] - Directly to my notebook
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged
information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
