Binary size problem

I compiles a C application which uses mysql library on two RedHat 9.0 machines. Both machines are using the same GCC and the same MySQL 4.0.16 : MySQL-client-4.0.16-0 MySQL-server-4.0.16-0 MySQL-devel-4.0.16-0 MySQL-shared-compat-4.0.16-0 gcc-3.2.2-5 gcc-c++-3.2.2-5 libgcc-3.2.2-5 In the MACHINE

MySQL log files

Hello, How can I enable MySQL 4.0.16 log ? I just compiled and installed it in my RedHat 9.0 system, but I cant see any log files. I use default /etc/my.cnf from my-large.cnf. Sorry, if this question is too newbie, but I cant understand clearly reading MySQL manual. Thanks for helping me :)

RE: After installing MySQL 4.0.16 (rpm), it did not create /etc/my.cnf ?

c. >   - http://friendfinder.com/go/p40688 > > > -->-Original Message- > -->From: Admin-Stress [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, November 11, 2003 11:44 AM > -->To: [EMAIL PROTECTED] > -->Subject: After installing MySQL 4.0.16 (rpm), i

After installing MySQL 4.0.16 (rpm), it did not create /etc/my.cnf ?

Hi, My server is using RedHat 9.0. I just CHANGED the mysql from 3.23.58 (rpm) to 4.0.16 (rpm). What I did : # rpm -e # rm -rf /var/lib/mysql then install the 4.0.16 (rpm) # rpm -i MySQL-server MySQL-client ... MySQL-devel ... MySQL-shared-compat After this, I can start the

help on my query statement

I have a table called TRANSACTION, it has some fields : REGDATE - date of the transaction WHAT - a string (NOT UNIQUE) CUSTOMER - customer code I want to query all WHAT that the date of the transaction was 15 days before. So, my sql query is : SELECT WHAT FROM TRANSACTION WHERE REGDATE < Now()

Simple question about updating a table field

I have a numeric table field, named "CREDIT". How can I add a number (+50) to that field for all the table record ? is this correct? UPDATE ThisTable SET CREDIT=CREDIT+50 Please help, Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuar

help with sql query : DATETIME function

I have a table with this structure : username VARCHAR(32) address VARCHAR(128) datereg DATETIME // date of registration classINT How is the sql query for username who are their datereg was 30 days ago and class = 1? thanks __ D

updating some records in a table

Hi, I am new to mySQL, so I need some help. I have a table, which has record structure like this: - customer - name - register_date - expired Every day, I add some records, new customers. The field 'expired' is just a flag, either '1' or '0'. If register_date is 3 months ago then expired = 1.

closing database (mysql C API)

Hi, I wrote an application using mysql C API. If I exit my application without closing database, will it be closed automatically? void error(int code) { printf("error: %d\n", code); exit(0); } int main() { ... error(-255); ... } How to pass the mysql database connector to a function? is

updating a field more than once

Hi, I wrote a simple CGI application using mysql. What it does is really simple : connect to mysql database ... do something ... update a field ... do something again ... close mysql The update is like TOTAL = TOTAL + AMOUNT. If let say, 1000 users accessing my CGI in the same ti

restricting mysql

Hi, After I installed mysql, I noticed there is an open port now, port 3306. Can I restrict this so only from localhost can connect? I meant to close port 3306. But without using firewall :( I dont have knowledge about this. If there is no way to do this without firewall, then I will learn it. I

newbie: creating database error

After playing around with 'test' database, then I would like to create my own database. I logged in into mysql using root account and created a database. But, when I logged in using regular user, I got his error : ERROR 1044: Access denied for user: '@localhost' to database 'card' What necessar

newbie: SQL question

Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you have collection for beginner, please :) Thanks, kapot __