Oops, that LEFT JOIN ADDRESS ON IF(etc...) shouldn't be in the big long select
statement
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
D, IF(CUSTOMER.ID_ADDRESS_SHIPTO > 0,
CUSTOMER.ID_ADDRESS_SHIPTO = ADDRESS.ID, CUSTOMER.ID_ADDRESS_MAIN = ADDRESS.ID)
This actually worked great, I only had to refer to ADDRESS once in the select for
output, I only had to join the other tables CITY, PROVINCE, COUNTRY once on ADDRESS
too.
BUT
Ok, I got a result here, still trying to determine if its correct or not :)
LEFT JOIN ADDRESS ON IF(CONTACT_X_CUSTOMER.ID_ADDRESS > 0,
CONTACT_X_CUSTOMER.ID_ADDRESS = ADDRESS.ID, IF(CUSTOMER.ID_ADDRESS_SHIPTO > 0,
CUSTOMER.ID_ADDRESS_SHIPTO = ADDRESS.ID, CUSTOMER.ID_ADDRESS_MAIN = ADDRESS.ID))
CONTACT_X_CUSTOMER.ID_ADDRESS
CUSTOMER.ID_ADDRESS_SHIPTO
CUSTOMER.ID_ADDRESS_MAIN
What I would like is to be able to JOIN conditionally based on the absence/presence of
reference
SELECT ADDRESS.ID FROM CONTACT_X_CUSTOMER LEFT JOIN CUSTOMER ON
CONTACT_X_CUSTOMER.ID_CUSTOMER = CUSTOMER.ID
(that
So I am guessing this is not a bug, and that I will have to modify the script myself?
-Original Message-
From: Luc Foisy
Sent: Monday, April 12, 2004 4:34 PM
To: Michael Stassen; MYSQL-List (E-mail)
Subject: RE: mysql error file
Michael wrote:
>mm... Have you looked in /etc/r
Michael wrote:
>mm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it
>oes when you tell it to start?
>
>Michael
I briefly looked in there. This is the same script it uses to start MySQL, and was
installed with the rpm of MySQL.
I would think it should come with all availabl
Actually, that didn't change anything. Still writing to $HOSTNAME.err
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, April 12, 2004 12:03 PM
To: Luc Foisy
Cc: Paul DuBois; MYSQL-List (E-mail)
Subject: Re: mysql error file
Note (see ps output) tha
bin/safe_mysqld --datadir=/usr/data/mysql
--pid-file=/usr/data/mysql/mysql.pid
14712 pts/0S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql
--user=mysql --pid-file=/usr/data/mysql/mysql.pid
-----Original Message-
From: Luc Foisy
Sent: Monday, April 12, 2004 9:12 AM
To: P
I changed mysql_safe to mysqld_safe and it is still sending the error output to
$HOSTNAME.err
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 11:17 AM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: Re: mysql error file
At 10:10 -0400 4/7/04
Wait, I see it now :)
-Original Message-
From: Luc Foisy
Sent: Wednesday, April 07, 2004 10:45 AM
To: [EMAIL PROTECTED]
Subject: RE: stuck with simple query. Plz have a look
I would like to ask a question here, just for my own knowledge. What is actually the
difference between
I would like to ask a question here, just for my own knowledge. What is actually the
difference between the statement below and this one?
SELECT Table1-1.Name AS 'PL', Table1-2.Name AS 'PC', Table1-3.Name AS 'PA'
FROM Table2
LEFT JOIN Table1 Table1-1 ON Table1.ID = Table1-1.PL
LEFT JOIN Table1
I have the following in my /etc/my.cnf
[mysqld]
datadir=/usr/data/mysql
pid-file=/usr/data/mysql/mysql.pid
socket=/usr/data/mysql/mysql.sock
user=mysql
[mysql_safe]
log-error=/usr/data/mysql/mysql.err
[client]
socket=/usr/data/mysql/mysql.sock
I tried originally to put the log-error= in the [m
There was a user comment under the Foriegn Key section of the documentation reading:
To restore from a mysqldump file that uses foreign keys:
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE your_dump_file;
mysql> SET FOREIGN_KEY_CHECKS = 1;
The command I am looking for is the call SOURCE. Where
-db's in SERVER3 should read replicate-do-db)
Will set up the replication on SERVER3 in a bit to see if I am getting anything from
that log-slave-updates
-Original Message-----
From: Luc Foisy
Sent: Monday, December 15, 2003 11:03 AM
To: MYSQL-List (E-mail)
Subject: FW: Replication
I
I sent this out friday, but didn't see it come through to the list, so sorry if it
comes up twice if the original is lost in lala land at the moment.
-Original Message-
From: Luc Foisy
Sent: Friday, December 12, 2003 4:17 PM
To: MYSQL-List (E-mail)
Subject: Replication
The sce
The scenario we wish to accomplish
SERVER1 - Logging DB1
SERVER2 - Logging DB2
Logging DB3
Replicating DB1 from SERVER1 - Logging DB1
SERVER3 - Replicating DB1 from SERVER2
Replicating DB2 from SERVER2
Replicating DB3 from S
UPDATE table SET d='complete' WHERE a=0 AND b=0 and c=0;
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 3:58 PM
To: MySQL List
Subject: if function?
Is there a way to write an if statement in mysql to affect the following?...
if field a=0,
ot handled, and my "formula"
is broken.
So there is no functions that would do what I need?
Anyone have some kind of "formula" (multiple functions perhaps) that would simulate
what I need, something that would only return numeric characters?
-Original Message-----
From:
Is there any function to strip non numeric characters from a string?
Such that FUNCTION('1-(519)-473-3853') would return '15194733853'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Got it, thanks
SELECT PROJECTCODE.ID AS 'ID', PROJECTCODE.Name AS 'Reference', EVENT.ID,
EVENT.ID_PROJECTCODE FROM PROJECTCODE LEFT JOIN EVENT ON PROJECTCODE.ID =
EVENT.ID_PROJECTCODE WHERE EVENT.ID IS NULL ORDER BY PROJECTCODE.Name
-Original Message-
From: Luc F
I have two tables EVENT and PROJECTCODE
EVENT.ID
EVENT.ID_PROJECTCODE
PROJECTCODE.ID
PROJECTCODE.Name
EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0 ID = 1
ID = 2 ID_PROJECTCODE = 0 ID = 2
ID = 3 ID_PROJECTCODE = 1 ID = 3
If I have replication already active for a single database ( already active between
master and slave ) and I want to start replicating a new database on the master, what
would the correct procedure be?
I have a dump of the database I want to replicate. Below is the current setup for
replication
Or not, try here instead http://gd.tuwien.ac.at/graphics/sf/h/hmailserver/
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 1:18 PM
To: [EMAIL PROTECTED]
Subject: MySQL powered MailServer
Just wanted to know if anyone knows
Try here
http://www.lencom.com/desc/indexN16185.html
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 1:18 PM
To: [EMAIL PROTECTED]
Subject: MySQL powered MailServer
Just wanted to know if anyone knows the status of the MySQ
Are there packages for java to include a standalone mysql database? Or are there plans
for such?
Luc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
k multiple databases with 20 or 30 tables each.
myisamchk is a great deal more easier to use.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 5:00 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
At 16:32 -0
corrupted...
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 3:08 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: myisamchk question (important)
I should qualify my answer, to indicate something that may not apply
to the situation you have in
allow a flush tables to be
called before.
Strange... How many answers can I find to this, does anyone know?
I have several conflicting sources now
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 10:06 PM
To: Luc Foisy; MYSQL-List (E-mail
Would anything happen to the database if I ran "myisamchk --silent
/usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
As it states in the documentation:
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and
ensure that no one is using the tables whi
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and
ensure that no one is using the tables while you are running myisamchk. In MySQL
Version 3.23 the easiest way to avoid this problem is to use CHECK TABLE instead of
myisamchk to check tables.
If i didnt do t
#x27;INSERT INTO
DISPATCHLOG (CreateStamp) VALUES (NOW())' |
Not quite sure what to do here, is my replicant toast?
Luc Foisy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I suppose datetime would be the better option here
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 10:00 AM
To: [EMAIL PROTECTED]
Subject: Re: mysqlbinlog suggestion
"Luc Foisy" <[EMAIL PROTECTED]> wrote:
>
&g
allowing date range options to the command line would be really neat
Luc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Foisy; MYSQL-List (E-mail)
Subject: RE: RedHat 9.0 - Mysql 3.23.56
At 12:41 -0400 6/25/03, Luc Foisy wrote:
>Yes, I turned those runlevels on already and now it works.
>The problem is that it was a practically default install, that is
>the way the runlevels were set "out of the b
.23.52 was this way
mysql 0:off 1:off 2:on3:on4:on5:on6:off
Was wondering why though. A mistake or for some reason that I am curious about..
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 12:13 PM
To: Luc Foisy; MYS
/S90mysql
/etc/rc.d/rc3.d/K90mysql
/etc/rc.d/rc4.d/S90mysql
/etc/rc.d/rc5.d/K90mysql
/etc/rc.d/rc6.d/K90mysql
Anyone else see the possible problem?
Where there a reason this was changed?
Luc Foisy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
this would not be working correctly with this
particular combination?
Thanks
Luc Foisy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 12, 2003 11:33 AM
> To: Luc Foisy; MYSQL-List (E-mail)
> Subject: RE: Is there any way to search a whole database for a value?
>
>
> At 9:21 -0500 3/12/03, Luc Foisy w
Perhaps one day UNION will be added to UPDATE
> At 11:01 -0800 3/11/03, Keith Roberts wrote:
> I need to look in several different tables/columns in a
> database for a
> particular value. If I find it, I need to update it. Is
> there any way to
> search/update every table/column in one query
Did I miss the global release message for this version?
I got the InnoDB release message but no other...
> -Original Message-
> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 25, 2003 10:53 AM
> To: [EMAIL PROTECTED]
> Subject: re: mysql 4.0.11
>
>
> On F
>
> On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> > >That means no field exists or should exist in the
> database. I only want to
> > >generate at query time.
> > >I can't use an autoincrement field since that wont work
> very well with
> > >results that are returned out of
> > I still don't understand do you mean the "actual" row
> number or just a
> > display number.
> > > There is no relevant data or use to this number.
> > > It is the row number of the returned result set, purely
> > > for display.
That means no field exists or should exist in the database. I
> -Original Message-
> From: Zak Greant [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 10:38 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL Feature
>
>
> On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote:
> >
> > I don'
.
> -Original Message-
> From: Jerry [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 1:48 PM
> To: Luc Foisy
> Subject: Re: Row numbers
>
>
> Have to have one in the row and select that along with the
> query, if your
> going to use it for some
Is there a way to get a row number returned with any select query?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
I don't think it is possible at the moment, and pretty sure its not standard SQL but
it would still be neat to have
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable
So in this example, if the expression was true, include that column in the result set,
otherwise d
Here are a number of queries that are run from time to time on the master. They are
always run together and in order that they appear.
Version of the server is 3.23.32 ( yes its old, but difficult to update at this time )
Version of the slave is 3.23.49a
Note: [param:] is handled by our own query
>
> At 8:06 -0800 12/19/02, mustakim abas wrote:
> >Hello, i am new in mysql. I got a problem. I try write
> >my C program with mysql API.I have 5 field in
> >table.No,Name,Phone,Date,Time. How can i take one row
> >where the No is bigger?
> >Thanks for help.
>
> Bigger than what?
>
Maybe
SEL
Same message I posted at JGuru and on the JDJ Mailing list, but posting here just
incase it is mysql related and someone can help
On RedHat 7.0 & RedHat 7.3
with Java 1.4.0_03
When page is hit fairly quickly I get the following error:
2002-12-17 14:56:37 StandardWrapperValve[jsp]: Servlet.servi
> >What exactly is wrong about using ENUM's?
> Changing them will kill you unless you're _very_ careful.
> Using them is usually unnecessary as you could've used an ID value
> pointing to another table of values. That table can then be added to
> with no risk to your existing queries. As a cont
What exactly is wrong about using ENUM's?
Luc
sql,mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
I am forwarding Shawn's real question to the list, since I haven't got a clue :)
> -Original Message-
> From: shawn xu [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 05, 2002 12:42 PM
> To: Luc Foisy
> Subject: RE: I can not post to this list after I hav
> I am wanting to see if there is a way to do a join but
> have count(id) show up as 0 when there is no records in
> the 2nd table. With out having to 2 selects.
>
> for example.
>
> orderid = has persons name and contact info
>
>
> select oi.id,oi.name, count(o.id) from orderid oi, orders o
Not quite sure if this is appropriate for the list, but I had to share it
SQL Query
http://www.thinkgeek.com/tshirts/frustrations/595d/zoom/
Luc
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
> PHP handles this correctly -- if I do a date("W-y", $date)
> for '2001-12-31'
> I get '01-02', but in mysql you get the wrong year: '01-01'
I don't know where you got this data from, but the second number would be the year,
that means mysql is showing the right year and php is showing the wr
You could do something like (I repeat something like, you may need to modify)
http://tjw.org/chroot-login-HOWTO/
or you could put something like this in thier startup script (this will disconnect
when they press a key) Maybe in .bash_profile in the users home directory
echo press any key to clos
not sure if this applies here, its from the c++ api docs (but why switch it around)
Do you have the parameters sent in the right order?
// The full format for the Connection constructor is
// Connection(cchar *db, cchar *host="",
//cchar *user="", cchar *passwd="")
I really k
Just looking for confirmation on this one.
If I install the .53a RPM on Red Hat 8.0 ( fresh install ), will it work right ( with
the know issues at least )
Luc
sql
-
Before posting, please check:
http://www.mysql.com/manual
Or, you could use distinct and substring_index instead of my last convoluted answer :)
> -Original Message-
> From: Kip Turk [mailto:kipt@;wcc.net]
> Sent: Monday, November 04, 2002 4:17 PM
> To: Alexander Newald
> Cc: mySQL Mailing Liste
> Subject: Re: Difficult query
>
>
> On Mon, 4 No
> sql,query
Would it be possible to supply BETWEEN in any order (or rather to allow to do that)?
Such as
WHERE timestamp BETWEEN 2002100100 AND 20021031235959
would get the same results with
WHERE timestamp BETWEEN 20021031235959 AND 2002100100
or any other case where BETWEEN can be u
SHOW PROCESSLIST?
> -Original Message-
> From: Brian Hughes [mailto:BLH@;pobox.com]
> Sent: Thursday, October 31, 2002 11:08 AM
> To: [EMAIL PROTECTED]
> Subject: Can server tell me how I connected?
>
>
> Hi.
>
> Is there anyway to get a mysql server to tell me
>
> a) What user I am co
>
> mysql> CREATE TABLE settest( chain SET( "A", "B", "C" ) NOT NULL,
> UNIQUE INDEX ichain( chain ) );
>
> mysql> INSERT INTO settest SET chain="A,C";
>
> mysql> SELECT * from settest;
> +---+
> | chain |
> +---+
> | A,C |
> +---+
>
> mysql> SELECT * FROM s
3.23.52
3.23.53a
Thanks!
Luc Foisy
Technical Magic - www.technical-magic.com
1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9
Phone: (613) 721-8850 Fax: (613) 596-5096
E-Mail: [EMAIL PROTECTED]
<<<<< Fulfilling the Promis
ll geared up for the
next release :)
Luc
> -Original Message-
> From: Jennifer Goodie [mailto:goodie@;apollointeractive.com]
> Sent: Thursday, October 24, 2002 3:05 PM
> To: Luc Foisy; MYSQL-List (E-mail)
> Subject: RE: MySQL Release Dates
>
>
> From looking a
> -Original Message-
> From: Lenz Grimmer [mailto:lenz@;mysql.com]
> Sent: Thursday, October 24, 2002 3:21 PM
> To: [EMAIL PROTECTED]
> Cc: Jennifer Goodie; Luc Foisy
> Subject: Re: MySQL Release Dates
> We usually note down the date when a release was tagged in
> -Original Message-
> From: William Martell [mailto:[EMAIL PROTECTED]]
> I am trying to query MySQL using PHP and I would like the
> results to display
> on multiple pages.
>
> I would like to display only 20 results per page and allow
> the user access
> to the other pages by clickin
Has anyone rushed out and tried them out with each other yet?=20
Maybe some things to be concerned about:
gcc 3.2=20
glibc 2.2.93=20
kernel 2.4.18=20
Luc Foisy
sql
-
Before posting, please check:
http
http://www.mysql.com/doc/en/Control_flow_functions.html
top of the page
> -Original Message-
> From: Gramos Brestovci [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 30, 2002 11:47 AM
> To: [EMAIL PROTECTED]
> Subject: IFNULL || NULLIF
>
>
> Does MySQL 3.23.39(version) support IFNU
You know that process would be much easier if you used the GRANT syntax
http://www.mysql.com/doc/search.php?q=GRANT&from=%2Fdoc%2Fen%2Findex.html
> -Original Message-
> From: Insanely Great [mailto:[EMAIL PROTECTED]]
> Subject: Setting Permission For Column Level Only
>
>
> Greetings..
> -Original Message-
> From: Paul Darius [mailto:[EMAIL PROTECTED]]
> Subject: Database Replication
>
>
> 'lock database with read lock' command already done before the above
> replication started and followed by 'unlock all' when finished.
>
> Question, how to sync an unsync table o
That would be a great way to keep your website up to date.
The slave can handle loss of connection (though some data may not make sense if part
of it is missing), and resume where it has left of previously.
Or you could also manually start and stop the slave process when you know there is a
li
When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3, the service
did not start when I restarted.
If you have gnome installed, you can acess Service Configuration and set MySQL to
start when system boots.
Just information for those that may experience this.
Luc Foisy
Independent table permissions are stored in the 'db' table. Base user permissions are
stored in the 'user' table.
> -Original Message-
> From: Nestor Florez [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 24, 2002 12:52 PM
> To: [EMAIL PROTECTED]
> Subject: granting does not give t
mysql -u root -p
This will enter as user 'root'
> -Original Message-
> From: hans schneidhofer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 20, 2002 1:00 PM
> To: [EMAIL PROTECTED]
> Subject: mysql -p as simple user ?
>
>
> hi,
> have done a succesful update 3.23.36 to 2.23.47
started up on boot on the server, but it did not on the laptop.
I can start MySQL manually on the laptop.
Does anyone know of anything I might look at here?
The laptop is an IBM ThinkPad 770x, 192MB RAM (actually I think it is the basic setup
of that model you can buy from IBM)
Luc Foisy
> On Thu 2002-09-05 at 09:29:41 -0400,
> [EMAIL PROTECTED] wrote:
> >
> > Can anyone tell me what this means???
> >
> > Master_User: repslave2
> > Master_Port: 3306
> > Connect_retry: 60
> >Log_File: QBSLXDB1-bin.058
> > Pos: 52706154
> >
Last_error: error 'unexpected success or fatal error' on query 'bslive'
Luc Foisy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
nging all our programming and other database entries that refer to
capitolized table names). I am sure it can't be as simple as just writing a script to
rename the files. Is there something else I would need to do to change the case of the
tables?
Luc Foisy
It think MySQL could very well have corrupted the data back in 3.23.38 for Marian
when I first started out using mysql, I was fairly new to linux and totally new to
MySQL
MySQL default install went to /var/lib/mysql, default RedHat /var is quite small
So unknowingly to me, it filled up quite q
turn them back into numbers with a math function
ORDER BY ABS(value)
> -Original Message-
> From: Jürgen Müller [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 5:23 PM
> To: [EMAIL PROTECTED]
> Subject: Add: Problem with ORDER BY
>
>
> I've changed my query to:
>
> $order =
> -Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> * Harald Fuchs
> > In article <[EMAIL PROTECTED]>,
> > Victoria Reznichenko <[EMAIL PROTECTED]> writes:
> >
> > > As you can see txt1 and txt2 contain text file ~ 8M
> >
> > > UPDATE tbl1 SET total=CONCAT(txt1,txt2)
Why can't you just give permissions to each user to that table?
Then you can even grant/deny access to it on a user by user basis...
> -Original Message-
> From: Dmitry Kuznetsov [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 4:43 AM
> To: Benjamin Pflugmann
> Cc: [EMAIL PROT
Yes that's it, Thanks!
> Ignore that correction. It seems that what you want is indeed this:
>
>SELECT Data1
>FROM table_name
>WHERE Data3 = 1
>GROUP BY Data1
>HAVING SUM(Data2 = 141) = 0;
>
> > > [Filter fodder: SQL]
Luc
--
Because I don't know what Data1 is, thats the result I want to find
> -Original Message-
> From: Mary Stickney [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 12:10 PM
> To: Luc Foisy; MYSQL-List (E-mail)
> Subject: RE: Query Question
>
>
>
&
urn me a group that
contains a Data1 value of 3, but I do not require that result because it's original
group contains 141
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 11:58 AM
> To: Luc Foisy
> Cc: M
I suppose I should have specified that I would not be able to filter by Data1
> -Original Message-
> From: Mary Stickney [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 11:52 AM
> To: Luc Foisy
> Subject: RE: Query Question
>
>
>
> select * from x
value of 141
There is also a WHERE clause on "Data3" = 1
The return would include these values for Data1
7
5
2
4
Is there some way to do this with a single query?
If this is unclear, let me know
Luc Foisy
Technical Magic - www.technical-magic.com
1 Stafford Road, Suite 325, Nepean,
> On 2 Aug 2002, at 11:43, Luc Foisy wrote:
>
> > FROM EVENTATTENDANCE
> > LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID
> > LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID
> > LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID
> Luc Foisy wrote:
>
> >Since the below select query blew up on me, then I must be
> doing something wrong, perhaps it is because I am using the
> wrong type of join, dunno
> >I would like to join the same table twice, with different
> criteria as below
> >
SQL Error in populateDataSet
==
Please Restart The Application
======
SQLException: General error: Unknown table 'TYPE' in on clause
Luc Foisy
-
Before posting, please check:
http://www.mysql.com/manua
read the documentation in the my.cnf sections
you can supply
datadir=/usr/data/mysql (or whatever the data directory you choose)
make sure mysql has permissions on the new directory
a couple other things rely on this base directory too
your socket file
your pid file
You can set these too in y
I would, very much, like to know if anyone has been able to do this.
NOTE: Multiple MySQL servers does not necessarily mean running multiple MySQL services
(just to clarify to another reply on this)
You can have multiple MySQL servers running on Unix system with some configuration in
your my
It would be a lot easier for you to have just used a timestamp, it automatically
updates itself when a record is modified.
Otherwise you would just update the time field in question when you do your other
updates
SET timefield = NOW() should work
Though using a TIME datatype is not very inform
Woops, sent this to support. Sorry Support!
> -Original Message-
> From: Luc Foisy
> Sent: Wednesday, July 10, 2002 1:37 PM
> To: 'Mysql-Support (E-mail)
> Subject: RE: calculating inside query
>
>
> > -Original Message-
> > Hi there,
>
> -Original Message-
> Hi,
> i have a table with 2000 rows.
> One column (name answer)has a string ("ok --") in all the
> rows.(e.g "ok --
> yes we support this.").
> now i want to remove all these 'ok --' in this
> column..leaving(e.g yes we
> support this)
> I tried to do it with the r
> -Original Message-
> Hey can someone provide me some help in installing and
> configuring mysql ver3.23.51 on my Linux server? I downloaded
> the file from mysql.com to my servers hard drive and now want
> to install it. I right-clicked the installation file and
> clicked install. It
> -Original Message-
> I was trying to connect into an MYSQL database, and I keep
> getting the error
> message
>
> Can't connect to MySQL server on '10.10.10.250' (10054)
>
> but I know that the database is running and I can connect
> fine on the server
> itself!
>
> Any suggestions
Here is the solution I posted about t months ago. I would also add, this solution can
handle both text and numbers in the same field...:
my boss figured out a nice solution to this
ORDER BY IF(ABS(Item) > 0,LPAD(Item,9,'0'),Item)
This will pad numbers ( ok it might not do so hot with DECIMAL,
>
> [snip]
> if you don't restart MySQL after changing the grants
> priviliges, you have to
> issue the "flush privileges" command from the MySQL Monitor.
> If you don't do
> either one your privilege changes will not take affect.
>
> not sure if when you said "reloaded" you meant "flush
> pr
7; should be 'PrintLine'. It seems to have moved 'in' back a few characters.
I restarted the slave and off it went, doing its merry little chore :)
I don't know what I am hoping for here, just griping about it :)
Luc Foisy
Technical Magic - www.technic
1 - 100 of 163 matches
Mail list logo
