On Tue, 14 Sep 2004 01:07:53 -0400, Seth [EMAIL PROTECTED] wrote:
I am fairly new to MySQL and I have been trying to form a way to have select rows
numbers put back to 0, sort of like a reset in some rows of the table.
The table is ladder_1 and I am trying to have the fields
Don't know a whole lot about this but - Is the data escaped when you
inserted it? Maybe one of these options for the mysqldump would help
--fields-enclosed-by=...
--fields-optionally-enclosed-by=...
--fields-escaped-by=...
or
--set-charset ...
Respectfully,
Ligaya Turmelle
Juan Alvarado wrote:
Hi
I'm using Mysql 4.x...
when I try following:
CREATE TABLE `MyTable` (
`SNumber` char(32) NOT NULL,
`UserID` char(32) NOT NULL default '0',
PRIMARY KEY (`SNumber`)
) TYPE=MyISAM;
It created the exactly correct table, But when i add
any varchar field in the above sql..then generated
Is there any MySQL built in function to convert datetime types to real numbers (float)
i.e. seconds or days since a reference date? I can't find any in the manual.
If not, how do I best write a speedy one (conversion of calendar dates to Julian days
is a bit tricky)?
Thanks in advance for any
HI,
I have a table, let's call it item, which has a field containing a
comma separated list of IDs of related items ( same table ).
I know, this is far away from a correctly normalized structure and this
stuff should be handled using another table for the link, but I'm
working on a
Is there a way of checking for live connections prior to using
mysql_connect in the C API (asside from mysql_ping)
Ruben
--
__
Brooklyn Linux Solutions
So many immigrant groups have swept through our town
that Brooklyn, like Atlantis, reaches mythological
Your message was undeliverable due to the following reason(s):
Your message could not be delivered because the destination computer was
not reachable within the allowed queue period. The amount of time
a message is queued before it is returned depends on local configura-
tion parameters.
Most
John,
give it a try. I had to enable ft_min_word_len=2 on a collection of legal
texts because people are searching for abbreviations consisting of 2
letters. It works fine for me.
Thomas Spahni
On Mon, 13 Sep 2004 [EMAIL PROTECTED] wrote:
I'm wondering whether or not I should implement
What is this?
On Tue, Sep 14, 2004 at 10:28:53AM +0200, [EMAIL PROTECTED] wrote:
Your message was undeliverable due to the following reason(s):
Your message could not be delivered because the destination computer was
not reachable within the allowed queue period. The amount of time
a
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
Don't do an @usrDays, just stick the number in there so that the
statement you create looks exactly like the one you tested with.
If you get a number from a user from a form, just put that value into
the string. For instance if the
Not sure exactly what you mean by a SQL injection
attack. I'm thinking a string could be input as
opposed to an integer ?
The form itself constricts user to a set of choices.
Stuart
--- Harald Fuchs [EMAIL PROTECTED] wrote:
I think this is bad advice, even for a novice like
Stuart, because
Let's Party! provides any database with table partitioning capabilities
(as long as it is accessed using JDBC).
Why table partitioning?
Because:
1. If you put your partitions on different hard disks you will gain
throughput
2. Scans of tables will require less time, because you will access
In article [EMAIL PROTECTED],
Stuart Felenstein [EMAIL PROTECTED] writes:
Not sure exactly what you mean by a SQL injection
attack. I'm thinking a string could be input as
opposed to an integer ?
Exactly - especially an SQL string.
The form itself constricts user to a set of choices.
This
When I try and log in with the new password I get this error:
Error 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
The instructions that I followed required me to kill the mysqld process and
restart it with the --skip-grant-tables option and log into the root account
I just installed MySQL from the mysql-3.23.58-1.i386 RPM
on a vigrin Red Hat Enterprise server. According to the
manual, mysql_install_db gets run automatically when you
do this, but I don't know what to look for as evidence that
this has happened.
If I try to run mysql_install_db by hand, I
Hello,
Tell us the OS, the MySQL server and client version and the build information
(custom or binary downloaded from MySQL.com).
Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
This *might* be a problem of resolver in glibc.
I don't see a reason why it should be a
Hello ,
I am having some 10 rows of data in my database table. If i dump the
database the value retrieving is appending with some other row value also.
For example
If my one record contains the value as Hello..while dumping as a sql file
it is storing as a Hello + from some other row
Uma,
the answer is 42 (or - probably - mysqldump --help | less).
But what is your problem? Are you dumping in --extended-insert mode?
Can you give us an example?
Regards, Thomas
On Tue, 14 Sep 2004, T UmaShankari wrote:
Hello ,
I am having some 10 rows of data in my database table. If
On Tue, 14 Sep 2004, Sheraz wrote:
when I try following:
CREATE TABLE `MyTable` (
`SNumber` char(32) NOT NULL,
`UserID` char(32) NOT NULL default '0',
PRIMARY KEY (`SNumber`)
) TYPE=MyISAM;
It created the exactly correct table, But when i add
any varchar field in the above
* Giulio
I have a table, let's call it item, which has a field containing a
comma separated list of IDs of related items ( same table ).
I know, this is far away from a correctly normalized structure and this
stuff should be handled using another table for the link, but I'm
working on a
* Håkan Elmqvist
Is there any MySQL built in function to convert datetime types to
real numbers (float) i.e. seconds or days since a reference date?
I can't find any in the manual.
There are plenty of date and time manipulating functions available. Take a
look at to_days() and
Hi,
Our mysqld segfaults from time to time on our system. We don't see any
other programs segfaulting, and therefore suspect a bug in mysql.
I enclose a resolved stacktrace, and any other system information that
might be helpful. I hope someone has any suggestions on what to do in this
I agree and I am sorry I forgot a very basic security practice. You must
always check any input from a user. Make sure that the user gives you a
valid number and reject the request if it is anything out of your
acceptable range or datatype. Otherwise a bad user could compromise your
database
Hi,
I found the expression 8 bytes network address in MySQL Manual
online manual.
I know IPv4(4bytes), IPv6(16bytes).
Please let me know what is 8 bytes network address.
http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html
INET_ATON(expr)
Given the dotted-quad
Hi,
If you're using 4.0.20, jump to 4.0.21 :
Fixed crash in MATCH ... AGAINST() on a phrase search operator with a
missing closing double quote.
Regards,
Jocelyn
Hi,
Our mysqld segfaults from time to time on our system. We don't see any
other programs segfaulting, and therefore suspect a bug
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
I agree and I am sorry I forgot a very basic security practice. You must
always check any input from a user. Make sure that the user gives you a
valid number and reject the request if it is anything out of your
acceptable range or
I recently had an issue where I was getting timeout waiting for
connection and max pool size type errors. I finally was able to
resolve the problem by setting pooling=false in the connection string.
While I'm happy to have resolved the error, it made me realize that I
have no idea what is
It's all good information. I need to be thinking security as well as generating
proper efficient code. All is appreciated.
Stuart
Harald Fuchs [EMAIL PROTECTED] wrote:
In article ,
[EMAIL PROTECTED] writes:
I agree and I am sorry I forgot a very basic security practice. You must
always
It matters greatly what software/drivers you are using to connect with.
You need to first consult the documentation for CoreLab's MySQLDirect for
details about whether it pools connections or not. The connections are
pooled client-side, not server-side so I would start with that library.
You
Hello:
For the last couple of months I have been learning installing LINUX, MySQL
opther software. Until last week I installed mysql-4.0.20 and then installed
PERL modules without problem.
Last week the new MySQL verion became available I started installing it.
Now when I install PERL modules,
hi...
a question on how to do an update on a table that depends on 'left/right'
joins with other tables...
i have the following select that works.
select
u1.urltype as type,
p1.fileID as fileID,
l1.process as process,
l1.status as status
from university_urlTBL as u1
right join parsefileTBL as
Hello,
For several years I am hosting a popular website using PHP and MySQL.
As the site is growing and evolving, speed is becoming more and more
important.
With my latest inventions on the website, I notice that the website is
becoming slow and I want to find out what's causing this.
And this
Hello
I am doing a technical comparison between two products of which one is
MySQL. But I don't exactly know which product that MySQL offers that I
should pick.
I am thinking of MaxDB, because it's supposed to be the most feature rice,
but it does not seem to be MySQL but another product owned
Dirk,
Hello,
For several years I am hosting a popular website using PHP and MySQL.
As the site is growing and evolving, speed is becoming more and more
important.
With my latest inventions on the website, I notice that the website is
becoming slow and I want to find out what's causing this.
And
Hi, Sorry to disturb but Mysql 4.1.4 gamma goes down when executing this
query.
I've tryed the same query without the coalesce function and the problem
persists.
select
coalesce(viehc,0),
coalesce(vieapellido,0),
coalesce(vienombres,0),
coalesce(viedoc,0),
Run myisamchk on the host file if you can.
95% full is not good.
Thank's for you're help, it work fine now :)
Diego
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In the last episode (Sep 14), Dirk Schippers said:
For several years I am hosting a popular website using PHP and MySQL.
As the site is growing and evolving, speed is becoming more and more
important. With my latest inventions on the website, I notice that
the website is becoming slow and I
You have not mentioned the use of a multiple column index, for that matter,
no indexes at all. I would suggest a multiple column index in the form of
hidden, touser. That index form should speed up your queries and solve the
problem. Mike
- Original Message -
From: Fagyal Csongor
Why not just add an index on touser+hidden. Problem solved.
Donny
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:48 AM
To: Dirk Schippers
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL speed
In the last episode (Sep 14), Dirk
Can anyone tell me what's going on? Are there MySQL parameters that can
improve things?
To know if you need to tune something, you can send us the copy of SHOW
STATUS; and SHOW VARIABLES;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In trying to download the mysql Linux x86 RPM server rpm download from
http://mysql.mirrors.ilisys.com.au/Downloads/MySQL-4.0/MySQL-server-4.0.21-0.i386.rpm
after an hour or so downloading it, I ended up with an error message;
Plugger: no approperiate (sic) application for type
I want to copy rows of data from a query result to another table. How do I
accomplish this? Here's my example for further explanation...
I have 2 tables, candidate and resume. I have 2 other (currently empty)
tables, exact duplicates, candidate_erp and resume_erp. In resume_erp will
be
I would right click on the link and choose to save target... do not
left click such that it would try to open it. as rpm could also be
used by RealPlayer/RealOne for their media files.
On Wed, 15 Sep 2004 01:21:55 +0800, Bret Busby [EMAIL PROTECTED] wrote:
In trying to download the mysql
Does the message below, mean that everyone who posts a message to this
list, will receive a message such as the one below, from the person
below, for the next week?
--
Bret Busby
Armadale
West Australia
..
So once you do know what the question actually is,
you'll know what the
- Original Message -
From: bruce [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:45 AM
Subject: update/join question..
hi...
a question on how to do an update on a table that depends on 'left/right'
joins with other tables...
i have the following
Bret Busby wrote:
In trying to download the mysql Linux x86 RPM server rpm download from
http://mysql.mirrors.ilisys.com.au/Downloads/MySQL-4.0/MySQL-server-4.0.21-0.i386.rpm
after an hour or so downloading it, I ended up with an error message;
Plugger: no approperiate (sic) application for
try
INSERT INTO other_table
( field1, field2, etc)
SELECT SQL_CALC_FOUND_ROWS *
FROM wow.resume r
INNER JOIN wow.candidate c
WHERE r.Section_ID = '1'
AND MATCH (r.Section_Value)
AGAINST ('+BAAN' IN BOOLEAN MODE)
AND c.Candidate_ID = r.Candidate_ID
Peter
-Original Message-
From: Eve
Does the message below, mean that everyone who posts a message to this
list, will receive a message such as the one below, from the person
below, for the next week?
Yes. Great isn't it. Those people should be smacked in
the head.
With regards,
Martijn Tonies
Database Workbench - developer
Rhino, I hate to burst your bubble but JOINS __are allowed__ in MySQL
updates. I use them all the time.
http://dev.mysql.com/doc/mysql/en/UPDATE.html
At the top of the page are the syntaxes for single-table and
multiple-table updates:
The key here is that whatever you put _between_ the words
Rhino, I hate to burst your bubble but JOINS __are allowed__ in MySQL
updates. I use them all the time.
http://dev.mysql.com/doc/mysql/en/UPDATE.html
At the top of the page are the syntaxes for single-table and
multiple-table updates:
The key here is that whatever you put _between_ the words
On Wed, Sep 15, 2004 at 01:33:08AM +0800, Bret Busby wrote:
Does the message below, mean that everyone who posts a message to this
list, will receive a message such as the one below, from the person
below, for the next week?
Not any more, because he's been unsubscribed from all MySQL mailing
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
--
Joe McGuckin
ViaNet Communications
994 San Antonio Road
Palo Alto, CA 94303
Phone: 650-213-1302
Cell: 650-207-0372
Fax: 650-969-2124
--
MySQL General Mailing List
For list
Shawn,
Just wanted to let you know your help was appreciated. I'm close to getting it
straight. Away from my console for the day so I won't know till later. However,
while I did figure out the correct variable and query name, there is about 20 other
lines of code that needed adjusting to
If you are going to be out of the office... suspend you subscription
to the mailing list... so that everyone does not recieve these notices
please
On Tue, 14 Sep 2004 19:43:29 +0200, Martijn Tonies [EMAIL PROTECTED] wrote:
Does the message below, mean that everyone who posts a message to
That might be a word defined in the stopword file, excluding full text
lookup on.
Stop words are words like
The
As
In
If
And so on.
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: joe mcguckin [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
You might not have to unsubscribe. Some mail apps, like Notes, will
let you configure your Out of Office agent to NOT send an automated
reply to specific incoming emails. I've done this using Notes, and it
works quite well. Nobody on list wants to know that you're on holiday
in Hawaii while
On Mon, Sep 06, 2004 at 12:48:37PM -0700, Miles Keaton wrote:
If my company wants to get the best-performing fastest platform for a
MySQL server, what would it be these days? Opteron? Dual? Quad?
And on a related note...
If a 64-bit CPU, then I'm assuming it would need an operating
A guess, its looking for that string. Maybe should be looking something
like it
example
select * from table where var like '%foo%'
-Blake
joe mcguckin wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
--
I can verify that a quad opteron 2.2 runs about a million times better than
a quad xeon 3.06. The opteron can handle more than 3 gigs of memory which
is a 32 bit limitation. Right now in my quad opteron we have 32 gigs of
memory and MySQL is using 16.8 gigs of the memory.
We run fedora core 2,
Hi,
I can vaguely remember there was something like INSERT... on duplicate
key UPDATE... in MySQL, but the documentation search is almost as
useful as I'm used to - it cannot tell me anything about this. Can you
please? How does this work, what's the syntax? Is this ANSI-SQL standard
(or
I think what you mean is REPLACE. Try
http://dev.mysql.com/doc/mysql/en/REPLACE.html
Yves Goergen wrote:
Hi,
I can vaguely remember there was something like INSERT... on
duplicate key UPDATE... in MySQL, but the documentation search is
almost as useful as I'm used to - it cannot tell me
On Tue, 14 Sep 2004, joe mcguckin wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
In addition to the other suggestions, make sure our ft_min_word_len isn't
more than 2, because it won't index words shorter than that many characters.
--
MySQL General
At 01:54 PM 9/14/2004, you wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
Joe,
By default MySQL has a 4 letter minimum for fulltext searches;
words must be at least 4 letters in length otherwise they won't get added.
Since you are
Yves Goergen wrote:
Hi,
I can vaguely remember there was something like INSERT... on
duplicate key UPDATE... in MySQL, but the documentation search is
almost as useful as I'm used to - it cannot tell me anything about
this. Can you please? How does this work, what's the syntax? Is this
mos wrote:
At 01:54 PM 9/14/2004, you wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
Joe,
By default MySQL has a 4 letter minimum for fulltext searches;
words must be at least 4 letters in length otherwise they won't get
added.
On Tue, 14 Sep 2004, Yves Goergen wrote:
Hi,
I can vaguely remember there was something like INSERT... on duplicate
key UPDATE... in MySQL, but the documentation search is almost as
useful as I'm used to - it cannot tell me anything about this. Can you
please? How does this work, what's the
Ops, replied to you only...
On 14.09.2004 22:21 (+0200), Dirk Schippers wrote:
I think what you mean is REPLACE. Try
http://dev.mysql.com/doc/mysql/en/REPLACE.html
No, REPLACE *always* replaces the entire row, but I want to update a
single value only, and if the row doesn'T exist, it should be
On 14.09.2004 22:44 (+0200), Tobias Asplund wrote:
It's covered on the INSERT page:
http://dev.mysql.com/doc/mysql/en/INSERT.html
If you specify the ON DUPLICATE KEY UPDATE clause (new in MySQL 4.1.0), and
(...)
Mmh, yes, thank you. There's just too much text. Anyway, v4.1 is too
late... I need
On Tue, Sep 14, 2004 at 03:05:07PM -0500, Donny Simonton wrote:
I can verify that a quad opteron 2.2 runs about a million times
better than a quad xeon 3.06. The opteron can handle more than 3
gigs of memory which is a 32 bit limitation. Right now in my quad
opteron we have 32 gigs of
Do you guys have metrics on this that you would be willing to share? We
are looking at upgrading to the Opteron (from the Xeon) at the moment.
Any information would be very helpful.
Brian Abbott
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September
Also, out of curiosity, who was your vendor for the opteron?
Brian
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 2:21 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]; 'Miles Keaton'
Subject: Re: best-performing CPU + platform for MySQL
At 03:43 PM 9/14/2004, Mike Blezien wrote:
mos wrote:
At 01:54 PM 9/14/2004, you wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
Joe,
By default MySQL has a 4 letter minimum for fulltext searches;
words must be at least 4 letters in
(Hi all, I'm a friend of Dirk and helping him trying to speed up everything)
Fagyal Csongor wrote:
Dirk Schippers wrote:
And this is the question that makes me totally confused:
How is it possible that the following query:
SELECT COUNT(*) FROM messages WHERE touser = 20 AND hidden = 0 with
a key
On Tue, Sep 14, 2004 at 02:31:54PM -0700, Brian Abbott wrote:
Do you guys have metrics on this that you would be willing to share? We
are looking at upgrading to the Opteron (from the Xeon) at the moment.
Any information would be very helpful.
I don't have any yet but should in a week or two.
MySQL released this a few weeks ago.
http://www.mysql.com/news-and-events/press-release/release_2004_27.html
As far as personal benchmarks, it's fast. Real fast. With a quad Xeon
(which was more expensive than the quad opteron) our master server had a
normal load of 2-3. With the the quad
Tobias Asplund wrote:
Can anyone tell me what's going on? Are there MySQL parameters that can
improve things?
To know if you need to tune something, you can send us the copy of SHOW
STATUS; and SHOW VARIABLES;
What is preferred in this mailing list: the whole texts in the mail, or
as
Friendster has for lack of better words HAVE A LOT of Opterons. In fact we
have become experts with configuring what would be best with mySQL + Linux +
opterons. I have a ton of benchmarks for various kernels and configs on
local disk and or SAN configs.
Just to give you some really basic stats
pray, that you use mysql version =4
in version 3 it doesnt work...
Oliver
On Tue, 14 Sep 2004 14:09:43 -0400, [EMAIL PROTECTED] wrote:
Rhino, I hate to burst your bubble but JOINS __are allowed__ in MySQL
updates. I use them all the time.
http://dev.mysql.com/doc/mysql/en/UPDATE.html
At the top of
MySQL 3.23.58:
ive got 2 tables with ca. 3 entrys each
now i wanna join, if one entry is in the one table, which isnt in the
other one
so this will be a normal join:
Tabelle1:
Artikelnummer, blah, blah, blah
Tabelle2:
Artikelnummer, blah, blah, blah
select Tabelle1.Artikelnummer from
Sorry, I meant to send this reply to the whole mailing list, not just to
Shawn.
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 2:18 PM
Subject: Re: update/join question..
Okay, I stand corrected. Apparently, MySQL
Hi
Try setting these variables in you conf:
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_size=10M
you have to experiment with the size as it depends on how much ram you
hardware has.
Nickolai Nielsen
-Oprindelig meddelelse-
Fra: [EMAIL
Because I have received off-list responses from different people, rather
than send the same response to everyone who responds to me off-list, my
response is below.
It appears that a problem lies in the web browser trying to open the
RPM, rather than downloading it, and, as it is trying to
What happens when you right click on the link, should give you the option to
save as? Works for me w/ Mozzila
-Original Message-
From: Bret Busby [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 9:37 PM
To: [EMAIL PROTECTED]
Subject: Re: Unable to download MySQL (fwd)
Bret Busby wrote:
Because I have received off-list responses from different people, rather
than send the same response to everyone who responds to me off-list, my
response is below.
It appears that a problem lies in the web browser trying to open the
RPM, rather than downloading it, and, as it
Hello.
I have a subroutine which checks for multiple entries and if a user has
voted once in the same day, it will not calculate the vote. However, I
found out that it does not really do this.
What it does is only look at the last entry. If the user IP address is
the last entry it does not
Hi,
I added a composite index to a MyISAM table
e.g. ALTER TABLE foo ADD INDEX (column1, column2).
Because I didn't specify a name for the index, SHOW KEYS is showing the Key name
to be column1. Is there a command to change the Key name ? I don't want to
drop/recreate the index.
Thanks
Xanana
On Tue, 14 Sep 2004 19:55:42 -0700, Soheil Shaghaghi [EMAIL PROTECTED] wrote:
I have a subroutine which checks for multiple entries and if a user has
voted once in the same day, it will not calculate the vote. However, I
found out that it does not really do this.
What it does is only look at
On Tue, 14 Sep 2004, Jonathan Jesse wrote:
Date: Tue, 14 Sep 2004 21:50:45 -0400
From: Jonathan Jesse [EMAIL PROTECTED]
To: Bret Busby [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Unable to download MySQL (fwd)
What happens when you right click on the link, should give you the option
88 matches
Mail list logo