Re: self-joins in hierarchical queries: optimization problem

Dear Michail and Sergey, Thank you very much for your responses and kind suggestions! On 29.10.2009, at 16:53, Sergey Petrunya wrote: this makes it clear that index on O1.tsn will not be useful. You need indexes on parent_tsn column. mysql alter table taxonomic_units1 add index

insert warning - how to look at

Hello, I have an application which is inserting rows into a Mysql 5.024 db. It seems to stop when an insert generates a warning. when I insert the suspect line on the mysql commandline I get this: Query OK, 1 row affected, 1 warning (0.05 sec) Other inserts that succeed seem not to generate

Re: insert warning - how to look at

Hi, mysql show warnings; BR johan Sydney Puente wrote: Hello, I have an application which is inserting rows into a Mysql 5.024 db. It seems to stop when an insert generates a warning. when I insert the suspect line on the mysql commandline I get this: Query OK, 1 row affected, 1 warning

Re: insert warning - how to look at

Thanks johan, Very useful - it seems so obvious now! There is an associated problem with transferring data into mysql. because if the application pushing the data finds a warning it just silently stops. anyway I can detect a warning 1265 Data truncated on the mysqldb? and make this visible - at

RE: insert warning - how to look at

-Original Message- From: Sydney Puente [mailto:sydneypue...@yahoo.com] Sent: Friday, October 30, 2009 10:36 AM To: mysql@lists.mysql.com Subject: Re: insert warning - how to look at Thanks johan, Very useful - it seems so obvious now! There is an associated problem with transferring data

insert .. values('OH'No')

Hello, I am populating mysql with data, from an external source, that now and again in different fields has single quotes within the data intended to be inserted into varchars. This causes a sql parse error. Is there are smart way of dealing with this? TIA Syd

Re: insert .. values('OH'No')

Yes, there are plenty of smart ways to deal with this. Each of them is somewhat dependant on whatever general purpose programming language you are using and/or the environment you are working in. In PHP we have mysql_escape_string() or PDO, in perl and Java, among others, prepared statements are

which mysql 64 bit binary for PowerEdge 1950 ?

Hello Everyone, I would like to verify that which mysql 64 bit binary i need to use for PowerEdge 1950 ? Will it be *IntelEM64T* ? Following is the cpu info Processor 1 Processor Brand: Intel(R) Xeon(R) CPU E5310 @ 1.60GHz Processor Version : Model 15