RE: How to call stored procedures using C API

Hi again folks, The problem is solved.Was entirely my fault because i didn't check the version of mysqlclient library. -Original Message- From: Gelu Gogancea Sent: Monday, 21 August, 2006 12:47 PM To: mysql@lists.mysql.com Subject: How to call stored procedures using C API Hi t

How to call stored procedures using C API

Hi to all, I try to call a stored procedure using mysql_real_query and with the CLIENT_MULTI_STATEMENTS flag on mysql_real connect() function. When i try the statement "call sp1(@myparam);" the error "can't return the results in actual context" is occur. Please, if is some one which have experie

RE: Split a Delimited String in SQL ( PROCEDURE split_string )

Hi, It's very important to have instaled the library client related to the MySQL server version.For example, you cannot use libmysql.dll version 3.X or 4.x to use stored procedure from version 5.X of MySQL RDBMS. Regards, _ G.NET SOFTWARE COMP

RE: How to use Logic in View Statment?

Hi , IMHO the corect way is to check if IS NULL SELECT fieldOne, fieldTwo, IF(fieldThree IS NULL,fieldFour,fieldThree) as Company FROM table; Depening on the column definition(if is byte,multi-byte...etc.), LENGTH() function can have various behaviour and is not quite sure that you will get

RE: Question about BLOB

mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Wednesday, 03 August, 2005 9:58 AM To: 'mysql@lists.mysql.com ' Subject: Re: Question about BLOB Gelu Gogancea wrote: > Hi, > Is not the first t

RE: Question about BLOB

OPER http://www.gonetsoftware.com Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, 01 August, 2005 8:41 PM To: Gelu Gogancea; MySQL mailing list Subject: RE: Question about BLOB [snip] I have a t

Question about BLOB

Hi, I have a table with a MEDIUMBLOB field and i wish to store a picture(.BMP) which the size is 10622 bytes.But when i look into the table i see only 9582 bytes. Please, i wish to know for what reason on the table are few bytes than original. I use MySQL 5.0 - Fedora Core 3 Thanks, ___

RE: connection time is slow

