on 11/16/05 7:06 PM, Jasper Bryant-Greene at [EMAIL PROTECTED] wrote:
Scott Haneda wrote:
Google this:
subselect site:dev.mysql.com
And I get mostly non English stuff, limiting to english and I get a whopping
37 pages, none of which seem to help me much.
Try googling for subquery,
Scott Haneda wrote:
Hello, with the release of 5, I seem to have all dead links to my old docs
for mysql 4. The way they keep changing the urls is a little maddedning :-)
I usually search using: http://www.mysql.com/keyword
http://www.mysql.com/subquery will lead to:
Hello Gleb!
The answer to the scrambled characters in the shell und XP is, as you
assumed, that the shell simply does not handle characters like the
Windows-GUI does... .
Now, that I know about this fact it's no longer a problem ( perhaps a
feature, ;-) ?).
Thx again have a good time,
Goetz
sheeri kritzer schrieb:
Hi folks,
You might be amazed getting answers that link right to the MySQL
documentation. The documentation is fabulous, but of course we cannot
memorize it! One tip I picked up in a MySQL course (which was worth
the $$ of the course itself), which is IMMENSELY
Kyle, you're a twat for sending s**t like this to this list...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Don't know if that's the word I'd use, but credibility is lost for that
nonsense. No proffesionalism whatsoever. If I were admin I'd ban for less.
-
Sent from my NYPL BlackBerry Handheld.
- Original Message -
From: Raz [EMAIL PROTECTED]
Sent: 11/17/2005 05:08 AM
To:
Yeah, sorry for that language, but I couldn't believe what I had just
read and lost it...
On 17/11/05, Peter J Milanese [EMAIL PROTECTED] wrote:
Don't know if that's the word I'd use, but credibility is lost for that
nonsense. No proffesionalism whatsoever. If I were admin I'd ban for less.
On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote:
I have MySQL with about 12 billion rows when i try to create 2
process, each select count(*) on the same table after a long
time about 30 minutes it crashed :(
ANy information?
...
InnoDB: We intentionally generate
I need to pass to a stored procedure a var a table name.
But I don't known how use the variable in the sql statement.
If I use the method described belowe I get an error, the procedure use the
variable name as the name of the table.
Someone can help ?
CREATE FUNCTION `myFunc`( tbl_name
Hi All,
I have a simple problem and hope you can help me.
I have an input table Updates with various fields, incl. Month and MonthlyValue.
The field Updates.Month ranges from 1 to 12.
I also have a target Data table with 12 fields, called Jan, Feb, Mar, ... `Dec`.
Depending on Updates.Month the
uhh.NO!
That's what databases are for, to remember things. They do that by
writing data to disk and reading it back to you when you ask for it. What
exactly do you think you will be losing by stopping and restarting the
server daemon (service to you MS-types). What data do you think
Hi, and thank you both for valuable tips.
The MySQLd in question runs on a mailserver, and a large amount of
processes (Postfix, Maildrop and Squirrelmail) connect to it, run one
or two simple queries, and then disconnects.
There is only one client that is constantly connected, namely a
Hello All.
I am hoping for a bit of help with some code that has really given me
some trouble. If this is not he correct forum for this any help in
pointing me to a more suited list would be appreciated.
I have a MySQL 4.1.x database containing records with phone numbers.
Most of the
Not sure what you are asking for. If you are trying to get the
opposite of what you are getting, try adding
AND student_accom.start_date IS NULL
to the end of the query. You can actually use just about any field
instead of start_date.
For easier readability, you can rephrase your query to
Rick Dwyer [EMAIL PROTECTED] wrote on 11/17/2005 10:28:51 AM:
Hello All.
I am hoping for a bit of help with some code that has really given me
some trouble. If this is not he correct forum for this any help in
pointing me to a more suited list would be appreciated.
I have a MySQL
- Original Message -
From: Rick Dwyer [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, November 17, 2005 10:28 AM
Subject: A bit of SQL help for a MySQL novice.
Hello All.
I am hoping for a bit of help with some code that has really given me
some trouble. If this is
Unfortunately, the phone numbers come from text logs that get
imported into mysql. Because the phone number is often displayed on
a document for the customer, they will dictate how they want it to
appear (i.e. with ( ) etc.). The phone logs simply record those
values as they are so data
Hello.
4. triggers reference another table
They're allowed as of MySQL 5.0.10. See:
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
Jenny Chen wrote:
Does the current latest MySQL 5.0 support:
1. column based triggers
2. trigger restriction
3. multiple triggers of
Hello.
051116 16:27:54 [ERROR] Fatal error: Can't open and lock privilege
tables:=
Table 'mysql.host' doesn't exist
Have a invoked mysql_install_db? See:
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
Jörg Nowak wrote:
Hello list,
I compiled I
Hello.
I haven't said that this is the most effective solution, however, in my
opinion it should work :)
Fan, Wellington wrote:
Gleb,
Thanks; using REPLACE(), as I understand it, would require me to list ALL
non-alpha characters, and assuming just ASCII characters, approx (127 -
Hello.
At least there is one verified crash of MySQL Administrator on Mac OS,
however, not during the connection process:
http://bugs.mysql.com/bug.php?id=14269
You have a good description of your problem, and may want to report it at:
http://bugs.mysql.com
Yves Goergen wrote:
The fact that the data is coming from the text logs doesn't really change
anything; _something_ is generating the text logs so that something could be
changed to force users to supply phone numbers in whatever format you want.
Of course, that doesn't mean _you_ can force those changes to take
I'm trying to execute a MySQL Stored Procedure from my ASP.NET page:
Cmd=New MySqlCommand(sp_InsertNewCamper,Conn)
Cmd.CommandType = CommandType.StoredProcedure
paramReqID = Cmd.Parameters.Add(return,SqlDbType.Int)
paramReqID.Direction = ParameterDirection.ReturnValue
Rick
I need to read the first 4 positions in the phone number to determine
it's location.
My statement looks like this:
'Select mid(phone, 1,4) as phoneareacode from phonetable'
This works but if the number is entered as 1(203)-555-1212 the above
would return 1(20 which is not what I am
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
---
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for
Hi Rick,
Below are some MySQL functions that might help with your problem.
Sorry, for not much of direct answer.
But the idea is that you can combine some of these (string) functions -
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html to parse
out the string you are looking for. If
I have the following table:
CREATE TABLE history (
id int(10) unsigned NOT NULL auto_increment,
time_sec int(10) unsigned NOT NULL default '0',
account_id int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY account_id (account_id),
KEY time_sec (time_sec),
) TYPE=MyISAM
Hello.
I've written a stored procedure that can help you. However, I'd like to
see a solution which will work for 4.1 as well.
Here is the results. First group is select from the original table,
second group is select from the temporary table with the results.
id value
1 10
Hi!
I hope this is the right mailing list for my problem. :)
I recently changed the collation/character set in the whole database
for a project I'm working on to utf8. After a while I realized that
REGEXP didn't work as it used to. I looked in the manual and saw that
REGEXP was not multibyte
Oskar Joelson wrote:
I found this in
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
:
REGEXP and RLIKE use the current character set (cp1252 Latin1 by
default) when deciding the type of a character. Warning: These
operators are not multi-byte safe.
These operators are
Hello everyone,
Is it possible or makes sense to key a field that is a part of Unique
Index already?
Regards and thank you
Mikhail Berman
Mikhail Berman wrote:
Is it possible or makes sense to key a field that is a part of Unique
Index already?
It's possible, but it doesn't make sense. A unique index is a normal
index with an added unique constraint. Adding another index on the same
field would make no sense (unless the field
OK, after reading http://dev.mysql.com/doc/refman/5.0/en/order-by-
optimization.html I have learned improved the speed somewhat by
creating a multi-column index on account_id and time_sec, such that:
--
SELECT
Dear Jasper,
I may not have been precise in my question, but the Unique Index in
question is a two fields index, and I was looking to find out wisdom
from the List if there is sense and/or experience in keying second(left)
field on in the Unique Index to speed up a search.
I am dealing with 32M
René Fournier [EMAIL PROTECTED] wrote on 11/17/2005 04:19:25 PM:
OK, after reading http://dev.mysql.com/doc/refman/5.0/en/order-by-
optimization.html I have learned improved the speed somewhat by
creating a multi-column index on account_id and time_sec, such that:
What does your my.cnf configuration for mysql say? Check out:
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
I think you want character_set as your variable, not default_character_set.
Just my guess, not seeing any of your config files.
-Sheeri
On 11/16/05, wangxu [EMAIL
Marc:
Define crashing the server. Does the whole machine shut down? The
mysqld process? What do error logs say? What version of MySQL are
you using? What's the create table statement? what's the current
avg_row_length and max_rows? What is ulimit -f as the MySQL user say?
-Sheeri
On
Hi Marc,
Is there any message in the log files? or any error message from the OS?
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From:
On 17-Nov-05, at 2:41 PM, [EMAIL PROTECTED] wrote:
René Fournier [EMAIL PROTECTED] wrote on 11/17/2005 04:19:25 PM:
OK, after reading http://dev.mysql.com/doc/refman/5.0/en/order-by-
optimization.html I have learned improved the speed somewhat by
creating a multi-column index on account_id
Mikhail,
Is it possible or makes sense to key a field that is a part of
Unique
Index already?
MySQL won't stop you, but it's a waste of space cpu cycles unless
there's a high-priority query performance need for it.
PB
-
Mikhail Berman wrote:
Hello everyone,
Is it possible or
Hi Mikhail,
I may not have been precise in my question, but the Unique Index in
question is a two fields index, and I was looking to find out wisdom
from the List if there is sense and/or experience in keying second(left)
field on in the Unique Index to speed up a search.
If you have a
Is there any message in the log files? or any error
message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:33).
051116 10:06:33 [Note] /usr/sbin/mysqld: ready for
connections.
Version:
C.R.Vegelin wrote:
Hi All,
I have a simple problem and hope you can help me.
I have an input table Updates with various fields, incl. Month and MonthlyValue.
The field Updates.Month ranges from 1 to 12.
I also have a target Data table with 12 fields, called Jan, Feb, Mar, ... `Dec`.
Depending on
Hi Marc,
I would be a bit suspicious of the version of zlib or something similar.
If it has only been compiled with a 32bit compiler, this could be
causing an artificial limit of 2Gb on a pointer.
The ARCHIVE engine uses the zlib for its compression, that comes with
mysql. I am presuming if it
...that is the question.
I have some queries that would possibly benefit from subqueries,
which means upgrading my stock Mac OS X Server 10.3.9 installation of
MySQL (version 4.1.10a).
The question is, and I would appreciate any comments, should I go
just to 4.0.26 for the subqueries, or
Hi There,
We are reaching 4GB with one of our tables (v4.1 on debian sarge) and
are needing to run:
ALTER TABLE tbl_name MAX_ROWS=10 AVG_ROW_LENGTH=nnn;
as per the documentation.. I would be greatful for any input on best
practices to do this, as the database needs to be offline for
Your query was:
SELECT distinct accomodation.accom_id FROM accomodation LEFT JOIN
student_accom ON accomodation.accom_id = student_accom.accom_id where
((student_accom.start_date Between '2005-10-01' And '2005-11-30') OR
(student_accom.leave_date Between '2005-10-01' And '2005-10-30'))
The
I have an idea for preventing sql injection attacks, however it would
have to be implemented by the database vendor. Let me know if I am on
the right track, this totally off base, or already implemented
somewhere...
Lets say you could have a format string such as in printf
$format= SELECT %s
[EMAIL PROTECTED] wrote:
I have an idea for preventing sql injection attacks, however it would
have to be implemented by the database vendor. Let me know if I am on
the right track, this totally off base, or already implemented
somewhere...
Lets say you could have a format string such as in
Ok greg,
I'll report this bug
Thx
Greg 'groggy' Lehey wrote:
On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote:
I have MySQL with about 12 billion rows when i try to create 2
process, each select count(*) on the same table after a long
time about 30 minutes it
Follow is a part of my my.ini.
---
[client]
port=3306
default-character-set=utf8
---
If
51 matches
Mail list logo