Martijn Tonies schrieb:
> Hi,
>
>> I have a rather basic problem I would be glad to get some help:
>> What I intend to do is:
>> - create a person-list
>> - create a buddy-list
>> each entry in the person-list can have 0 to many buddies
>> - when an entry in the person-list is deleted, I would
Hi,
> I have a rather basic problem I would be glad to get some help:
> What I intend to do is:
> - create a person-list
> - create a buddy-list
> each entry in the person-list can have 0 to many buddies
> - when an entry in the person-list is deleted, I would like to
> have correspnding ent
hi there,
I have a rather basic problem I would be glad to get some help:
What I intend to do is:
- create a person-list
- create a buddy-list
each entry in the person-list can have 0 to many buddies
- when an entry in the person-list is deleted, I would like to
have correspnding entries in
Hi Daniel,
> Jigal, thank you very much. However, this does not resolve my issue.
>
> even when querying:
> SELECT * FROM ae_articles AS art LEFT JOIN ae_articlesections AS sec ON
> art.ID=sec.articleID WHERE art.title LIKE '%bush%' AND sec.sectionID IN
(1,2)
> AND sec.sectionID NOT IN (3)
What *
yntax.
You can find info on joins at:
http://dev.mysql.com/doc/mysql/en/join.html
Regards, Jigal.
- Original Message -
From: "Dan Duris" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 23, 2005 10:35 AM
Subject: mysql exclusion query with JOIN (request for help)
> Anyon
Anyone knows who to make exclusion query when table is referenced via JOIN:
SELECT * FROM ae_articles AS art
LEFT JOIN ae_articlesections AS sec ON art.ID=sec.articleID
LEFT JOIN ae_articlesections AS sec2 ON art.ID=sec2.articleID
LEFT JOIN ae_articlesections AS sec3 ON art.ID=sec3.articleID
WHERE
: Sunday, September 01, 2002 3:35 AM
Subject: Request for help - Table Crashing
> Hello,
>
> This is my 2nd post, not to sound pushy, just raising the urgency of my
> dilemna. My table is crashing way to often (I'd like it to not crash at
> all).
> I'm not sure w
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the pert
Andreas,
If anyone else is interested, I have solved the problem in stepwise/tutorial fashion
below (best viewed using a
fixed font).
If anyone is skilled in the user of FROM...JOINs, (I'm sure Andreas, and) I'd welcome
a critique/any
improvements!
I have taken a look at this problem, and bein
That would be great. Thanks!
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message-
> From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 10:45 pm
> Subject: RE: Request for help in testing new replication code in 4.0.2
Is there anyone who could help me with this "simple" query.
Did i ask anything in a wrong way because I still got no answers to my
request?
SELECT at.name, av.value, at.unit, at.id, a.product_id
FROM attribute_type at
LEFT OUTER JOIN attribute a on (at.id = a.type_id)
LEFT OUTER JOIN attrib
it up if it's something you might find useful.
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:41 PM
To: 'Sasha Pachev'
Cc: 'Mysql'
Subject: Re: Request for help in testing new replication code in 4.0.2
&g
X]
> Sent: Sunday, February 10, 2002 3:28 PM
> To:
> Subject: Re: Request for help in testing new replication code in 4.0.2
>
>
> On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn
> [Presence-PC] wrote:
> > Hi,
> >
>
> > * If you want to do it this very moment, read the instructions at
> >http://www.mysql.com/doc/I/n/Installing_source_tree.html and
install a
> > pre-release 4.0.2 MySQL on your test server. You may also wait until
4.0.2 is
> > released, but in that case, replication in 4.0.2 may have a bug
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> So I need your help with field testing of my code. For those of you
> who are wondering why you should - this will help us stabilize 4.0 a
> lot of faster, and not only replication, but also the general SQL
> features. So if you de
I don't actually see the error message in the output you sent. but I found a
similar problem yesterday and have the following work around:
= myisamchk.c 1.69 vs edited =
*** /tmp/myisamchk.c-1.69-20535 Thu Feb 7 17:21:33 2002
--- edited/myisamchk.c Sat Feb 9 22:48:57 2002
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> In myisamchk.c replace the following line :
>
>if (argument && *argument == '0')
> DBUG_POP();
> else
> DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
>
> by
>
> if
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
Dear MySQL users,
I have just pushed my latest changes in the replication code in our 4.0
development tree, which change the slave to use two threads - I/O thread that
gets the data from the master and logs it, and SQL thread which processes the
logged data. I have tested it extensively, and i
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> Dear MySQL users,
>
> I have just pushed my latest changes in the replication code in our
> 4.0 development tree, which change the slave to use two threads -
> I/O thread that gets the data from the master and logs it, and SQL
> thre
> * If you want to do it this very moment, read the instructions at
>http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a
> pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2
is
> released, but in that case, replication in 4.0.2 may have a bug you cou
On Sunday 10 February 2002 02:20 pm, Jeremy Zawodny wrote:
> I run `BUILD/compile-pentium --prefix=/home/mysql` and it fails after
> several minutes. ?The output is large, so I've posted it here:
>
> ? http://public.yahoo.com/~jzawodn/mysql-build.log
>
> (the good stuff is at the end, of course.
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
On Sunday 10 February 2002 06:06 pm, Jeremy Zawodny wrote:
> One question:
>
> ? Can you explain the relay log a bit. ?Does it shrink eventually? ?I
> ? see it growing and growing, so I don't know if the space is
> ? recycled, or if I need to do something to periodically flush the
> ? executed qu
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> So I need your help with field testing of my code. For those of you
> who are wondering why you should - this will help us stabilize 4.0 a
> lot of faster, and not only replication, but also the general SQL
> features. So if you de
I don't actually see the error message in the output you sent. but I found a
similar problem yesterday and have the following work around:
= myisamchk.c 1.69 vs edited =
*** /tmp/myisamchk.c-1.69-20535 Thu Feb 7 17:21:33 2002
--- edited/myisamchk.c Sat Feb 9 22:48:57 2002
On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> In myisamchk.c replace the following line :
>
>if (argument && *argument == '0')
> DBUG_POP();
> else
> DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
>
> by
>
> if
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> Dear MySQL users,
>
> I have just pushed my latest changes in the replication code in our
> 4.0 development tree, which change the slave to use two threads -
> I/O thread that gets the data from the master and logs it, and SQL
> thre
> * If you want to do it this very moment, read the instructions at
>http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a
> pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2
is
> released, but in that case, replication in 4.0.2 may have a bug you cou
Dear MySQL users,
I have just pushed my latest changes in the replication code in our 4.0
development tree, which change the slave to use two threads - I/O thread that
gets the data from the master and logs it, and SQL thread which processes the
logged data. I have tested it extensively, and i
Hello, everyone. Some of you may be aware that MySQL source and binary
distribution comes with a public test suite. Some documentation on it is
available at http://www.mysql.com/doc/M/y/MySQL_test_suite.html. But it is
terribly lacking, as evidenced by the fact that we have not had one user
su
34 matches
Mail list logo
