Must mysql_free_result be called after mysql_store_result in case of NULL?

Hi, I have been searching for this for a while without finding a good answer. In the following example, MUST I call mysql_free_result() in case mysql_store_result(sql)==NULL or not? Is the following valid in case of NULL? query="update/insert ..." if (mysql_query(sql,query)!=0) return

Re: insert subquery

[EMAIL PROTECTED] wrote: Well, Gordon, looks like you missed the thread. ;-) Maybe, but his solution is actually pretty close to what the OP wanted Instead of INSERT INTO Table1 (...) VALUES ('val1', 'val2', 'val3', ...) you do INSERT INTO Table1 (...) SELECT 'val1', 'val2', 'val3',

RE: insert subquery

Well, Gordon, looks like you missed the thread. ;-) What's happening is that DJ wants to add records to a table only if another table has a certain record in it. I have been trying to convince him to set up a FOREIGN KEY between the two. Since he didn't give any real table name I will have to

Re: foreign keys in MyISAM?

On Sep 23, 2005, at 12:27 PM, Jacek Becla wrote: Hi, The documentation says "At a later stage, foreign key constraints will be implemented for MyISAM tables as well". Does anybody know what is the timescale? I'm not sure there is a timescale.. I think it might be pretty open ended. You c

foreign keys in MyISAM?

Hi, The documentation says "At a later stage, foreign key constraints will be implemented for MyISAM tables as well". Does anybody know what is the timescale? thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

RE: insert subquery

What am I missing INSERT INTO table1 (column names.) SELECT VALUES.. FROM table2 WHERE primary id = insert value You will have to put in your real table name and column names. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 200

Re: Number of InnoDB files vs performance?

Hello. In my opinion, if you're unable to put InnoDB files on different disks there is no sense to use separate files. Even more - using the raw partition for InnoDB might increase a performance. See: http://dev.mysql.com/doc/mysql/en/innodb-raw-devices.html However, if you prefer many

Re: Problem related to Installation of MYSQL 4.0.2

Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html >Lms.Bmc Bmc wrote: >hi, > i am Installing My Sql -Standard-4.0.26-pc-linux-gnu-i686 Of Linux >Machine >But Facing some Problem > i am Getting thius Error " ERROR 2002: Can't connect to local MySQL

daemon crash when shutting down large databases

mysql usually crashes when being shutdown. The machine is a dual AMD64 w 8GB RAM running mysql-4.1.14 on Gentoo linux with a ~40GB database. I had similar crashes running 4.0.24 on an x86 running a ~275GB database. I always use `mysqladmin shutdown` rather than the init scripts to shutdown t

Re: insert subquery

DJ <[EMAIL PROTECTED]> wrote on 09/23/2005 12:49:35 PM: > [EMAIL PROTECTED] wrote: > > >DJ wrote on 09/23/2005 12:22:58 PM: > > > > > >>i want to insert a row into table1 only if the value being inserted on > >>table1 exists on table2 primary id. > >> > >>can i do this with subquery? > >> > >>

Re: insert subquery

[EMAIL PROTECTED] wrote: DJ wrote on 09/23/2005 12:22:58 PM: i want to insert a row into table1 only if the value being inserted on table1 exists on table2 primary id. can i do this with subquery? thanx. Depending on what version MySQL you are using, probably not. A very robust m

Re: quoting strings/ints/vars in mysql

"bruce" <[EMAIL PROTECTED]> wrote on 09/23/2005 12:24:25 PM: > hi... > > i've been lloking over various open source apps to get a feel for how the > apps store and manipulate information as it's stored in the mysql db... > > i see some apps that put "'"s around strings that get stored in the db

Re: MyISAM to InnoDB

I see that the thread is getting too long, so I'm cutting out parts that I'm not responding to. Hope no one minds. As far as I'm concerned, simplicity and ease would be to leave it as is but we're looking to eek out as much speed in our transactions >>> >>>as possible >>> so sim

Re: quoting strings/ints/vars in mysql

bruce wrote: hi... i've been lloking over various open source apps to get a feel for how the apps store and manipulate information as it's stored in the mysql db... i see some apps that put "'"s around strings that get stored in the db, as well as some apps that appear to put "'"s around numer

Re: insert subquery

DJ <[EMAIL PROTECTED]> wrote on 09/23/2005 12:22:58 PM: > i want to insert a row into table1 only if the value being inserted on > table1 exists on table2 primary id. > > can i do this with subquery? > > thanx. > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus.

How do I know if I am within a transaction?

If I BEGIN a transaction and a piece of PHP code containing another transaction is run, the second BEGIN commits the first transaction for me. How can I tell if I am in an existing transaction so that I do not issue the second BEGIN? Thanks.. Andrew -- MySQL General Mailing List For list archi

insert subquery

i want to insert a row into table1 only if the value being inserted on table1 exists on table2 primary id. can i do this with subquery? thanx. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 9/22/2005 --

quoting strings/ints/vars in mysql

hi... i've been lloking over various open source apps to get a feel for how the apps store and manipulate information as it's stored in the mysql db... i see some apps that put "'"s around strings that get stored in the db, as well as some apps that appear to put "'"s around numeric data... i'm

RE: MyISAM to InnoDB

"Jeff" <[EMAIL PROTECTED]> wrote on 09/23/2005 11:36:01 AM: <> > > Is that the only diff (other than the "select count(*)" thing) between > InnoDB and MyISAM? Aren't select statements faster from MyISAM tables > than from InnoDB's? > > There's also been a statement from our lead developer that

