Re: When to use Stored Procedures

Shawn Green wrote: Tompkins Neil wrote: Hi, I've used mainly of the older versions of MySQL. However am looking to port a application across to MySQL 5. My question is when would one decide to use a Stored Procedure over a query written at the application level ? The decision to encap

Complex Query

I have three tables from which I need to query for a keyword. The 3 tables are products, productsubcategories and productcategories. Fron these three tables, I need to query for a product name or keywork starting with the products table. if the keyword is not found in the product name or product_de

Re: accounting program unable to detect our usb key lock

Jae Choe wrote: From: master...@masterchoe.com To: mysql-wi...@lists.mysql.com Subject: unable to open and operate our accounting program due to computer's inability to detect our usb key lock. Description: Our martial arts school's accounting program is inaccessible because it is unable to

Re: CLI can't read data from table

On Wednesday 14 April 2010 7:39:03 pm Dan Nelson wrote: > In the last episode (Apr 14), Mike Diehl said: > > On Wednesday 14 April 2010 5:49:43 pm Jesper Wisborg Krogh wrote: > > > Lines is a reserved keyword (e.g. like in "LINES TERMINATED BY"), so it > > > must be quoted: > > > > > > test> use te

accounting program unable to detect our usb key lock

From: master...@masterchoe.com To: mysql-wi...@lists.mysql.com Subject: unable to open and operate our accounting program due to computer's inability to detect our usb key lock. Description: Our martial arts school's accounting program is inaccessible because it is unable to detect our usb key

Re: When to use Stored Procedures

Tompkins Neil wrote: Hi, I've used mainly of the older versions of MySQL. However am looking to port a application across to MySQL 5. My question is when would one decide to use a Stored Procedure over a query written at the application level ? The decision to encapsulate a particular proce

RE: Make delete requests without impact on a database

Hi evryone, Thank you for the advice. I will analyze the differences between InnoDB and MyISAM before switching. Moreover, there is a lot of indexes on the tables. I was thinking about tunning the MySQL server. Do you know how can I benchmark the tunning of the server before doing the tunning?

Re: difference btw Analyze and Optimize table..

thanks to you and everyone involved in this mail thread.. after optimize the table. i can see huge performance improvement.. thanks again.. Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Tue, Apr 13, 2010 at 11:35 PM, Suresh Kuna wrote: > Analyze table : > > Analyze t