Re: Can these two queries be combined into one?

Is there anyway to combine these 2 queries into 1? Is this what you mean? -- list all prods-cats SELECT p.prod_id, c.category FROM product_table p LEFT JOIN catproduct_table cp ON cp.product_id = p.product_id JOIN product_table p ON p.product_id = cp.product_id; ... or this ... -- group cats

Can these two queries be combined into one?

Hi, I'm currently using 2 queries to obtain some data and would like to know if I can combine these two queries into one query. I have a database with 3 tables: 1. A category table 2. A product table 3. A normalized "catproduct" table that is used to determine which product is in which ca

Spontaneous corrupted tables on MyISAM with 5.0.x release

Hi, our scenario (was): server1: 5.0.32-Debian_7etch1-log server2: 5.0.32-Debian_7etch1-log Hardware-wise (attention, Vmware, see below) they're equal: ~1GHz CPU at at minimum 2GB ram. Suddenly about 4 to 6 weeks ago, server1 started getting serious problems with spontaneous corrupted table

Re: Navicat MySQL GUI for Linux version 8.0.23 is released.

Hmm. Speaking of Navicat, does anybody out there have an easy way to scrub the control coding from scripts developed under Navicat? I expect that they're there mostly for coloration on displays, but it's kind of obnoxious when you want to do anything else with them. -- Barry -- MySQL Gene

Re: ON vs. WHERE

-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 11:50 AM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: ON vs. WHERE At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote: The documentation says (I think) that you should not use an ON j

GROUP question

I have two tables that (simplified) look like this: customers = customer_id [integer, autoincrement] email [varchar] memos = memo_id [integer, autoincrement] customer_id [integer] memo_text [varchar] There are some duplicate email addresses in the "customers" table. A customer might

Re: ON vs. WHERE

Are specifying the joins more optimal than using a multiple from and a where clause when doing an inner join? SELECT tbl1.*,tb2.* FROM tbl1, tbl2 WHERE tbl1.col1=tbl2.col2; vs. SELECT tbl1.*,tb2.* FROM tbl1 JOIN tbl2 ON tbl1.col1=tbl2.col2; vs. SELECT tbl1.*,tb2.* FROM tbl2 JOIN tbl1 ON tbl1

Re: transfer huge mysql db

On Jan 30, 2008, at 10:44 AM, Jerry Schwartz wrote: mysqldump -A > file.dump tar -jcf file.dump rsync [JS] You could also just pipe the output of mysqldump through gzip. tar buys you nothing, since it is a single file. -j is the bzip2 compression option. :) [JS] Yes, but tar is just extra b

Re: different results between FULLTEXT search and LIKE search

--- Lamp Lists <[EMAIL PROTECTED]> wrote: > > --- Lamp Lists <[EMAIL PROTECTED]> wrote: > > > hi, > > I created table "tasks" > > create table tasks( > > task_id, int(4) not null primary key, > > task text not null, > > resolution text not null, > > fulltext (task, resolution) > > )engine=my

Strange result of Group by on real values

Evening, Could someone explain the result of the Query 2? Query 2 does a GROUP BY avgOctets, but still there are duplicate avgOctets in my result set! Boxplot(octets,"AVG",0) is a UDF which returns REAL values. In this case, the real values have no decimals. The only reasonable explanation I could

Re: different results between FULLTEXT search and LIKE search

--- Lamp Lists <[EMAIL PROTECTED]> wrote: > hi, > I created table "tasks" > create table tasks( > task_id, int(4) not null primary key, > task text not null, > resolution text not null, > fulltext (task, resolution) > )engine=myisam > > when I run > > seect * from tasks match(task,resolution

RE: ON vs. WHERE

> -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 30, 2008 11:50 AM > To: Jerry Schwartz; mysql@lists.mysql.com > Subject: Re: ON vs. WHERE > > At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote: > >The documentation says (I think) that you should n

different results between FULLTEXT search and LIKE search

hi, I created table "tasks" create table tasks( task_id, int(4) not null primary key, task text not null, resolution text not null, fulltext (task, resolution) )engine=myisam when I run seect * from tasks match(task,resolution) against('"certain service"' in boolean mode) I would get one reco

Re: ON vs. WHERE

At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote: The documentation says (I think) that you should not use an ON join condition when you can use a WHERE, but I'm pretty sure someone from MySQL.com posted a message suggesting the opposite. The manual says this: "The ON conditional is any conditi

ON vs. WHERE

The documentation says (I think) that you should not use an ON join condition when you can use a WHERE, but I'm pretty sure someone from MySQL.com posted a message suggesting the opposite. Aside from LEFT JOINs, which require an ON, does anyone have any opinions or experience? Regards,

Looking for a more efficient way to achieve the same result.

Hello, I'm in the process of programming a customer area with a list of subscriptions : Reference | Title | Type | Date of first subscription | Expires Each item in this list will have a link to it's details with will show a list like this : Subscribed on : date of first subscription Renewed

Re: Decimal - Maximum is 30

Eli Shemer wrote: Is there any possible way to increase this limit ? I'm curious to know what it is you're doing where you need accuracy better than one part in a nonillion. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

RE: transfer huge mysql db

> >> mysqldump -A > file.dump > >> tar -jcf file.dump > >> rsync > > > > [JS] You could also just pipe the output of mysqldump through gzip. > > tar buys > > you nothing, since it is a single file. > > -j is the bzip2 compression option. :) [JS] Yes, but tar is just extra baggage. Regards, Jerry

Re: feature request: statement SELECT...(INSERT|UPDATE) :)

> On Jan 30, 2008 12:50 PM, Dmitry E. Oboukhov wrote: > > Is it possible to add to the syntax of the INSERT operator appoximately > > in such way: > > SELECT list INSERT [IGNORE] INTO ... - an added one. > > SELECT list UPDATE - an added one. > > > PS: I understand that adding the changes i

Re: feature request: statement SELECT...(INSERT|UPDATE) :)

On Jan 30, 2008 12:50 PM, Dmitry E. Oboukhov wrote: > Is it possible to add to the syntax of the INSERT operator appoximately > in such way: > SELECT list INSERT [IGNORE] INTO ... - an added one. > SELECT list UPDATE - an added one. > PS: I understand that adding the changes into a language i

feature request: statement SELECT...(INSERT|UPDATE) :)

Hi! I use mysql on amateurish level mainly for personal needs and so please forgive me if this feature request is impossible to fulfil or if it is sent to the wrong mail-list, or if this functionality has been already realized in other ways :) Note: I've read the discription of C-function mysql_i

Navicat MySQL GUI for Linux version 8.0.23 is released.

By Premiumsoft. Navicat MySQL GUI Manager is a powerful yet easy to use MySQL client provides extensive functionality for managing and developing MySQL. It features an intuitive interface and provides a set of useful tool to import/ export, backup/ restore data, Synchronize database and connect to