Original Message
Subject:Re: Basic Question
Date: Mon, 17 Dec 2012 15:39:39 -0500
From: Rhino rhi...@sympatico.ca
To: Reindl Harald h.rei...@thelounge.net
On 2012-12-17 14:34, Reindl Harald wrote:
Am 17.12.2012 19:09, schrieb Rhino:
Is the version of SQL
that someone will be in touch within 48 hours. What the
heck is all that about? Is this some sort of marketing offensive where
some sales guy is going to try to push me into purchasing MySQL and a
service contract??
--
Rhino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
, which will reduce costs dramatically. Only the median gets sent
across the network back to the client program. Obviously, this will save
on both I/O costs and network utilization.
--
Rhino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
MySQL in a few years now but I'm still
on the mailing list and your question caught my eye.
--
Rhino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Apparently not.
Noel Butler wrote:
does this list not have a dickhead filter?
On Tue, 2010-03-23 at 15:17 +, Ganeswar Mishra wrote:
Hi
Please click on the link below and enter your birthday for me. I am creating a
birthday calendar for myself. Don't worry, it'll take less
,
or
countryid = '7',
If you don't want to assign a value to countryid, just omit the entire
'countryid =,' altogether.
--
Rhino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and then see what value is actually being inserted or what the existing
value is being changed to.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/437 - Release Date: 2006-09-04
--
MySQL General Mailing List
mols or smilies?
Huh?
What do you mean by mols - molar weights?
And why would anyone search for anything to do with chemicals based on
smilies? How would :-) or symbols like that help? Or is this some other
sense of the word smilies than the customary Internet one?
--
Rhino
--
No virus
is
CASCADE, as you have proposed, then deleting the B01 row from DEPARTMENT
will also cause the deletion of all B01 rows in the EMPLOYEE table. By the
same token, deleting the C01 row from the DEPARTMENT table will cause the
deletes of _all_ of the C01 rows in the EMPLOYEE table.
--
Rhino
- Original Message -
From: Miles Thompson [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, July 09, 2006 8:10 PM
Subject: Re: How to look for balanced parenthesis?
At 03:48 PM 7/9/2006, Rhino wrote:
- Original Message - From: mos [EMAIL PROTECTED]
To: mysql
to be a pretty standard feature in editors in recent
years, although it doesn't seem to be in NotePad or WordPad.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.9/382 - Release Date: 2006-07-04
--
MySQL General
he status like
this:
delete from modnaptrrecord_zone where
modnaptrrecord_zone.modnaptrrecord_id in
(select id from customer where status
= 'Poor') and
modnaptrrecord_zone.modnaptrrecord_id
not in
(select id from customer where status
= 'Good')
--
Rhino
- Original Message
names and titles
that go with each author id and title id.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 29/05/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
MINS
001 ABC Co.45
001 DEF Ltd. 90
But maybe that's what you wanted all along?
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/2006
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:56 PM
Subject: Re: Baffled by error
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List mysql
.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/337 - Release Date: 11/05/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Rhino
- Original Message -
From: George Law [EMAIL PROTECTED]
To: Steffan A. Cline [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, May 12, 2006 3:33 PM
Subject: RE: Returning records in a circle
I ran into this same type of question the other evening at a local
linux group.
I
not sure
about yet, I think we can see that SELECT can do everything else that the
PRINT command supports.
--
Rhino
- Original Message -
From: Quentin Bennett [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; Stephen Cook [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent
but it didn't.
My apologies to all for wasting your time with an inappropriate solution.
I'll try not to do that again!
--
Rhino
- Original Message -
From: Joerg Bruehe [EMAIL PROTECTED]
To: Chris Sansom [EMAIL PROTECTED]
Cc: Rhino [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com
.
--
Rhino
- Original Message -
From: Stephen Cook [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, May 10, 2006 8:09 PM
Subject: Re: PRINT statement?
I've started using the SELECT with no other clauses but I am still curious
about
to work in
MySQL. Otherwise, you might only have hypothetical guidelines and manual
articles to guide you as you try to write your UDF or SP. That can be
time-consuming if you've never done any coding like that before. But it
could be fun too if you are in the right frame of mind!
--
Rhino
consider the alternate scenarios I have
suggested and rule those out first. If you can rule them out, then you may
have encountered a real bug. Naturally, you should report that bug if you
can satisfy yourself that it really IS a bug.
--
Rhino
Another
--
No virus found in this outgoing
how to do joins very well; this is something that is
badly needed, in my opinion.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/334 - Release Date: 08/05/2006
--
MySQL General Mailing List
For list archives: http
of the databases compared to MySQL though.
--
Rhino
- Original Message -
From: Parang Saraf [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, May 09, 2006 4:06 PM
Subject: comparing postgis with mysql
hello,
I am relatively new in this field. I am designing a database
this:
#!/bin/bash
report_date=`/bin/date`
echo Report Date: $report_date;
to produce this output:
Report Date: Sun May 7 09:42:57 EDT 2006
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 05
- but the manual should tell you whether
this is a problem or is handled well by MySQL.
--
Rhino
- Original Message -
From: abhishek jain [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, May 07, 2006 11:41 AM
Subject: How to synchronize two databases
Dear Friends,
I have two
[Be sure to supply the password when prompted.]
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 04/05/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
to research that yourself.
--
Rhino
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
To: Douglas Sims [EMAIL PROTECTED]
Cc: mysql List mysql@lists.mysql.com
Sent: Thursday, May 04, 2006 3:15 PM
Subject: Re: Effective-dating
Coming to the table SOOO late. But this has
freely to the MySQL community.
Thanks again, Mark! I know I will revisit your reply when I get around to
doing proper monitoring of my MySQL databases when they finally go into
production.
--
Rhino
- Original Message -
From: Mark Leith [EMAIL PROTECTED]
To: Shivaji S [EMAIL PROTECTED]
Cc
of MySQL you are using; later versions
have features and commands not found in earlier versions. Also, the size of
a give database may differ from version to version of MySQL.
--
Rhino
- Original Message -
From: Shivaji S [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, May 02
You still haven't said what you mean by size!
Let me put it to you this way: what units would be used in the answer you
want? In other words, would the answer look like:
1. 234,000 KB?
2. 2.75 million rows?
3. 321 tables?
Or something else altogether?
--
Rhino
- Original Message
!
--
Rhino
- Original Message -
From: Shivaji S [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, May 02, 2006 5:12 PM
Subject: Re: Re: Re: How to find size of my database
Hi Rhino,
sorry ,for my unclear reply.
the size i meant is in KB or MB
like this:
select id, conf
from confs as c inner join conf_id as i on c.id = i.id
where id != '101.33.55.123'
If you need to do a different kind of join, please specify which kind you
want to do and perhaps someone here can suggest the right syntax.
--
Rhino
- Original Message -
From
you to know the right way to handle
contractions. I assume you want to write English as well as you can so
please don't copy the bad habits of English-speakers who don't have enough
education or self-respect to spell their own language correctly.
--
Rhino
--
No virus found in this outgoing
What makes you think the delete of the database failed? It looks like the
message from the DROP command indicates that the database was dropped
successfully.
--
Rhino
- Original Message -
From: Randy Paries [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, April 22, 2006 9
search the MySQL manual on increment, you'll get several hits, one
of which is 3.6.9 Using AUTO_INCREMENT. Here is the link:
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
If you read that page, you should find your answer
--
Rhino
--
No virus found in this outgoing
I wanted to be sure you
had done that much before writing the note.
Have you looked in the MySQL log to see if it is reporting any problems with
the DROP? If you are using INNODB, have you tried a SHOW STATUS INNODB to
see if it reported any problems?
--
Rhino
- Original Message
- Original Message -
From: Tom Lobato [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, April 22, 2006 4:18 PM
Subject: Re: WHERE doesn'r works
From: Rhino [EMAIL PROTECTED]
Most of the time, when I see a column named 'id', it is defined as an
integer. If _your_ 'id
clearly identifying
the failing code or giving us any real symptoms, other than a remark about a
summing problem.
Without more information it is VERY hard to guess what might be wrong.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus
I'm putting your question back on the mailing list where it belongs. That
enables others to help and to learn from the discussion, either now or in
the future via the archives.
--
Rhino
- Original Message -
From: H L [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 12
using sum() on days or dates but your query is actually
summing prices, which is quite a different matter.
I think you need to clarify just what you want to know and ask a clearer
question.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385
that will tell you what access
path you are getting? If it does, your best bet would be to try your query
and do an Explain to see what it actually does; it should be pretty clear
whether the count() is being done once or twice.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free
I'm sending this back to the mailing list where it belongs; that way, other
people can jump in to help and others can learn from the discussion, either
now or via the list archive.
- Original Message -
From: Martin Gallagher [EMAIL PROTECTED]
To: 'Rhino' [EMAIL PROTECTED]
Sent
method of
forcing the output to be in a specific order.
--
Rhino
- Original Message -
From: subramani [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, April 07, 2006 10:22 AM
Subject: A doubt in SELECT query
hello all,
In which order the datas are displayed, when the SELECT
going to get the wrong answer. For
instance, DAYOFYEAR(2006-04-01) - DAYOFYEAR(2005-04-01) gives an answer of 0
days when the correct answer is 365.
A better choice for getting the difference between two dates in days is
probably DATEDIFF() or TO_DAYS().
--
Rhino
--
No virus found
. Otherwise, if the first update succeeds and
then you hit a problem, like a power failure, the column that is common to
both tables will have one value in one table and a different value in the
other table.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition
I don't know the answer to your question but I know that this issue has been
discussed in this mailing list before. Look in the MySQL archives and I'm
sure you will find an answer on the best way to compare IP addresses.
--
Rhino
- Original Message -
From: Lucas Vendramin [EMAIL
for maintenance like taking backups. Why do you
want start and start MySQL from an application? Isn't this going to preclude
most of the users from using it? After all, databases usually have large
numbers of users, not just one.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free
?) The downside is that the plan might be
significantly worse so you can loose big time in the executor.
Especially considering the semantic difference between both syntaxes I
would never use this as a way to constrain the planner.
Jochem
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG
in the join. Furthermore, the last time I checked, which was probably at
least a year ago now, MySQL didn't support a full join.
--
Rhino
- Original Message -
From: Robert DiFalco [EMAIL PROTECTED]
To: Martijn Tonies [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, March 21
that interest you.
--
Rhino
- Original Message -
From: Robert DiFalco [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, March 20, 2006 7:11 PM
Subject: RIGHT JOIN better than INNER JOIN?
I apologize if this is a naive question but it appears through my
testing that a RIGHT JOIN
at all in an older version or may have to be
adapted to work.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 17/03/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
be updated. If you specify your WHERE conditions
incorrectly, you can update every row of the table or none at all.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 17/03/2006
--
MySQL General
.
But if you are stating categorically that nulls are always bad or wrong,
I disagree strongly. That's like saying only chocolate ice cream is
acceptable and that all other flavours are evil. That's just wrong.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition
. This is just a difference of
opinion or emphasis that two reasonable people can have.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.3/281 - Release Date: 14/03/2006
--
MySQL General Mailing List
For list archives
currency not have a fractional component? Here in Canada, monetary
amounts are always decimal numbers, like $123.45, meaning one hundred and
twenty three dollars and forty five cents. Or is your currency like Japanese
yen, which have no fractional part?
--
Rhino
--
No virus found
and suggest a better value to choose for the transaction
date.) But if the transaction date can never be unknown, it doesn't make
much difference what you choose as the default date since it will never be
used.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition
mandatory retirement? I would store a
NULL to mean I don't know right now. Then, if and when they gave notice
that they were leaving, I would change the termination date from NULL to
their last day of work.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition
via Java, I can tell you
how to accomplish it but if you are using Perl or php, or other languages, I
don't know.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.2/280 - Release Date: 13/03/2006
--
MySQL General
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, March 14, 2006 2:16 PM
Subject: Re: Accountability with MySQL
Should you have a flag for the status movement complete ? I would
say
yes but instead
),
ip_of_useratsignup varchar(16),
primary key(login_id, email_addr, last_name)
);
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 06/03/2006
--
MySQL General Mailing List
For list archives: http
DROP and LEAVE
AS IS remarks mean.
Can you explain more fully what you are trying to do?
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.2/274 - Release Date: 03/03/2006
--
MySQL General Mailing List
For list
that if the value of the type is 4, leave it
alone, otherwise display null.
--
Rhino
- Original Message -
From: Søren Merser [EMAIL PROTECTED]
To: mysql@lists.mysql.com; Rhino [EMAIL PROTECTED]
Sent: Sunday, March 05, 2006 11:46 AM
Subject: Re: Help on sql statement (not MySQL specifik
. In that case, the query I just
posted should meet your needs.
If you _do_ have a data problem, Michael's suggestions make a lot of sense
but if you don't understand them or if your situation is actually different
than Michael assumes, please post again and people will try to help you.
--
Rhino
to start with.
In any case, thanks for keeping me honest.
--
Rhino
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Søren Merser [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 2:26 PM
Subject: Re: Help on sql statement
) is going to
give you a value like 2 hours and 10 minutes.
5. What do you mean when you described eType as nominal and not interval
data?
--
Rhino
- Original Message -
From: Søren Merser [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 4:37 PM
Subject: Re
It would be easier to answer a specific question
--
Rhino
- Original Message -
From: Terry Spencer [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, March 05, 2006 6:41 PM
Subject: -help
Terry Spencer
Haigh Consultancy Services
Tel: +44 (0)116 262 3966
Fax: +44
with your problem.
--
Rhino
- Original Message -
From: VenuGopal Papasani [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, March 02, 2006 5:24 AM
Subject: help regarding writing a query
HI all,
This is venugopal.Being a silent member of this group.I am having a doubt
I don't understand what you want. If you have the original query, it should
be apparent from it where each 'id' column originated. If you're not sure
how to read the query, post it and we can help you figure out which table
provided each 'id' column.
--
Rhino
- Original Message
/nanonseconds. If you have to keep the fractional
part of the seconds, you could store them in a second column defined as some
kind of integer.
--
Rhino
- Original Message -
From: rtroiana [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, March 02, 2006 10:10 AM
Subject: TimeStamp
. The different formats are explained here:
http://dev.mysql.com/doc/refman/5.0/en/datetime.html.
--
Rhino
- Original Message -
From: rtroiana [EMAIL PROTECTED]
To: 'Rhino' [EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 1:29 PM
Subject: RE: TimeStamp issue
Thanks for the reply. I'm using
Thanks for keeping me honest! I'd
forgotten that MySQL timestamps don't keep the fractional parts of seconds
either; I mostly use DB2 which keeps the fractional parts (microseconds) and
forgot about this quirk of MySQL.
--
Rhino
- Original Message -
From:
[EMAIL PROTECTED
than you do by
summing up the row counts in the individual queries?
By the way, I'm not sure how you posted your question but my copy of Outlook
Express thinks it's a newsgroup post, not an email so I couldn't reply in
the normal way.
--
Rhino
--
No virus found in this outgoing message
BY LName, FName
So, MySQL is more tolerant than I realized.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.1/271 - Release Date: 28/02/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
backups older than a certain number of days.
#This script is normally invoked via a cron job so that it runs once per day
in the middle of the night.
#The crontab entry looks like this:
#0 3 * * * sh /home/rhino/MySQL/backup2.bash /home/rhino/MySQL/backup2.out
21; cat /home/rhino/MySQL/backup2.out
for what the result should have been, and
information about what you actually got.
The CREATE TABLE statement could also be helpful in determining what went
wrong.
--
Rhino
- Original Message -
From: Bruce Therrien [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday
to execute the
statement against a production table but are actually executing it against a
test table that has very different data than the production table?
--
Rhino
- Original Message -
From: Bruce Therrien [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Sent: Saturday, February 25
how you store your IP addresses, i.e. datatype and number of columns
used.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.12/266 - Release Date: 21/02/2006
--
MySQL General Mailing List
For list archives: http
to that of
some other affiliate. If you use on DELETE SET NULL, you can freely delete
affiliates even if they have rows in the Visitors table; the Visitors rows
will just have their affids set to null, which effectively means that those
Visitors have no assigned affiliate.
--
Rhino
--
No virus found
the performance dramatically by creating appropriate indexes
on the data. I can't advise you on the construction of indexes in MySQL - I
don't know enough about how MySQL uses indexes - but others on this mailing
list are very experienced in this area and should be able to guide you.
--
Rhino
look very carefully at the two suggestions
that Peter Brawley gave you earlier in the day. They look promising and I
think you might be able to solve the problem that way.
Sorry I couldn't help more.
--
Rhino
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: Octavian
Oops, I meant to send this to the list so that all could benefit.
--
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Jessica Yazbek [EMAIL PROTECTED]
Sent: Sunday, February 12, 2006 4:19 PM
Subject: Re: Multiple many-to-many SELECT
Assuming you are only worried about
Oops, I meant to send this to the list so that everyone could benefit, not
just to Andre.
--
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Andre Matos [EMAIL PROTECTED]
Sent: Saturday, February 11, 2006 12:11 PM
Subject: Re: Insert and Update together
clearly or convincingly
than I do ;-)
I have to dash but if you have followup questions, post them in the list and
I, or someone else, will likely be able to answer.
--
Rhino
- Original Message -
From: Jessica Yazbek [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February
database.
--
Rhino
- Original Message -
From: René Fournier [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, February 04, 2006 5:38 PM
Subject: MySQL says, Ich don't think so (Subquery woes)
SELECT MAX(id) FROM history
WHERE account_id = 216 GROUP BY asset_id
...works
this.
--
Rhino
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Scott Purcell [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, January 31, 2006 1:18 AM
Subject: Re: Help Understanding Document Syntax
Rhino wrote:
The 'symbol' you
to be ignored:
INSERT IGNORE INTO PURCELL01 VALUES(5, 'Fred', 'Flintstone');
The UPDATE statement appears to be the same idea;
UPDATE IGNORE
set fname = 'Fred', lname = 'Flintstone'
where empno = 4;
---
Rhino
- Original Message -
From: Scott Purcell [EMAIL PROTECTED
by the query.
If the query has WHERE _and_ GROUP BY, count(*) should report the number of
groups that were found after the WHERE clause had been applied to the data
in the table.
Would that help you?
Rhino
- Original Message -
From: René Fournier [EMAIL PROTECTED]
To: mysql
,
possibly for a fairly affordable price.
Any idea what would prevent the post office from doing that?
Rhino
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Tuesday, January 24, 2006 3:31 PM
Subject: Re: UK
once more and make VERY sure that
you aren't inadvertently writing the query incorrectly and that you really
DO have 10 rows with cid = 123. If you still get 2 as the result of your
query, I would recommend sending a bug report to MySQL.
Rhino
- Original Message -
From: fabsk [EMAIL
how it was resolved.
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; gerald_clark
[EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Thursday, January 19, 2006 11:15 AM
Subject: Re: Error from mysqldump
Just as a followup to my own remarks
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; wangxu [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Friday, January 20, 2006 2:20 AM
Subject: Re: question about CONTAINS SQL
At 8:29 -0500 1/19/06, Rhino wrote:
I am copying the rest
of functionality?
If you give this due consideration, you may find that a lot of your problem
evaporates and the rest gets simpler to handle.
Just a general observation made by a disinterested third party; ignore it if
you like :-)
Rhino
- Original Message -
From: Ian Klassen [EMAIL
the
routine with CONTAINS SQL and see what happens at runtime. If it fails, as I
strongly expect, change CONTAINS SQL to MODIFIES SQL DATA and your error
will almost certainly go away.
Rhino
- Original Message -
From: wangxu [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Sent: Thursday
and there are no errors or
warnings of any kind.
Can anyone suggest queries or commands that would reveal the status of my
database and its tables to make sure something is not messed up?
Any suggestions on resolving this problem would be greatly appreciated.
---
Rhino
--
No virus found
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Thursday, January 19, 2006 9:30 AM
Subject: Re: Error from mysqldump
Rhino wrote:
I have an automated backup script that has been running daily for a
couple
with the same error. The new syntax is still
cleaner and I'm going to keep it but I'm back to square one in determining
why the mysqldump of this one database is giving me trouble.
Does anyone have any ideas?
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: gerald_clark
If you are writing something that does INSERT, UPDATE, or DELETE, you need
to use the MODIFIES SQL DATA option.
Rhino
- Original Message -
From: wangxu [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, January 18, 2006 3:05 AM
Subject: Re: question
'
order by t1.col1, t2.col2;
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.20/233 - Release Date: 18/01/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
- Original Message -
From: [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Imran [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, January 18, 2006 5:07 PM
Subject: Re: Help in joining three tables
Rhino [EMAIL PROTECTED] wrote on 01/18/2006 03:30:44 PM:
- Original
1 - 100 of 502 matches
Mail list logo