Original Message
Subject:Re: Basic Question
Date: Mon, 17 Dec 2012 15:39:39 -0500
From: Rhino
To: Reindl Harald
On 2012-12-17 14:34, Reindl Harald wrote:
Am 17.12.2012 19:09, schrieb Rhino:
Is the version of SQL statements that I write for MySQL based
ssures you 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: htt
OCALLY on the database
server, 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
don't know how to do it.
I should point out that I'm quite fluent in SQL and have been writing it
for a long time. I haven't used 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 than
value before the comma, such as:
countryid = 7,
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]
need to look at the values that are allowable in this dataelement column
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
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 Inte
rule in effect 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 ta
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]>
To:
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 be called: "bracket matcher", "parenthesis balancer", or
whatever. It's getting 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 AV
be a batch job that runs once a day
or once a week. Then, your query could simply search for the status like
this:
delete from modnaptrrecord_zone where
modnaptrrecord_zone.modnaptrrecord_id in
(select id from customer where status
= 'Poor') and
modnaptrrecord_zone.modnap
have a few dozen books and will quickly memorize the author 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
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Tuesday, May 16, 2006 1:56 PM
Subject: Re: Baffled by error
- Original Message -
From: "Mike Blezien"
ny. For example:
ACCOUNT_IDCOMPANYMINS
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:
clarified what it is you are
doing
--
Rhino
- Original Message -
From: "George Law" <[EMAIL PROTECTED]>
To: "Steffan A. Cline" <[EMAIL PROTECTED]>;
Sent: Friday, May 12, 2006 3:33 PM
Subject: RE: Returning records in a circle
I ran into this same type
ith SQL
alone, unless you can write a script that takes advantage of the LIMIT
clause.
I don't pretend to know MySQL exhaustively so someone else may have another
suggestion for you but the only two approaches I can think of that might
meet your needs are to use the LIMIT clause or to w
ducation_years=" and "@minimum_education_years", and, more
importantly, that the width of the columns is too narrow and some of the
information is truncated. For example the value shown for the second
variable name is shown as "birthdate_of_youngest_le" and the VALUE of
lternative.
--
Rhino
- Original Message -
From: "Stephen Cook" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, May 10, 2006 8:09 PM
Subject: Re: PRINT statement?
I've started using the SELECT with no
ead
Chris's question 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" <[
postgis was one of the databases compared to MySQL though.
--
Rhino
- Original Message -
From: "Parang Saraf" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 09, 2006 4:06 PM
Subject: comparing postgis with mysql
hello,
I am relatively new in this field. I am designing
7;, etc.) ensure
that you only get the joined rows you want, namely the ones that contain
21.)
This is a very common beginner mistake. Unfortunately, the MySQL manual
doesn't yet explain how to do joins very well; this is something that is
badly needed, in my opinion.
--
Rhino
Y would fail so I would
strongly recommend that you 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
An
is mailing
list has an example that you could have which is actually known 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 be
eplication - 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:
Sent: Sunday, May 07, 2006 11:41 AM
Subject: How to synchronize two databases
Dear Friends,
I can
use the BASH echo command, like 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
, you'll need
to do this:
mysql barf -u fred -p < my_batch_file.sql > my_batch_file.out
[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
ould perform. You'll need to research that yourself.
--
Rhino
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "Douglas Sims" <[EMAIL PROTECTED]>
Cc: "mysql List"
Sent: Thursday, May 04, 2006 3:15 PM
Subject: Re:
contribute them 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 PROTECTE
to be a
very useful command to create if it doesn't already exist!
--
Rhino
- Original Message -
From: "Shivaji S" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 02, 2006 5:12 PM
Subject: Re: Re: Re: How to find size of m
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
- O
version 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:
Sent: Tue
most of the time, your syntax will look 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
- Original Message -
From: "Tom Lobato" <[EMAIL PROTECTED]>
To:
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
in your note so 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
- O
you 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
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:
Sent: Saturday, April 22, 2006
g to spell
contractions without the apostrophes but this is always wrong and makes the
writer look illiterate. Obviously, we make allowances for those who are
relatively new to English but I wanted you to know the right way to handle
contractions. I assume you want to write English as well a
n some way? If
so, what is wrong with it?
All you've done is given us a fragment of code without 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.
--
Rhi
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 PRO
that in a
given range and INCLUDES both ends of the range.)
You also talk about 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 vi
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: "
Explain command 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 messag
method of
forcing the output to be in a specific order.
--
Rhino
- Original Message -
From: "subramani" <[EMAIL PROTECTED]>
To:
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 SEL
ween dates that are in
different years, you are certainly 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 DATEDIF
rolled
back to maintain consistency. 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 out
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 Ven
LUS the "orphan rows" from the left-hand table
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: &quo
arch?) 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 messa
or 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 messa
or all
the platforms and configurations that interest you.
--
Rhino
- Original Message -
From: "Robert DiFalco" <[EMAIL PROTECTED]>
To:
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 appe
rsion may not work 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:
Be careful to make sure you are updating
ONLY the rows that should 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 / Viru
rically 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.
We are not going to agree, that much is clear.
I think we raised some very interes
them, then I don't have any problem with that.
I have seen that when I avoid storing NULLs, my applications
became more clear and easier to understand.
Beauty is in the eye of the beholder as we all know. I have no problem with
having nulls in my tables and consider that a better design th
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 14, 2006 2:16 PM
Subject: Re: Accountability with MySQL
> >Should you have a flag for the status "movement complet
ght
answer. There may be a built-in function that controls the formatting. Or
maybe you'll have to write your own function for this purpose. Or maybe
choosing the right character set will handle this for you automatically. I'm
really not sure. If you want to do this formatting via Jav
hatever) and use that. But what if they are a
permanent employee and you don't have 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
(The users may say that it is the
wrong thing to do 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 vir
candidates for things that you could add to your new system.
I'm a little surprised that your amount column is an integer. Does the
Brazilian currency not have a fractional component? Here in Canada, monetary
amounts are always decimal numbers, like $123.45, meaning one hundred and
twen
varchar(15),
mothers_maiden_name varchar(30),
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/20
It would be easier to answer a specific question
--
Rhino
- Original Message -
From: "Terry Spencer" <[EMAIL PROTECTED]>
To:
Sent: Sunday, March 05, 2006 6:41 PM
Subject: -help
Terry Spencer
Haigh Consultancy Services
Tel: +44 (0)116 262 3966
Fax: +44
r datetime value? Otherwise, I
don't see how an expression like 7 - 4 (for records 7 and 4) 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 -
probably be a lot easier if the data was clean 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
your data at all. 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 peop
says 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: ; "Rhino" <[EMAIL PROTECTED]>
Sent: Sunday, March 05, 2006 11:46 AM
Subject: Re: Help on sql state
nt to _display_ a null
where something isn't null? I don't understand what your "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 Edi
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
l different
formats. 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, 20
seconds/microseconds/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:
Sent: Thursday, March 02, 2006 10:10 A
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.
--
did, you'll find over 200,000 hits, some of which will point to
tools or techniques that might help you with your problem.
--
Rhino
- Original Message -
From: "VenuGopal Papasani" <[EMAIL PROTECTED]>
To:
Sent: Thursday, March 02, 2006 5:24 AM
Subject: help
he final result set.
If you don't want to remove the duplicates, use UNION ALL instead of UNION.
(I'm not sure if UNION ALL is supported in MySQL but it certainly is in DB2,
my main database.)
Perhaps that's why you have fewer rows in the UNION result than you do by
summing up
rent
MySQL databases and
#deletes 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.
use pairs of double quotes to create the empty columns:
SELECT `Call`, concat(FName, ' ', LName) as Name, "" as `Eenie` ,"" as
`Meenie`, "" as `Miney`, "" as `Moe`
FROM table
Order BY LName, FName
But you can't use pairs of backtics:
SEL
tement against the table you _think_
you are updating? For example, Is it possible that you mean 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 -
data, your expectations 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:
Sent: Saturd
er depends on
exactly 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 l
able. If you use ON DELETE RESTRICT,
you will not be able to delete an affiliate from the affiliates table unless
all of the Visitors rows with his ID have had their affid changed to that of
some other affiliate. If you use on DELETE SET NULL, you can freely delete
affiliates even if they have rows
essions.
Therefore, I think you should 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 -
Fr
well, you should be
able to improve 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 thi
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
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
xplain the idea more 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:
Sent:
But your query should be fine as long as you have MySQL 4.1 or
later. It would certainly work in DB2, my main database.
--
Rhino
- Original Message -
From: "René Fournier" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 04, 2006 5:38 PM
Subject: MySQL says, "
this.
--
Rhino
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "Scott Purcell" <[EMAIL PROTECTED]>;
Sent: Tuesday, January 31, 2006 1:18 AM
Subject: Re: Help Understanding Document Syntax
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]>
T
statement
to make it ignore a uniqueness violation. As I read the article on the
INSERT statement, you would want an INSERT to look like this if you wanted a
row that violated uniqueness to be ignored:
INSERT IGNORE INTO PURCELL01 VALUES(5, 'Fred', 'Flintstone');
The UP
rated,
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"
Sent: Tuesday, January 24, 2006 3
Please, retest everything VERY carefully 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.
Rhin
I should follow up so that anyone following this thread now
or in the archives will know how it was resolved.
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; "gerald_clark"
<[EMAIL PROTECT
just aren't that important and could be omitted with no
important loss 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
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; "wangxu" <[EMAIL PROTECTED]>
Cc: "mysql"
Sent: Friday, January 20, 2006 2:20 AM
Subject: Re: question about "CONTAINS SQL"
back 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"
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "mysql"
Sent: Thursday, January 19, 2006 9:30 AM
Subject: Re: Error from mysqldump
Rhino wrote:
I have an automated backup script that has
m
could be. When I do 'select *' against each of the five small tables in this
database, each returns exactly the right data 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 su
st way to be sure is to try this for yourself. Try 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&q
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "Imran" <[EMAIL PROTECTED]>;
Sent: Wednesday, January 18, 2006 5:07 PM
Subject: Re: Help in joining three tables
"Rhino" <[EMAIL PROTECTED]> wrot
t3.planet = 'EARTH'
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
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]>;
Sent: Wednesday, January 18, 2006 3:0
1 - 100 of 505 matches
Mail list logo