IMHO You have problems on the DNS server. _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Heo, Jungsu [mailto:[EMAIL P

Bug on MYSQL-5.0 in statement "OPTIMIZE TABLE"

d.log pid-file=/var/run/mysqld/mysqld.pid OS ENVIRONMENT:  RED HAT 8.0 HARDWARE :  Pentium IV 1,7 Ghz,512 Mb RAM,2 x 40GB EIDE HDD Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER

RE: using 2 nic controllers

Hi, You can only bind to a specific network interface IP address which is mounted and "Up" from your server. ie: ./mysqld --bind-address=YOUR_IP_ADDRESS Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION & SOFT

RE: CALCULATING DATES

SELECT IF(YOUR_FIELD_DEPARTMENT_FROM_TABLE=YOUR_INTERESTED_DEPARTMENT_ID,TO_DAYS(LAST_DAY)-TO_DAYS(FIRST_DAY),0) Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [E

RE: CALCULATING DATES

Hi, You can use TO_DAYS() and FROM_DAYS() functions for what you need. All details about Time and Date functions : http://www.mysql.com/doc/en/Date_and_time_functions.html Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION

Test!!!Please ignore this message

Title: Test!!!Please ignore this message Hi fellows, ...just a test.Please ignore this message. _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECT

Can not make PULL from mysql.bkbits.net

Hi, I wish to make a "pull" for mysql-5.0 from http://mysql.bkbits.net but always is nothing to pull. I try with : bk pull http://mysql.bkbits.net/mysql-5.0 I wonder, what happens ? Regards, Gelu _ G.NET SOFTWARE COMPANY Perman

Re: C API

Hi, You can not use native MYSQL C API to handle Oracle DataBase.Work very well (mixed with MYSQL C API) the ORACLE C API which is named OCI(Oracle Call Interface). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL

Re: Leaking Memory from mysql_real_query()

usually, to release memory is used mysql_free_result(). You do that ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message

MINOR BUG IN "CREATE TABLE" ver. MYSQL-5.0

,CONF_DATE,TRANSF_DATE)); CUT- Between "VARCHAR(8)" and "MATERIAL" are double comma.This not generate an err

Re: not allowed to connect to this mysql server

Hi, First you must add grants to the user which you want to connect to the MySQL server.In documentation (4.3.5 Adding New Users to MySQL) you will find how you can achieved this. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail

Re: Doing select @a does not work in replication.

Hi, ...the sysntax it's not quite normal.You should try : select @a:=max(id)+1 from t1; To test if the variable @a is "loaded" with what you expect, you can do: select @a; ...if the result is NULL something is working wrong. Anyhow, i wonder how it works on the master ?

Re: mysql_query to return immediately when connection lost

Hi, In this case i guess is better to execute mysql_ping() before mysql_query(). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original

Re: mysql_query to return immediately when connection lost

Hi, This is usually happened becuase you don't have configured a DNS server in your network. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROT

Re: AW: EMS MySQL Manager for Linux 1.15 released!

idered spam. > Focus your attention on real spam. There's plenty to go after without > taking things out on people providing software for our favourite database. > I agree with this point of viewsubscribe also. Best regards, Gelu __

Re: mySQL activity logging on a dual prozessor maschine

d the time from the system and write to the log file.The question is : When ? Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Me

Re: mySQL activity logging on a dual prozessor maschine

Hi Peter, - Original Message - From: "Peter Stoehr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Gelu Gogancea" <[EMAIL PROTECTED]> Sent: Monday, March 17, 2003 3:56 PM Subject: RE: mySQL activity logging on a dual prozessor maschine > Hi G

Re: Looking for a bona fide distributed database that is open source

Hi Bruce, - Original Message - From: "Bruce Feist" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, March 16, 2003 7:03 AM Subject: Re: Looking for a bona fide distributed database that is open source > Gelu Gogancea wrote: &g

Re: Looking for a bona fide distributed database that is open source

?To wait until some *automation* will be implemented ? Anyhow this discussion risk to be already off topic for MySQL mailing list. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED

Re: forcing mysql client to use TCP socket?

Hi, I think you have at least two ways: 1.To put the corect path to the sock file, in my.cnf configuration file. 2.To find where MySQL daemon create this file and add the argument -S to the mysql client application. Regards, Gelu _ G.NET

Re: mySQL activity logging on a dual prozessor maschine

Hi, Maybe it's funny...but this is MySQL date/time format which is used in log files.On my MySQL servers date/time are formated in the same way. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROT

Re: Paul, do you address this in any of your books?

i correct my example : select USERID,IF(DAY='2003-01-02',SUM(LIS_QUANTITY),0) as 2003-01-02,IF(DAY='2003-01-03',SUM(LIS_QUANTITY),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where > YOUR_CONDITIONS GROUP B

Re: Paul, do you address this in any of your books?

Hi, You can try to use IF(),CASE() function in the SQL statement. Eg. select USERID,IF(DAY='2003-01-02',COUNT(*),0) as 2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where YOUR_CONDITIONS GROUP BY D

Re: Looking for a bona fide distributed database that is open source

like database support for their application,Oracle9i...and was very disappointed. Regards, Gelu > > In fact, only a few seem to be able to even access mutiple databases on the same server > > Frankly, I am still looking for a db that provides n way replication (this may solve > s

Re: Looking for a bona fide distributed database that is open source

the MySQL website is a link to a german company which has develop a modules which treat multiple MySQL database(hosted on different machine of course) to a logical one. Best Regards, Gelu P.S.This is my opinion...if you consider that

Re: Looking for a bona fide distributed database that is open source

To anyone that *didn't see the forest because of the trees*. You already find it. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Ori

Re: HELP mysql_server_init embedded in a DLL?

ideChar()...you will get a lot of "unpleasure surprises". Of course you can do some improvisation (like in mysql_init or to convert a STRING into ARRAY of BYTE) but is not a solution because VB imediatly will give you some error like "OUT OF MEMORY". Regards, Gelu __

Re: HELP mysql_server_init embedded in a DLL?

ld not be read" */ > > iRtn = mysql_server_init(3, args, server_groups); > > > > if (pSet ==0 ) return NULLDBS; > > memset(pSet, 0, sizeof(DBSET)); /* Zero the structure.*/ > >pSet->size = sizeof(DBSET);

Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

> Now fuck off, dumbass. > > Yeah. That lack of respect is exactly why I refused to read your ...you can not ask respect from this man which already make the prove that have no BRAIN. > original post about the problem to the end. As I said, that is a list > of volunteers and your at

Re: question

Hi, Already work (very well) on Win98. You can download it from http://www.mysql.com/downloads/mysql-4.0.html Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL

Re: copying a row

your_table where. insert into your_table values(@a,@b@n) Regards, Gelu > > regards Wilbert > > > > - > Pas de Deux > Van Mierisstraat 25 > 2526 NM Den Haag > tel 070 4450855 > fax 070 4450852 > http://www.pdd.nl > [EMAIL PROTECTED

Re: Replication Problems/Questions

st one question: > - could anyone explain me the meaning of the fields from show slave status > ( I'm looking for a way to decide if the slave has replicated all the data > from the master ) > > Best regards Best Regards, Gelu > > [EMAIL PROTECTED] > > > -

Re: SELECTing across a Network

Hi, For the moment you can't. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Isaac Anietye Inyan

Re: how to get the Nth record of a result ?

Hi, select * from table where LIMIT HOW_MANY_RESULT_YOU_WISH; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From

Strange behaviuor in ver. 4.1(maybe dusty)

es at 0x00841eb98, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e9b0, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e7c8, allocated at line 94 in 'my_alloc.c' Maximum memory usage: 409950738 bytes (400343k) 030126 23:47

Re: Client History

Hi, If you start the mysql daemon with option "--log" then you will find the file with all querys which was executed, in the data directory. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL

Re: BUG:ALTER TABLE (MySQL 4.1)

s code based on this problem. Today (Jan 25) i make pull again (Sergei suggest me today) and now it work well after when i fixed the table. Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail addres

Re: BUG:ALTER TABLE (MySQL 4.1)

12138f _Z21mysql_execute_commandP3THD + 2803 0x8124d7d _Z11mysql_parseP3THDPcj + 221 0x811f9a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 859 0x811f612 _Z10do_commandP3THD + 110 0x811ef8d handle_one_connection + 813 0x4003376e _end + 936070638 0x402687da _end + 938384986 Best regards,

Re: BUG:ALTER TABLE (MySQL 4.1)

...like usually i forget some details: Table type is MyISAM and was created with MySQL ver 3.23.47 But if i create the table with ver.4.1 the behaviour is the same. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL

BUG:ALTER TABLE (MySQL 4.1)

to see what happened. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Before

Re: Bind Variables.]

id bind array variable and also to avoid FOREACH() function is: insert into YOUR_TABLES SET YOUR_1-st_FIELD=1-st_ITEM,YOUR_2-nd_FIELD=2-nd_ITEM...etc select IF(1-st_ITEM SOME_FILTERING_CONDITIONS,RETURN_IF_TRUE,RETURN_IF_FALSE)...etc from OTHER_TABLE where CONSTRAINT_CONDITION... I hope it help,

Re: Writing program to communicate with remote internet MySQL server?

ownload it from : http://www.a1vbcode.com/app.asp?ID=1764 I hope it help. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message -

Re: Writing program to communicate with remote internet MySQL server?

Hi, IMHO: I think the better way is to use replication between your local MySQL server and MySQL from the Web Server. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED

Re: gethostbyname_r() (un)bug in MySQL source build

Hi, IMHO: I think if you use autoheader it's possible to fix that according with your glibc/compiler version.Also (...from what i remember what i saw in the source code) is used macros for checking GLIBC2 style. Regards, Gelu _ G.NET SOF

Re: Hi and why

Hi, Indeed...this happend in both main version of MySQL (ver. 3.x and 4.0.x) However ,if you use : select * from test_table where NAME='2'; you will have the correct result. Regards, Gelu ___ G.NET SOFTWARE COMPANY Permanent e-ma

Re: Connection ms access to mysql

is you can import in your MySQL tables using (...this can be a way) LOAD DATA... E.g: LOAD DATA INFILE 'the_path_to_one_of_txt_files' INTO TABLE one_of_table_to_load FIELDS TERMINATED BY ',' LINES TERMINATED BY ';'; This it should be work. Regards, Gelu _

Re: Whats the best way to manage 'generic two-way relationships'?

chema for to_relation can be : CATEGORY.IDCAT->TO_RELATION.IDCAT TO_RELATION->IDX_TO_RELATION.IDTO IDX_TO_RELATION.IDRELATED->FROM_RELATIONS.IDFROM ..and for from_relation can be: CATEGORY.IDCAT->FROM_RELATION.IDCAT FROM_RELATION.IDFROM->IDX_FROM_RELATION.IDFROM IDX_FROM_RELATION.IDREL

Re: g++ and mySQL]

Hi Benjamin, - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Gelu Gogancea" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 16, 2003 4:23 PM Subject: Re: g++ and mySQL] > Hi.

Re: g++ and mySQL]

Hi, If i understand well you wish to concatenate different strings. Are many options but the most handy solution is if you use "sprintf". Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL

Re: data directory in 4.0.9

My dear friend, I suppose that you already done: ./configure --prefix=PATH_OF_THE_MYSQL_APPLICATION After compilation you must do: make install and after this : cd /PATH_OF_THE_MYSQL_APPLICATION/bin and... ./mysql_install_db. Regards, Gelu

Re: error report using mysql 3.23.49 max

blem. We waiting some more details. > > Thanks for attention You are welcome > > Cilly Best regards, Gelu > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual)

