On 07/04/2013 01:15 PM, Emmy Santi wrote:
my name is Effiong Emmanuel.I love your products and your ways of helping
human.pls can you send me MYSQL COMPILER to enable me install it in my laptop
computer and practice.I will be gratefull if my request is kindly granted.
what do you refer to
my name is Effiong Emmanuel.I love your products and your ways of helping
human.pls can you send me MYSQL COMPILER to enable me install it in my laptop
computer and practice.I will be gratefull if my request is kindly granted.
d me MYSQL COMPILER to enable me install it in my laptop
computer and practice.I will be gratefull if my request is kindly granted.
what are you speaking about?
what is a "mysql compiler"?
Am 03.07.2013 14:50, schrieb Emmy Santi:
> my name is Effiong Emmanuel.please, I love your products and your ways
> helping human.pls can you send me MYSQL COMPILER to enable me install it in
> my laptop computer and practice.I will be gratefull if my request is kindly
> grante
... ) to do the same type of thing?
>>>>
>>>>If the argument to IN() is a list of values, it'll be OK. If it's a
>>>>SELECT, in 5.0 it will be slower than molasses (see "The unbearable
>>>>slowness of IN()" at http://www.artful
is would be fine. But often, the list of friends is obtained
from a social network like facebook, and is not stored internally.
Basically, I obtain the friend list in a request to facebook, and then
see which of those users have created things. So would I have to create
a temporary table and insert
- Original Message -
> From: "mos"
>
> The IN() clause is very inefficient because MySQL will NOT use the
> index.
> It will have to traverse the entire table looking for these values.
Has that still not been remedied ?
> It will get the information from the index and not have to acce
the list of friends is obtained from
a social network like facebook, and is not stored internally. Basically,
I obtain the friend list in a request to facebook, and then see which of
those users have created things. So would I have to create a temporary
table and insert all those uids just to make
- Original Message -
> From: "Gregory Magarshak"
> I am guessing that the MySQL indexes map indexed fields (fb_uid) to the
> primary key (id) so I wouldn't have to touch the disk. Am I right
> about that?
Correct for InnoDB, but MyISAM maps every index straight onto records. That's
why
obtained
from a social network like facebook, and is not stored internally.
Basically, I obtain the friend list in a request to facebook, and
then see which of those users have created things. So would I have
to create a temporary table and insert all those uids just to make a
join? Why not optimi
ta.
A severe & unfortunate constraint. Can't help you there.
PB
-
On 3/29/2011 1:27 PM, Gregory Magarshak wrote:
Yes, this would be fine. But often, the list of friends is obtained
from a social network like facebook, and is not stored internally.
Basically, I obtain the frien
Hi Gregory,
Are you sure you'd like to do this using MySQL? What would happen if you
start using sharding?
Maybe you could consider using a stack (stored in a tool like Redis?).
Whenever some user adds some item, you add primary key of the new item
to the "network updates" stack of each frie
l network like facebook, and is not stored internally.
Basically, I obtain the friend list in a request to facebook, and then
see which of those users have created things. So would I have to
create a temporary table and insert all those uids just to make a
join? Why not optimize the IN ( ... ) to do
Yes, this would be fine. But often, the list of friends is obtained from
a social network like facebook, and is not stored internally. Basically,
I obtain the friend list in a request to facebook, and then see which of
those users have created things. So would I have to create a temporary
> How can I quickly find all the articles written by this user's
friends, and not just random articles?
Taking the simplest possible case, with table friends(userID,friendID)
where each friendID refers to a userID in another row, the friends of
userID u are ...
select friendID from user wher
Hey there. My company writes a lot of social applications, and there is
one operation that is very common, but I don't know if MySQL supports it
in a good way. I thought I'd write to this list for two reasons:
1) Maybe MySQL has a good way to do this, and I just don't know
about it
2
This is mysql-independent
If your php-scripts using sessions the session.file
is locked until end of the request, so if there
are multiple requests (as sample framesets) you
have to decide the point where are no wirtes
into the $_SESSION-Array are expected and use
session_write_close()
Directly
This must be a newbie question!
I'm not sure if this is either PHP / MySQL / Apache problem, so any help is
appreciated. I have a XAMPP setup in my PC.
Shortly, I have a two seperate codes as the following,
Code_A.php - looping code. this may take several minutes
Code_B.php - a quick simple echo
it's worth a try -- the manual for 4.1 has the same text about ORDER BY in
section 14.7.
On 4/28/10 12:30 PM, "David Florella" wrote:
> Hi,
>
> Thanks to you and everyone.
>
> I will test the same request with the ORDER BY clause.
>
> Regards,
>
Hi,
Thanks to you and everyone.
I will test the same request with the ORDER BY clause.
Regards,
David.
-Message d'origine-
De : Mattia Merzi [mailto:mattia.me...@gmail.com]
Envoyé : mercredi 28 avril 2010 17:54
À : mysql@lists.mysql.com
Objet : Re: Replication : request D
AFAIR you can use LIMIT with replication only if you use row-based
replication (or mixed), that means that you must use mysql 5.1.
Greetings,
Mattia.
2010/4/28 Tom Worster :
> 16.3.1.9. Replication and LIMIT
> Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
> statements is
: 'Krishna Chandra Prajapati'
>> Subject: RE: Replication : request DELETE is not executed on slave
>>
>> Hi,
>>
>> In the MySQL documentation, it is written that the two versions are
>> compatible to make a replication.
>>
>> It seems th
>-Original Message-
>From: David Florella [mailto:dflore...@legos.fr]
>Sent: Wednesday, April 28, 2010 10:51 AM
>To: mysql@lists.mysql.com
>Cc: 'Krishna Chandra Prajapati'
>Subject: RE: Replication : request DELETE is not executed on slave
>
>Hi,
&g
andra Prajapati [mailto:prajapat...@gmail.com]
Envoyé : mercredi 28 avril 2010 11:15
À : dflore...@legos.fr
Cc : mysql@lists.mysql.com
Objet : Re: Replication : request DELETE is not executed on slave
Hi dflorella,
The important thing about mysql replication is same mysql version for both
master as well as
he version of the slave is 5.0.41
>
>
>
> When I use the query '' DELETE QUICK FROM [TABLE] WHERE [field] < 'xx'
> LIMIT 7500", the query is executed on the master but not on the slave.
>
>
>
> Do you know why the request is not executed on the slave?
>
>
>
> Regards,
>
>
>
> David.
>
>
master but not on the slave.
Do you know why the request is not executed on the slave?
Regards,
David.
On Mon, Dec 7, 2009 at 8:08 AM, Tom Worster wrote:
> On 12/7/09 5:26 AM, "Victor Subervi" wrote:
>
> > Hi;
> > I posted this Saturday. Perhaps it's too challenging for those who read
> it
> > to answer. I hope someone can.
> >
> > I need to write a select statement that enables me to select colu
On 12/7/09 5:26 AM, "Victor Subervi" wrote:
> Hi;
> I posted this Saturday. Perhaps it's too challenging for those who read it
> to answer. I hope someone can.
>
> I need to write a select statement that enables me to select column 'ID'
> from a table where a certain value is found in an enum of
Hi;
I posted this Saturday. Perhaps it's too challenging for those who read it
to answer. I hope someone can.
I need to write a select statement that enables me to select column 'ID'
from a table where a certain value is found in an enum of a specific column.
For example...
select column_type fro
>-Original Message-
>From: walterh...@gmail.com [mailto:walterh...@gmail.com] On Behalf Of
>Walter Heck
>Sent: Wednesday, February 25, 2009 11:43 PM
>To: Jerry Schwartz
>Cc: Gary W. Smith; Claudio Nanni; MySql
>Subject: Re: Upgrade story / request for insight
>
&g
Subject: RE: Upgrade story / request for insight
>
>
>
> Jerry,
>
>
>
> To touch a little more on Claudio's statement, you are trying to compare
> monkey's and trucks when you talk about mysql on these two different OS's.
> Microsoft is a different best wh
From: Gary W. Smith [mailto:g...@primeexalia.com]
Sent: Wednesday, February 25, 2009 4:36 PM
To: Claudio Nanni; Jerry Schwartz
Cc: MySql
Subject: RE: Upgrade story / request for insight
Jerry,
To touch a little more on Claudio's statement, you are trying to compare
monkey's
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, February 25, 2009 3:51 PM
To: Jerry Schwartz
Cc: MySql
Subject: Re: Upgrade story / request for insight
Hi Jerry,
probably does not help you very much and excuse me in advance for this,
[JS] No apology necessary.
but
some lib issues with the older CentOS.
Gary
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wed 2/25/2009 12:50 PM
To: Jerry Schwartz
Cc: MySql
Subject: Re: Upgrade story / request for insight
Hi Jerry,
probably does not help you very much and excuse me
Hi Jerry,
probably does not help you very much and excuse me in advance for this,
but there is little use in having a development/preproduction system on
different architecture,
none of the issues you faced with windows (services installation probably)
will show up on a CentOS box.
In particular an
My ultimate goal is to upgrade a production server (MySQL 4.1.22 on CentOS)
to a modern 5.1 release. My development system is a Windows Vista x86
machine, and although the process is not that similar I decided to try an
upgrade there. (I've never done one.) I figured this would give me some
insight
-
> *From:* Krishna Chandra Prajapati
> *To:* cr.vege...@gmail.com
> *Cc:* J Trahair ; MySQL
> General
> *Sent:* Tuesday, January 20, 2009 3:48 PM
> *Subject:* Re: Applying an XML request to a database
>
> Yes
>
> On Tue, Jan 20, 2009 at 7:40 PM, wrote:
>
>&g
andra Prajapati" <
> prajapat...@gmail.com>
> To: "J Trahair"
> Cc: "MySQL General"
> Sent: Tuesday, January 20, 2009 10:28 AM
> Subject: Re: Applying an XML request to a database
>
>
>
> Hi,
>>
>> You can use -X for xml and -H
005
1.1.1
1126267377
11
1072005
1.1.2
1126267388
-999
2 rows in set (0.03 sec)
On Tue, Jan 20, 2009 at 2:29 PM, J Trahair
wrote:
> Hi Everyone
>
> I am interested in how to get an XML request to query a database. I'm
&
Hi Everyone
I am interested in how to get an XML request to query a database. I'm working
on generating the XML requests OK, I just need to know how XML meets database.
Are there any generalised pointers to begin with?
Thanks in advance
Jonathan Trahair
On Fri, Sep 26, 2008 at 1:54 AM, Aaron Blew <[EMAIL PROTECTED]> wrote:
> Hi Michael,
> Overall and most of the time, SANs are a good thing. They have several
> advantaged over dedicated directly attached storage arrays:
> 1.) They're generally a lot smarter about how and when they write and read
IO also depends on how many DISK controllers are used. The more controllers,
better would be IO distribution among spindles
On 9/26/08, Aaron Blew <[EMAIL PROTECTED]> wrote:
>
> Hi Michael,
> Overall and most of the time, SANs are a good thing. They have several
> advantaged over dedicated direct
Hi Michael,
Overall and most of the time, SANs are a good thing. They have several
advantaged over dedicated directly attached storage arrays:
1.) They're generally a lot smarter about how and when they write and read
to the disks. Often they understand what's going on down at the head level,
and
Hello all,
I recent started employment with a company which has a lot of mysql
servers (100+ is my best estimate so far) and have all of their
database servers, masters and slaves alike, using one of 2 SANs for
data storage. They servers are connected to dedicated switches with
fibre to to SANs
> 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
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
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-fun
Sounds like you should create a MERGE table that links all the
underlying tables together. Then you just query the merge table and
MySQL handles which tables it needs to pull data from. You also then
don't need to query for the tables.
On Jan 9, 2008, at 9:12 AM, Cx Cx wrote:
Hi List,
I
Hi List,
I am wondering if someone can help me with a query to check what databases
are on the MySQL server and then check which of those databases are either
partially or completely within the date range i require.
The scenario is as follows:
db1 : 2007-01-01 to 2007-02-01
db2 : 2007-02-01 to 2
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,
On Thu, June 14, 2007 18:16, Jake Peavy wrote:
> Hi all,
>
> Can someone suggest a good method or normalized schema for storing product
> information (id, description, price) which changes over time so that as a
> product is gradually discounted, an order will reflect the cost of that
> partic
Hi all,
Can someone suggest a good method or normalized schema for storing product
information (id, description, price) which changes over time so that as a
product is gradually discounted, an order will reflect the cost of that
particular product at that particular time?
--
-jp
At birth, Chuck
> Daevid Vincent wrote:
> [snip]
> > Also, it would be great if mysql client was "smart" enough
> to limit my
> > tab completion choices to possibilities based upon the
> current SQL query
> > I'm crafting. So If I have:
> >
> > "select t[TAB] from ResolveTable join Tickets;"
> >
> > It shoul
Hi,
Daevid Vincent wrote:
[snip]
Also, it would be great if mysql client was "smart" enough to limit my
tab completion choices to possibilities based upon the current SQL query
I'm crafting. So If I have:
"select t[TAB] from ResolveTable join Tickets;"
It should only show me columns that sta
Is there a way to get the full table.column always in mysql client when
using the auto-tab completion feature? I'm currently using 5.0.36.
The way it works now is a bit confusing. Notice I have TWO different
"DateOnly" columns (for example) in two different tables. [middle
column]
mysql> select
Hello
My name is Lara Thynne and I am a PhD candidate at Deakin University
Australia. I am currently researching the boundary between work and
leisure activities directly related to the open source community and
open source program development.
As part of this I am running a survey at the follo
sql.com/doc/refman/5.1/en/string-comparison-functions.html
Thanks
ViSolve DB Team.
- Original Message - From: "Gabriel Linder"
<[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Friday, January 19, 2007 9:43 PM
Subject: Request problem (with \\)
Hello list,
I am cu
B Team.
- Original Message -
From: "Gabriel Linder" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Friday, January 19, 2007 9:43 PM
Subject: Request problem (with \\)
Hello list,
I am currently trying to fix a bug in a search function with a request
like this one
Hello list,
I am currently trying to fix a bug in a search function with a request
like this one :
select * from forum where topic like '%[...]%' ;
where [...] is a string escaped by mysql_real_escape_string (C API) and
topic is a varchar field (not null).
It works, but there i
Hmmm, I have the urge to tell this guy to take hike...
- Original Message -
From: "George McFee" <[EMAIL PROTECTED]>
To:
Sent: Saturday, September 16, 2006 10:00 AM
Subject: Link request from a Hiking Forums
Hello,
My name is George and I'm from http://www.hik
Hello,
My name is George and I'm from http://www.hikingforums.net/.
While visiting your site I have noticed that you are collaborated with other
sites, and I wish to invite you to work with my website as well.
If you can support Hiking Forums by adding a link to your site, I'll be happy
to l
Hello All,
I am not a database person and I am just using mysql database to store some
factory parameters. I am running my code over a cluster and I am having the
problem of connection with the server. We have a 64 node cluster and all node
request connections to the mysql server. Sometimes
Would like to see this, there is a TMD temp table created during an optimize
is there any reason read only access cant take place during the optimize
process? Update/delete/insert shouldn't, but read access should be
allowed on myisam
any thoughts on this?
--
MySQL General Mailing List
Fo
Sheeri,
- Original Message -
From: ""sheeri kritzer"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 28, 2006 9:29 PM
Subject: problems/feature request ideas
2 weeks ago we had a server crashing, and while I was checking it out
2 weeks ago we had a server crashing, and while I was checking it out
(before, during and after crashes) I noticed that after a crash, the
server was slow. Threads would run for 200 seconds or more, and yet
when they finished, nothing was written to the slow query log.
Why would that be? Slow qu
Yesmin Patwary <[EMAIL PROTECTED]> wrote on 03/22/2006 09:56:20 AM:
> Dear All,
>
> First of all, I would like to thank Shawn Green, Peter Brawley and
> Josh for their kind help in my previous issue.
>
> I have a table named master_list with two field customer_id and
> list_code. I need to
Dear All,
First of all, I would like to thank Shawn Green, Peter Brawley and Josh for
their kind help in my previous issue.
I have a table named master_list with two field customer_id and list_code. I
need to insert only non existent records in master_list from a child_list. Both
ma
per request.
whats going wrong here, it's a simple basic query..
updates only 1 record (should update 4 records)
---
update tbl_lager
set
fld_shopid=0
,fld_orderid=0
where
fld_orderid=10
and
fld_shopid=3
repeating this query 4 times updates 1 r
Thank you for your email support request.
Our support team will respond with the recommended solution in the quickest
time possible, but may be delayed due to the complexity of the problem or
volume of requests for support".
Once we have replied to your initial question, please be sure t
Bruce Carey wrote:
> - my problem is that when a text field, with html in it, it makes it
> into several hundred recs
Well, that's strange -- I use mysqldump to dump/xfer/load records
with fields containing HTML regularly, using the mysqldump defaults,
and have no problems.
Have you tried the de
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different line/r
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different lin/re
Bruce Carey wrote:
> I posted this earlier, could someone take a look at it?
In the time since you first posted, you could have at least glanced
at the Fine Manual :-) which shows that:
>> mysqldump --opt --fields-terminated-by='\t'
>> --fields-optionally-enclosed-by='#*#*#'
Any of the field-
I posted this earlier, could someone take a look at it?
TIA,
Bruce.
On Mon, 19 Dec 2005 02:15:54 -0500
"Bruce Carey" <[EMAIL PROTECTED]> wrote:
Hi List,
I have recently had a crash coursh in the fineer points
of db recovery due to a mis-managed server.
Could someone help me out with advi
> Hi Dan,
>
> Dan Bolser wrote:
Who can I prod about setting up a UDF repo at MySQL. I think 'they'
should
do this ;)
>>> Yep it's an existing idea, a very good one, and it's on the todo.
>>> Putting such an infrastructure into place will take some time though.
>>
>> I can imagine it
Hi Dan,
Dan Bolser wrote:
Who can I prod about setting up a UDF repo at MySQL. I think 'they' should
do this ;)
Yep it's an existing idea, a very good one, and it's on the todo.
Putting such an infrastructure into place will take some time though.
I can imagine it isn't trivial to set up.
W
Hello.
There could be a lot of reasons. First, are you able to connect
to MySQL using mysql command line client? If you are able then
what error do you see?
Krishna Chaitanya <[EMAIL PROTECTED]> wrote:
>
> sir,
> i am a software employee working in a firm.. i am not able to create a
sir,
i am a software employee working in a firm.. i am not able to create any
tables in to my mysql server .. plz suggest me the possible reasons for
it...
thanking u ,
c.krishna chaitanya
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
Hi,
You can use this template. The idea is the same. All your line commands for
certain task can be embedded in a single script :
http://webxadmin.free.fr/article/mysql-use-shell-script-to-dump-all-databases-t-54.php
Mathias
Selon "Jorgensen, Bill" <[EMAIL PROTECTED]>:
> MySQL guys:
>
>
>
> I
MySQL guys:
I am new to databases, MySQL, and anything outside of my world of UNIX
system administration. A former colleague of mine set up MySQL on our
backup server and I would like to interface with the database to get
reports. I have read a little and understand a few things. I have taken
t
, and make these minor changes. hence my
request for the same.
would be great if anyone could point out the possibility of this being
supported in the near future.
thx a ton..
AB
--
A great idea need not be complicated.
http://www.i-5.blogspot.com
--
MySQL General Mailing List
For list arch
re doing below) I don't necessarily get the same
> >> 'marginals' (or to randomly pick the same rows from either side of
the
> >> join) . This is analagous to sampling with replacement.
> >>
> >> Do you see what I mean?
> >>
> >>
&
On Mon, 11 Apr 2005, Arjen Lentz wrote:
>Hi Dan,
>
>On Sat, 2005-04-09 at 02:59, Dan Bolser wrote:
>> Who can I prod about setting up a UDF repo at MySQL. I think 'they' should
>> do this ;)
>
>Yep it's an existing idea, a very good one, and it's on the todo.
>Putting such an infrastructure into p
Hi Dan,
On Sat, 2005-04-09 at 02:59, Dan Bolser wrote:
> Who can I prod about setting up a UDF repo at MySQL. I think 'they' should
> do this ;)
Yep it's an existing idea, a very good one, and it's on the todo.
Putting such an infrastructure into place will take some time though.
Would a special
>>
>> Do you see what I mean?
>>
>>
>>
>>
>> >
>> >SELECT
>> > Dept,
>> > Gender,
>> > AVG(Spending)
>> >FROM
>> > table_one a
>> >CROSS JOIN
>> > table_two b
>> >WHERE (a
ROM
> > table_one a
> >CROSS JOIN
> > table_two b
> >WHERE (a.Person * b.Person) % 4 = 3
> >GROUP BY
> > Dept, Gender;
> >
> >Sean
> >
> >- Original Message --
> >
> >Hi,
> >
> >I have a request for a UDF
Who can I prod about setting up a UDF repo at MySQL. I think 'they' should
do this ;)
http://lists.mysql.com/community/97
Anyway I am posting this request to 'community' because I still don't know
the appropriate place to post UDF related stuff.
This is anoter (pote
ean?
>
>SELECT
> Dept,
> Gender,
> AVG(Spending)
>FROM
> table_one a
>CROSS JOIN
> table_two b
>WHERE (a.Person * b.Person) % 4 = 3
>GROUP BY
> Dept, Gender;
>
>Sean
>
>- Original Message --
>
>Hi,
>
>I have a request for
ssage --
Hi,
I have a request for a UDF that I would find really useful. I am
duplicating this question on the community list as well as the MySQL list,
because I am not sure where best to make this kind of request (see the
previous post http://lists.mysql.com/community/97).
I think the followi
ssage --
Hi,
I have a request for a UDF that I would find really useful. I am
duplicating this question on the community list as well as the MySQL list,
because I am not sure where best to make this kind of request (see the
previous post http://lists.mysql.com/community/97).
I think the followi
Hi,
I have a request for a UDF that I would find really useful. I am
duplicating this question on the community list as well as the MySQL list,
because I am not sure where best to make this kind of request (see the
previous post http://lists.mysql.com/community/97).
I think the following
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
Hello.
You can solve your problem using --all command line option
(--create-options after 4.1.2) which is on by default as of
MySQL 4.1.
Chris Elsworth <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a feature request for mysqldump that would greatly ease a
> c
Hello,
I have a feature request for mysqldump that would greatly ease a
current task I have; in my replicated setup my master is currently
MyISAM (as are most slaves), but I have one slave that is InnoDB for
testing.
Somehow or other, it's gotten itself out of sync, so I'm in the
p
OK I have a Fedora Core 3 Box running MySQL-server-4.1.8-0, when I try to
manage the users on that box using the windows version of MySQL
administrator version 1.0.19 I get errors.
When I add a new user it tells me:
error while storing user information
If I look at the mysql log file is shows t
A friend of mine, who is not a member of the MySQL email aliases, is working toward
her Bachelors degree. She is currently taking a database design course. She mentioned
her current assignment to me and I suggested she allow me to forward this request to
this email alias. I understand this is
1 - 100 of 347 matches
Mail list logo