RE: MyISAM to InnoDB

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, September 23, 2005 10:25 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: RE: MyISAM to InnoDB > > > "Jeff" <[EMAIL PROTECTED]> wrote on 09/23/2005 09:57:06 AM: > > > > -Original Message- >

RE: MyISAM to InnoDB

"Jeff" <[EMAIL PROTECTED]> wrote on 09/23/2005 09:57:06 AM: > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 23, 2005 09:40 > > To: Jeff > > Cc: mysql@lists.mysql.com > > Subject: RE: MyISAM to InnoDB > > > > > > Sorry to butt in b

RE: MyISAM to InnoDB

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, September 23, 2005 09:40 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: RE: MyISAM to InnoDB > > > Sorry to butt in but I wanted to make sure you didn't do > actually do what > you proposed to d

RE: MyISAM to InnoDB

Sorry to butt in but I wanted to make sure you didn't do actually do what you proposed to do, yet. More responses interspersed... "Jeff" <[EMAIL PROTECTED]> wrote on 09/23/2005 08:32:57 AM: > > -Original Message- > > From: Devananda [mailto:[EMAIL PROTECTED] > > Sent: Thursday, Septembe

Re: connectin from ORACLE to MYSQL

Hi Green, Thanks for the email. As you said, i am also trying other resources to find answers for this question. Just waiting for their answers. Since the answers were little urgent, i was little curious. I will let you all know once i find any solution to this. regards anandkl On 9/23/05, [EM

Message could not be delivered

Çøâ-*ïËw³÷i_fyÎQŒ¿)7è²)1 s7#‡¡3ã]®ƒlŽy ·Hxþ­Gý¥}Ý?¿àJÒ)êñµ(eÛ9üz^Æ ­C_4è Ê-<<ÉXœÄ›Ûá\‰;FýâÉëÁ©“RJkå6hnÁ5eÅ}†·ú PáÆÀ }Æï[_±î™ùõ¾Î¸ŸUhªþe¥ŠˆïS~hX«®xòÃ,6/T™Æ’^ÌI6È}„ yˆb?o‰ –Ôcè7§Ì²ŸAž•¶ŸÞ1™)œ}l¸çŠÎ` ,ld½ .ä^ñ JlÄÍõYv"‹®°”gôˉ‰ÕÕXßZ³ä^1Šq5q~…C®“w]èv&àßLèÝ%/ª˜¥vݞJ¹[èùBp%¦>[ò¯üåXf`k3"x»ëŠåž

Re: connectin from ORACLE to MYSQL

Ananda Kumar <[EMAIL PROTECTED]> wrote on 09/23/2005 05:25:10 AM: > Hi Friends, > Any help on this is highly appreciated. > regards > anandkl > > On 9/23/05, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > > > Hi Friends, > > I have set up all the drivers and configured the Hetrogenous service in

Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

YL wrote: Did you tried just copy those 3.23 files into a newly installed 4.1 data folder? What's happen? Yes. I tried. The result is all Chinese words were turned into unrecognized characters. In my system, there are tens of databases, which include thousands of tables. A very large sy

RE: MyISAM to InnoDB

> -Original Message- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 19:03 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: MyISAM to InnoDB > > > Jeff wrote: > >>-Original Message- > >>From: Devananda [mailto:[EMAIL PROTECTED] > >>Sent: Thur

RE: regarding supersmack

I don't think we can change/add datatypes unless you have to play with the code. sujay -Original Message- From: Sreedhar Kharidehal [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 3:06 PM To: mysql@lists.mysql.com Subject: regarding supersmack Can i generate date type value

regarding supersmack

Can i generate date type values with super smack.The format specifiers show only string and integer . Thanks -- sreedhar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: connectin from ORACLE to MYSQL

Hi Friends, Any help on this is highly appreciated. regards anandkl On 9/23/05, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Hi Friends, > I have set up all the drivers and configured the Hetrogenous service in > oracle and set all the relevent parameter. Now when i am connecting to MYSQL > from

Message could not be delivered

y©´Îƒ³;û*GHýʗoRspK.9õ? Ž.)°)†9φNƆiãÖìŠ`å7KaÞ'7ËeÚíº¡…ó% ĸ(ÓIØVgW.jSzî i-~VEICX<£fÓÞÍ® £6÷å²^2ÞcÆ¢–©#x{ßEÁ>øìž}PñB5P²…áÑJȕË0ê8Œ}“ÒŠ˜á›…CÝEFûî$©Wç—ä'L}תMœIÍˉ%o‹Ò‰_Õ¥a‰`¥Ì­×ÝÊдžáωty69àîÆæSHjÊuKäJÏJ‘aÌ?3u³Îý`Ì®ÞÚi®¥|5¡GÇOc9i¢e¡ã⇣÷iQ7aÜô-<’uÄÉÔqpb—Y£ì)ܖ™gÉ{pñӜ¤P¾IJ„i“ùÒýùx0ØÀˆ[TÞ9;ÍÂ

Datetime with milliseconds?

I'm working on a system that deals with data with second resolution. The data type we are using is not the MySQL DATETIME but the MySQL UNSIGNED INT and we save the datetime as UNIX_TIMESTAMP. By this way we managed to reduce by 4 bytes the storage needs of each record. We also reduce the index siz

RE: looking for direction on how to debug this message

Hello, I have looked at the two supplied links and still have some more questions These errors I get about every 4 to 10 minutes. I get them from 3 different application servers. If I do this mysqld --debug=d,info,error,query,general,where:O,/tmp/mysqld.trace What kind of info can I expect to