Re: Problem using the C-API for MySQL Program breakdown after about 1 Mio SQL-statements

Hi, Maybe it's a good ideea to increase the value of max_allowed_packet(from my.cnf configuration file) to 2M.By default is 1MB. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROT

Re: May be bug in MySQL 4

Hi, I think is not a bug.The result is normal becuase function TO_DAYS() return the daynumber and not the date.If you wish to find a date depend on the number of days you can try(like example): select FROM_DAYS(TO_DAYS(NOW())-3); Read the manual about this two functions Regards, Gelu

Re: MS SQL vs MySQL

Hi, In fact ...you can choice the RDBMS depend on what you wish to do. If you are able to design the database for using without store procedures,viewers,triggers...you can choose MySQL. It's stable enough and the better part is that have very good performance. Regards,

Re: Populating one table with data from another

Hi, You can use INSERT...SELECT. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Michael Knauf/Niles&quo

Re: connect by IP number

Hi, If you use NULL on the USER parameter that means you wish to login with the current user which is already logged under Linux.I suppose that you don't have any user set to connect at MySQL server. I think it's better to try with "root" instead of

Re: help with query

Hi, SELECT LEFT(YOUR_COLUMN,2) FROM YOUR_TABLE.for position SELECT RIGHT(YOUR_COLUMN,2) FROM YOUR_TABLE for type Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED

