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
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))
for that big spew of SQL )
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 11:37 AM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: Re: JOINing complication, help please
Sorry to reply to myslef but I just saw my own typo. Here is a better
example
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]
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/rc.d/init.d
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
/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: Paul DuBois; MYSQL-List (E-mail
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) that you
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 available
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
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
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
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
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 scenario
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 sent
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
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
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]
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: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 11:15 AM
To: Luc Foisy; MYSQL
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
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 Foisy
Sent: Thursday
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
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
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
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]
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 -0400 8/21/03, Luc Foisy wrote:
Thank you Paul.
whew! So just checking will not do
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
...
-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 mind
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 while
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]
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
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:
allowing date range options
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]
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]
/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
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; MYSQL-List (E
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 box
3.23.56
-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 wrote:
Perhaps one day UNION
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 Friday
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 order and
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
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
.
-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 other sql command it probally should
-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't think it is possible at the moment, and pretty sure
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 only want to
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:variable] is handled by our
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
SELECT No, Name,
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,
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 contrived
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]:
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 have joined
Hi, Luc Foisy
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
where
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 wrong
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
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:
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 know
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
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 Nov 2002,
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 settest WHERE chain=A,C;
-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
the BK tree.
The general
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 at http://www.mysql.com/doc/en/News.html
it looks like
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 Promise of Technology
-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 clicking next
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
-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 or the
You know that process would be much easier if you used the GRANT syntax
http://www.mysql.com/doc/search.php?q=GRANTfrom=%2Fdoc%2Fen%2Findex.html
-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Subject: Setting Permission For Column Level Only
Greetings...
I
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
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 the
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 on my
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
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
sql,mysql
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/ (the list archive
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
Slave_Running: No
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 =
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
-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) WHERE id=1;
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, Ontario, K2H 1B9
Phone: (613) 721-8850 Fax
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 xxx
where data2 141 and data3 = 1
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: MYSQL-List (E-mail)
Subject: Re: Query Question
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
Why cant you filter on Data1?
I meant
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
==
SQLException: General error: Unknown table 'TYPE' in on clause
Luc Foisy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
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
Anyone got a solution to this?
SELECT
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
LEFT JOIN ORGANIZATION
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
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
-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 would be
-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
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,
I would like to find out the top 10 of some
[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
privileges but
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,
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.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 first timestamp in any table is automatically updated by mysql every time you
modify that record. It is the modify timestamp
If you wish to use the timestamp in your table, you should create two timestamps at
least and use the second one
Modstamp timestamp
Usable timestamp
See here
How bout
SELECT main.id, sub1.other, sub2.other FROM main LEFT JOIN sub1 ON main.sub1fk =
sub1.id LEFT JOIN sub2 ON main.sub2fk = sub2.id
Luc
mysql,sql
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 3:54 PM
To: [EMAIL PROTECTED]
try
tail -n 10 /mysql/why.log /tmp/why.log
echo /mysql/why.log
-Original Message-
From: Van [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 6:01 PM
To: Paul DuBois
Cc: MySQL
Subject: Re: Irritating Discovery
Paul DuBois wrote:
At 13:12 -0700 6/12/02,
I am replicating to NT Server system from Red Hat Linux
was not aware of any issues to win2k from linux with replication
Is there something I am not aware of?
-Original Message-
From: Bartomiej Dolata [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 9:44 AM
To: Mysql@Lists.
We are running mysql on a red hat box.
We replicate a single database twice, once on another red hat box(thank whatever is
holy), once on a winnt box.
The winnt box cares not for case sensitivity, so it created all our table names in
lower case ( our standard is to use CAPS for tablenames )
(
Is there any way to dynamically create columns non programatically? As in pure sql
queries?
This is what I am doing now:
SELECT SQL_BUFFER_RESULT
ORDERHEADER.ID_CUSTOMER AS 'Acct #',
CUSTOMER.Company AS 'Company',
SALESLEVEL.Name AS 'Client Type',
DATE_FORMAT(ORDERHEADER.AvailableAt, '%b')
1 - 100 of 153 matches
Mail list logo