Re: more queries vs a bigger one

Hi, I have finally modified that long query and splitted into smaller ones. Now the main query is: select sql_calc_found_rows a.pre_title, a.title, a.post_title, substring(a.body, 1, 250) as preview, a.hash, a.date, a.time, length(a.body) as size, a.id_categories, n.name as newspaper,

UNION in JDBC - WAS Re: use of indexes

Hello again Following on from this index question, the UNION worked. From a normal mysql client, it was returning my results sub-second. I am actually executing this over JDBC, using mysql-connector j. WHen I put the SQL into my Java program - it takes a minute or so. I am logging the SQL and if

variable type

Hi, is it possible that int variable type negative number? If not, what type of variable if I need a negative number - Start your day with Yahoo! - make it your home page

What does this error mean?

Hi, I have tried the following query and it works fine. It takes 11 seconds and this is a little too much, but this is another issue. The problem is that if I delete the following condition from it: a.id_categories=31 The query gives the following error: ERROR 1032 (HY000): Can't find record

Re: variable type

Eko Budiharto wrote: Hi, is it possible that int variable type negative number? If not, what type of variable if I need a negative number Yes. INTs support the range -2147483648 to 2147483647. MySQL's column types are documented in the manual

Re: Innodb Questions

Dan Tappin wrote (quotes from several posts, my thoughts interspersed): I am running into repeatable table corruption with MySQL 4.x on Mac OS X 10.x. Many people, myself included, are running mysql 4.x on OS X without reporting this sort of problem, so the trick is to find out what your

Alternatives to performing join on normalized joins?

I have a large number of job titles (40K). Each job title has multiple keywords making a one-to-many parent-child relationship. If I join job title with company name, address, company url, company city, job name, job location, job url (etc...) I have a mighty wide result set that will be repeated

COLLATE: Do I need a new version?

Hi, COLLATE does not work in the way it is described on this page. I have mysql version: Ver 12.22 Distrib 4.0.21, for suse-linux (x86_64) Is it possible that it is a version problem? Thanx Wolle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Innodb Questions

On Jul 24, 2005, at 9:13 AM, Michael Stassen wrote: Dan Tappin wrote (quotes from several posts, my thoughts interspersed): I am running into repeatable table corruption with MySQL 4.x on Mac OS X 10.x. Many people, myself included, are running mysql 4.x on OS X without reporting

Re: COLLATE: Do I need a new version?

At 18:20 +0200 7/24/05, Christian Wollmann wrote: Hi, COLLATE does not work in the way it is described on this page. I have mysql version: Ver 12.22 Distrib 4.0.21, for suse-linux (x86_64) Is it possible that it is a version problem? Yes, you need 4.1. Please see the intro to the