Re: problem with last_id

what_client_must_to_insert SELECT LAST_INSERT_ID(); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Richard Br

Re: Re[4]: mysql 4.0.8- crash on TCP connection

Hi, It seems is happens to all which use InnoDB.Is announced that will be solved in 4.0.9. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED

Re: Re[4]: mysql 4.0.8- crash on TCP connection

> All this is very interesting, BUT i have two binary builds (4.0.7 & 4.0.8), Ha,Hayou are gentle. > (load avg 10-60 Query/sec), and 4.0.8 crash (in some > hardware/software) after 2 seconds work :( If i understand well it crashed even if no one is connected ? R

Re: remote connect crash

Hi, Start mysql daemon with options "--skip-name-resolve" Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - Fro

Re: Re[2]: mysql 4.0.8- crash on TCP connection

stent data struct else is a NULL POINTER. Conclusioni think we talk about two different thing Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] --

Re: Re[2]: mysql 4.0.8- crash on TCP connection

s declared by MySQL like unstable.In this context can be a coincidence what is happened. Also i don't find difference in MYSQL daemon source code(hostname.cc) between 4.0.7 and 4.0.8. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail a

Re: Re[2]: mysql 4.0.8- crash on TCP connection

Hi, This is a glibc problem.In this case you can start mysql daemon with option "--skip-name-resolve" and in this situation is no need to add the IP address of every client in hosts file.The disadvantage is that the client can not connect to the server using host alias. Rega

Re: Re[4]: mysql 4.0.8- crash on TCP connection

Hi, Try to start mysql daemon with "--skip-innodb" and see if the problem persist.I suppose is something wrong with your my.cnf configuration. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL

Re: mysql 4.0.8- crash on TCP connection

Hi, What OS you use ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Andrew Sitnikov" <[EMAIL P

Re: [OT] Re: InnoDB vs. MySQL performance Issue

e this means MYSQL AB will be agree with this kind of disputation .Personally, i think THIS NOT A PURPOSE OF MYSQL AB. Anyhow,i think this list belong to all MYSQL users/software developers and in this situation MYSQL AB didn't have ANY FAULT. With all my consideration, Gelu Gogance

Re: InnoDB vs. MySQL performance Issue

