mysql c api

hi, i found a strange user comment in the current documentation of c api for mysql_real_connect. http://www.mysql.com/doc/en/mysql_real_query.html "If a result set (MYSQL_RES) is in use, then mysql_free_result(...) must be called before a call to this function will be successful." if this is tru

debian smp

hi, I have a new dual cpu server with debian 2.2.19 smp kernel and with 1G ram. my question is: need i apply the threads-patch or the fork-patch from mysql manual 2.6.1 before i compile my kernel and the mysql source? (i use max 500 connections). cheers, ati -

mysql round problem

?? cheers, Attila Soki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsub

Re: C API problem, CREATE TABLE SELECT & SELECT

| query_len = sprintf(query, "CREATE TEMPORARY TABLE temp SELECT "); try it out with asprintf(). but you have to define at compile time the following -D_GNU_SOURCE maybe you allocates not enough place for query. asprintf do it for you. char *query; int query_len; query_len=asprintf(&query

segfault in mysql client

hi, just for information: i know the following line is bugous but, if i execute it in shell then i get a segfault. mysqldump -uCHANGED -pCHANGED --add-drop-table CHANGED Acc9200101Users,Acc9200101BonusCollectors,Acc9200101BonusFlow,Acc9200101Bonu sFlowLogs,Acc9200101CumulativeBonusCollectors,Ac

Re: About huge numbers

| > One more question is how to transfer these values through | > the MySQL C api ? try this site... http://www.mathtools.net/C++/Extra_precision_computation/ ati - Before posting, please check: http://www.mysql.com/manual.

Re: Comparing Dates

| not experienced enough to figure it out. I simply want to grab every entry | in a given table that has been entered within the last three days. select * from yourtable where datefield < date_sub(now(),interval 3 day); see mysql doc: http://www.mysql.com/doc/D/a/Date_and_time_functions.html at

where is my binary log file

hi, i have a lamer question: where is my binary log file? i can't find it. i am sure it exists because grows crazy, when i restore a database from dumpfile. i found nothing about binary log in my.cnf. version: mysql 3.23.32-log install path: /usr/local (default) thanx, ati ---

Re: conversion.........

| he saves it as (.frm,.MYD,.MYI)anybody knows how in windows can i use the | database from my LINUX? simple, see mysql manual: mysqldump in linux shell type: mysqldump -uUSER -pPASSWORD --add-drop-table MYDATABASE > dumpOfMyDatabase.sql copy the file dumpOfMyDatabase.sql to your win computer,

how to get a list of locks

hi, 1. can i get a list of locks created with get_lock()? 2. if i create locks with get_lock() and my program stops with script error before releasing these locks, how can i release these _dead_ locks? (i use persistent mysql connections) thanx, ati

Re: How to do simple stuff

hi | Add a column add an integer column: alter table sometable add somecolumn int; add an varchar column: alter table sometable add somecolumn varchar(255); see: mysql doc 7.8 Alter table syntax | Alter a table to fit a different character lengths |(say...unlimited in a 1 column) simply spec

Re: What does this error mean??!!

hi, try to execute this query too: FLUSH PRIVILEGES; bye, ati - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

double column type why...

;<<<<<<<<<<< HERE | 898.0 |<<<<<<<<<<<<<<< HERE | 88.0 |<<<<<<<<<<<<<<< HERE | 1.00010 |

unix_timestamp why 0

hi, is this normal? how can i get a timestamp of dates before 1970? thanks. ati mysql> select from_unixtime(-86400); +---+ | from_unixtime(-86400) | +---+ | 1969-12-31 01:00:00 | +---+ 1 row in set (0.00 sec) mysql> select unix_t

recursive query

hi, how can i make recursive querys in mysql? i want to show a tree. my table: tree (id int, parent int, name char(10)); id parent name -- 1 0 joe 2 1 mike 3 1 jim 4 2 george 5 3