and SAM). Personally, i beg you to repost your problem to the list because i didn't "catch" the e-mail where is described your problem. Best Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED

Re: InnoDB vs. MySQL performance Issue

Peace to all, This is not the right place for this kind of discussions. Please STOP. Also i have a suggestion for the administrator of this list: -to forbidden all e-mail which have in subject or body, logo /slogan/catchword which can be considered RINGLEADER. Regards, Gelu

Re: mysql_use_result

Hi, Strange...you should be able to find the number of fields from resultset with mysql_num_fields.You use MYSQL_RES like parameter for mysql_fetch_fields ? How do you use mysql_fetch_fields? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e

Re: Desperate - failed: Lost connection to MySQL server during query

. Anyway if you start MySQL daemon with option --skip-name-resolve and the problem it's solved then you have only this 2 options. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROT

Re: ADO Error '800a01fb'

Hi, >From what i know i think is possible if you declare(like METADATA) this object(using UUID). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTEC

Re: ADO Error '800a01fb'

Hi, This is an aoutomation error and is possible to be raised because you use CreateObject instead of using object directly. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED

Re: birthday calculation problem

Hi, I think you can try to use TO_DAYS() function; eg: select TO_DAYS('2002-12-28')-TO_DAYS(NOW()); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL

Re: birthday calculation problem

Hi, I think you can try to use TO_DAYS() function; eg: select TO_DAYS('2002-12-28')-TO_DAYS(NOW()); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL

Re: SELECT and UPDATE at the same time?

Hi, You can use REPLACE...SELECT Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Jeff Snoxell&quo

Re: More locking issues

Hi, Is not the same caseJeff didn't said anything about TRANSACTIONS. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Me

Re: More locking issues

Hi, If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Regards, Gelu _ G.NET SOFTWA

Re: Error No: 2013. Lost Connection MySQL server during query

L 3.23.53a binary distribution . -upgrade your glibc to .42 or downgrade to .39. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original

Re: SQL Row Counting in MySQL

Hi, Select * from Blah where stuff="true" limit 10; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From:

Re: SQL Query

Hi, If the lenght of what wish to retrieve is fixed to 2 length,you can try something like this: select MID(YOUR_FIELD,3,IF(RIGHT(LPAD(YOUR_FIELD,4,','),1)=',',1,2)) from YOUR_TABLE; Regards, Gelu _ G.NET SOFTWARE COMPA

Re: importing from text: date column problem

Hi, It's possible if you use DATE_FORMAT(). E.g. SELECT DATE_FORMAT('1997-11-15', '%d-%b-%Y') Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

Re: my host IP changed

ct to the MySQL. You can use : update user SET Host='YOUR_IP_ADDRESS' where User='YOUR_USER_NAME' and Host='THE_NAME_OF_HOST'; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

Re: my host IP changed

ot from MySQL... else you should to update the new IP address in the mysql.user table using "update" or "replace". Finally you must do: flush privileges; Regards, Gelu _ G.NET SOFTWARE COMPANY

Re: Copying one table to another

Hi, You can use : INSERT INTO SELECT * FROM YOUR_TABLE Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: <[EM

Re: Decrypt MYSQL Password

the MySQL authentification system and you can make relation between this table and mysql.user using encrypted password like foreign key. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

Re: yo

Hi, Maybe on IRC(UNDERNET) is possible to have chance to find MySQL tutorials in spanish. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED

Re: mysqld refuse to die

Hi, What error you get when try to stop mysql daemon ?..or tell us what is in mysqld.log? Maybe we can help you. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED

Re: mysqld refuse to die

Yes.All processes are named "mysqld"...less one "mysqld_safe" which is "main guilty" for keeping mysql daemon in "life". P.S. Please tell me (if you wish)...what means AFAIK? Regards, Gelu _ G.NET SO

Re: mysqld refuse to die

...because not all mysql processes are named "mysql" and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is "killed". Regards, Gelu _ G.NET SOFTWAR

Re: mysqld refuse to die

t;health" if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message -

Re: Returning an Auto-Increment Field

Hi, select last_insert_id(); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Tim Johnson" <[EM

Re: accessing mysql from C

mysql_reload(mysql) mysql_refresh((mysql),REFRESH_GRANT) #endif #define HAVE_MYSQL_REAL_CONNECT mysql_connect it's already "history". Try to use mysql_real_connect() Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail a

  1   2   3   >