Filter-fodder: mysql, query
Hi,
How can I avoid "Using temporary, "Using filesort"
when creating indices when my selects MUST be ordered?
Donna
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Is your table empty?
[EMAIL PROTECTED] wrote:
why am i not able to select the browse link on mysql phpmyadmin to view
my table
ultimatefootballleague.com/index.php
[EMAIL PROTECTED]
-
Before posting, please check:
http://ww
why am i not able to select the browse link on mysql phpmyadmin to view
my table
ultimatefootballleague.com/index.php
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
www.astatech.com and ZEOS components.
-Original Message-
From: Liu Qianghua-qch1942 [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 11:50 PM
To: [EMAIL PROTECTED]
Subject: How to connect to mysql server without myODBC
All,
I want to develop application with Delphi which can c
Hi,
I am new in programming. So hope to get some helps from your precious
experiences.
I am using mysql-3.23 in my FreeBsd4.3 (English version) server.
And I am also using phpMyAdmin to view and manage all the databases, tables
and fields from a workstation IE browser to access my server, which
Hi Doug,
try:
UPDATE SET ProdKeyword = REPLACE(ProdID,"-","");
prosit
Klaus
MySQL, Query, whatever, be a keyword :o)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
At 13:53 +1000 3/4/03, Throbware Support wrote:
Hi all.
I have spent some time studying the manual and previous posts, trying to get
a grip on the whole date_format issue... I am VERY new to MySQL having been
converted from an ADO/DAO environment with Access dBs...
Where I am having trouble is co
Hi all.
I have spent some time studying the manual and previous posts, trying to get
a grip on the whole date_format issue... I am VERY new to MySQL having been
converted from an ADO/DAO environment with Access dBs...
Where I am having trouble is coming up for a syntax to
SELECT *
FROM tableA
At 7:53 -0800 3/3/03, Nicole Lallande wrote:
Greetings,
I have been working with a software provider whose software db
configuration uses the default mysql installation (ie, root, no
password). They contend that since the mysql server itself is not
shared (ie, installed on a vps for a single u
At 13:19 -0600 3/31/03, Jonathan Villa wrote:
All,
I have been writing my applications using PHP/MySQL for about a year and
a half now. During this time and up to now, there hasn't been anything
wrong with my apps; however, I need to know if what I am doing is the
best route for optimal performan
At 21:56 -0500 3/3/03, Stitchin' wrote:
I found some stuff in the mySql manual about setting columns as fulltext
indexes for fulltext searches and the syntax is
WHERE MATCH (column names...) AGAINST (the search stuff)
So I went in and did an alter table statement to set my four search columns
to
Suporte schrieb:
Hi
I installed MySQL on a server running RedHat 8.0 and it's working fine. But
when I try to connect to MySQL from a remote station, using MySQL Control
Center, or even using the command-line "mysql", I get the message:
"Error 2013 - Lost connection to MySQL server during que
I found some stuff in the mySql manual about setting columns as fulltext
indexes for fulltext searches and the syntax is
WHERE MATCH (column names...) AGAINST (the search stuff)
So I went in and did an alter table statement to set my four search columns
to be in a fulltext index.
So here's the
It looks like you've got a type in your my.cnf
check where your mysql.sock is trying to create. It should be something
like:
/var/lib/mysql/mysql.sock
^
=C=
* Cal Evans
* Stay Plugged Into Your Audience
* http://www.christianperformer.com
-Original Message-
From: Chidambaram Ramac
Below is a patch to fix some problems I've had with the SSL connections
via the MySQL 4.0.10-gamma client library (is there are bug tracker
or something to file this in?)
SSL_CTX_use_certificate_chain_file allows the server/client to use
certificates signed by sub CAs.
Having SSL_VERIFY_FAIL_IF_N
Hi
I installed MySQL on a server running RedHat 8.0 and it's working fine. But
when I try to connect to MySQL from a remote station, using MySQL Control
Center, or even using the command-line "mysql", I get the message:
"Error 2013 - Lost connection to MySQL server during query"
The remote
Sat Mar 1 04:20:27 2003]:
I have MySQL 3.23 and i have gone thro the manual and also book by Paul.B. I get the following message "error 2002:: Can't connect to local MySQL server through socket '/var/li/mysql/mysql..sock" Pl mail your suggestion.
Ramachandran
--
I have an application that has stopped working after the ISP upgraded from
MySQL 3.23.36 to MySQL 4.0.11a-gamma-log
All I'm told is:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'jomaridb'
This is a commercial server so I have no access to the mySQL install. I'd
appreciate
>Description:
It appears that when an aggregate like MAX is used in a query, mysql will put
any
values in that it already has from internal statistics, however, this is wrong
if
the query being executed results in zero records, in this example, the MAX of
zero
val
>Description:
A freshly installed mysql 4.0.11a crashes at first startup: (mysql_install_db runs
fine), mysqld-safe --user=mysql chrashes and restarts in an endless loop.
This is true for both the linux binary and the source distro. The same mysql version
is stable on a system with identical sof
Good Day,
I have Linux 7.3 server with mysql and apache 1.3 with php 4.1
with the first web site using php and mysql I install on the server, I found
the processor utilization too high
processor idle time is 0% and mysql is about 85%, I don't know why.
Also the site gives too many connections er
Christian,
- Original Message -
From: "Christian Jaeger" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, March 03, 2003 2:31 PM
Subject: Re: The diferences about /dev/hda1 and access via raw device
> At 18:35 Uhr -0200 23.01.2003, Dyego Souza do Carmo wrote:
> >/dev/
Hi!
- Original Message -
From: "Yasaswi Pulavarti" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, March 03, 2003 7:19 PM
Subject: Re: Errors on ALTER table in InnoDB
> I don't know the answer. But I get similar errors when I use Erwin
> (Data Modelling software) to
You are a genius and I'm a moron Duh ... I put a GROUP BY in there!!!
So since all three designs were in the same group, it only showed one!!! I
didn't mean to make it a GROUP BY for the catcode, I meant to do an ORDER BY
the catcode then designfile see that's what I get for being a gr
Like several other people I noticed on the web, I am receiving an error
message "Error 2013: Lost connection to mysql server during query",
however I can not find the results of you corrections? Can you please
point me to the place where I can find a fix for this error?
Thanks
Bob
---
All,
I have been writing my applications using PHP/MySQL for about a year and
a half now. During this time and up to now, there hasn't been anything
wrong with my apps; however, I need to know if what I am doing is the
best route for optimal performance.
So I ask these questions:
1. How
Try : (on a test table first of course)
UPDATE prodtable SET ProKeywords = REPLACE(ProdID, '-', '');
You may want to look at this page:
http://www.mysql.com/doc/en/String_functions.html
jeff
At 11:57 -0600 3/3/03, Doug Coning wrote:
Hi all,
I want to take the data in a column, modify and then s
Here's how I would do it. (I'm sure that you'll probably get other
solutions as well.)
$query = "SELECT * FROM designs, appliquetable, puffyfoamtable WHERE
designs.puffyfoam = puffyfoamtable.puffyfoam AND
designs.applique = appliquetable.applique AND
TO_DAYS(NOW
That brought me up the record that was dated 3/1 but not the ones dated 2/17
and 2/18 which fit into the criteria also
We're getting there is there something going on with the fact that the
other two are in the previous month? That's kinda freaky considering that I
know because I echo'd
try 's arround the dates
$query = "SELECT * FROM designs, appliquetable, puffyfoamtable WHERE
designs.puffyfoam = puffyfoamtable.puffyfoam AND
designs.applique = appliquetable.applique AND
>(designs.designadddate <= '$today' AND
> designs.designa
Jeremy,
If you just want to use the server and connect to it to perform queries and
maintain it, just the server and clients should suffice. If you want to
link your own C programs against mysql or measure the exact performance on
your hardware, you may want the others.
By the fact that you're a
I have a column in my mySql database that holds a date that I've added each
record called
designadddate
I'm trying to create a filter to only pull up the records that have been
added over the last two weeks. This is my code ... I added the echo for the
$today and $twoweeksago variables to make su
Hi!
I have now fixed the hang to MySQL-4.0.12.
I let mysqld to release the adaptive hash S-latch when it passes the control
to the client as it sends result rows of a SELECT to the client.
Can you test the latest 4.0.12 bk tree?
Best regards,
Heikki
sql query
...
Subject: Re:
Hi all,
I want to take the data in a column, modify and then set it into another
column. In specific, I want to remove the dash from our Product ID column
and place it in another column without the dash.
For instance, a ProdID may be 'SK-22'. I want to take this value from
ProdID and place it a
I have a Web application that allows users to search for text in a
potentially complicated form, and then return results. Leaving aside
the issue of the speed of FULLTEXT searching, which I'm discussing
in a separate thread, I'm having a problem with an initial COUNT
query.
When the user enters t
MySQL List,
On the http://www.mysql.com/downloads/mysql-3.23.html
page, under Linux x86 RPM downloads, there are 5 available downloads.
Do I need all of them? I would like to have all capabilities. Can
someone advise me as to what each download is for? Thanks,
Jeremy Whitlock
On Thu, Feb 27, 2003 at 06:05:02PM +0100, Thomas Spahni wrote:
> Jesse
>
> But then something else must be terribly wrong. As long as you are pulling
> ten thousands of hits from the server, it may be slow. But when you reduce
> the number of results with (let's say) 'LIMIT 100' I expect typical s
> Hello,
> I am trying to start replication between 2 linux servers mysql version is
> 4.0.8.
> I am following all instructions, but I keep getting the following error
> message on the slave when I restart.
>
> 030303 10:35:28 mysqld started
> 030303 10:35:29 InnoDB: Started
> /usr/mysql/libexec
Greetings,
I have been working with a software provider whose software db
configuration uses the default mysql installation (ie, root, no
password). They contend that since the mysql server itself is not
shared (ie, installed on a vps for a single user) that there is no need
to add a password
Trying to setup Mysql 4.0.10 in a replication environment. 64bit compiled Sun solaris
2.8 platform.
We have had Mysql 4.0.5 installed and running in replication for several months and
are required to move version due to the bug in 4.0.5.
We have compiled the Mysql 4.0.10 from source and instal
On Friday 28 February 2003 22:17, Brian Bittman wrote:
> Subject: bug - sec_to_time has a low upper limit on the range
>
> Description:
> sec_to_time will not return times greater than 24,
> my hunch is that sec_to_time() is wrapping at 24:00 for some reason or
> that's some kind of bound, and it
On Monday 03 March 2003 04:36, anhduc nguyen wrote:
> I don't know why when i run mysql the message "Can't
> connect to mysql server throught port /tmp/mysql.sock"
> appear.
Check that MySQL server is running. If so find where mysql.sock is located.
--
For technical support contracts, goto htt
On Monday 03 March 2003 16:03, Sigurd Urdahl wrote:
> In one of our customers databases there is table that have an
> extremely high max_data_length of about 256TB(!). Another have 1 TB,
> while the rest is at 4GB. (all of these tables are basically the same,
> but with these two as the ones witht
On Friday 28 February 2003 22:00, Scott wrote:
> I have a client word database and I am attempting to create a database with
> the results from a select that splits the description field based on the
> spaces.
>
> When just executing the select command, the output is correct. When using
> the cre
On Saturday 01 March 2003 01:26, Henning Schulzrinne wrote:
> Both email columns have the same format (varchar) and are indexed
> individually:
>
> describe SELECT person FROM person WHERE email1='foo' OR email2='foo';
> ++--+---+--+-+--+---+--
Hello,
I am trying to start replication between 2 linux servers mysql version is
4.0.8.
I am following all instructions, but I keep getting the following error
message on the slave when I restart.
030303 10:35:28 mysqld started
030303 10:35:29 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for
On Mon, Mar 03, 2003 at 08:21:58AM -0700, Zak Greant wrote:
...
> To keep closer to standard SQL, wrap the SET call in an executable
> comment, like so:
>
> /*! SET table_type=innodb; */
>
> Most (all that I know of :) databases except MySQL will treat the
> comment like a nor
To add to this I am using this data via PHP. I think it might be
faster and easier to just create my summary via one select for the hits
and then an inline select for the hits as I loop thru my PHP code to
display the list of clients.
I also could just create to separate selects grouped by cli
On Mon, Mar 03, 2003 at 09:36:37AM -0500, Warren W. Gay VE3WWG wrote:
> I would like to create a Table default (Type=InnoDB) for a particular
> database. Is there a way to do this, or is this being planned for in
> a future release?
>
> For most of my databases, I am only interested in transact
Dan Tappin wrote:
I am sure I just have the wrong JOIN structure but I can't figure it
out. Any help would be appreciated.
Ah, if only it were that easy!
The problem is that you're really trying to summarize at two ways at the
same time, and SQL doesn't like to do that. On one hand you're
ag
I have a complex JOIN statement that I can't seem to get to work.
Here is my schema...
I have a 'forsale' table with various colunms. Here is the query for
the data I am interested in:
SELECT
id,
clientid,
price
FROM
forsale
WHERE user_id = 152
+--+-+---
I would like to create a Table default (Type=InnoDB) for a particular
database. Is there a way to do this, or is this being planned for in
a future release?
For most of my databases, I am only interested in transactions. Having
to remember to specify that table type = InnoDB for each table crea
Hello,
Does anybody use MySQL for dataminig such as clustering or decision
trees? Is there anything that can be integrated with the database or do
you use some other software?
Thank you
With regards,
Pavel Kusch
-
Before posti
Environment:
Windows XP Home
MySQL 3.23.55
MDAC 2.7
MyOLEDB 3.0
VC++ 6.0
I use MySQL from ADO using MyOLEDB. Everything worked fine so far till I
started using SQL joins. My application is pure breeded C++, but for
demonstration purposes I rewrote the essential part in VB:
Set cnn = New ADODB.Co
Hi all,
In one of our customers databases there is table that have an
extremely high max_data_length of about 256TB(!). Another have 1 TB,
while the rest is at 4GB. (all of these tables are basically the same,
but with these two as the ones withthe most data). The largest table
is currently at ab
Using SQL database would be a big hit in straightforward performance but
would be a huge win for the flexibility of rolling it out to many
different customers with different needs. Something a Value-Adding ISP
would want to use.
As for performance, there is always decision caching, defered logg
What is Connector/J. Is it just the program which runs on the server?
What GUI do you use for mysql?
Gustavo.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 13:10
To: Gustavo Cebrian
Subject: Re: Connector/J
Your message cannot be posted becaus
Joe Maimon wrote:
>
> All,
>
> My company is looking to extend the Squid redirector, SquidGuard to work
> realtime out of a SQL database. We are looking to target the GNU/Linux
> environment and the MySql database server.
>
> We are doing this for enterprise scalability reasons. This means tha
All,
My company is looking to extend the Squid redirector, SquidGuard to work
realtime out of a SQL database. We are looking to target the GNU/Linux
environment and the MySql database server.
We are doing this for enterprise scalability reasons. This means that
all flat-file configuration that
At 18:35 Uhr -0200 23.01.2003, Dyego Souza do Carmo wrote:
/dev/hda1:20Gnewraw
/dev/raw1:20Gnewraw
The speed is more fast in the last case or no ?
In my tests which I did half a year ago with mysql 3.X it depended on
the usage pattern.
The advantage of using hda1 (buffered raw partition) is that li
Hallo,
we have downloaded the new 3.23.55 mysql DB from you as Source Download
Tarball (tar.gz) and want to build them in our environment for tests
under SUN OS.
We have tared the downloaded version in our Scource Directory environment.
(for example /mysql/src/mysql-3.23.55)
After that we
Hi,
I wonder if something like in perl is possible:
data in rows:
1) a12345xb54321x
2) b54321xa12333x
I want to extract b(number) and store into another table.
In perl this would work with pattern matching (reg.expressions) like:
$data =~ s/.*?b(.*?)x.*?/$1/;
$data_b = $1;
so, reg.expressions
Hallo,
we have downloaded the new 3.23.55 mysql DB from you as Source Download
Tarball (tar.gz) and want to build them in our environment for tests
under SUN OS.
We have tared the downloaded version in our Scource Directory environment.
(for example /mysql/src/mysql-3.23.55)
After that we want
At 10:21 03/03/2003 +0100, Dusan Pavlica wrote:
Hi,
Hello,
I installed MySQL version 4.0.7-gamma on WinXP Professional couple weeks ago
and I usually connect to the server through ODBC drivers.
Last time I tried to stop server through panel Services and it lasted very
long time and
after that I was
Hello,
I installed MySQL version 4.0.7-gamma on WinXP Professional couple weeks ago
and I usually connect to the server through ODBC drivers.
Last time I tried to stop server through panel Services and it lasted very
long time and
after that I was not able to start the server again After restart it
Description:
Hello Peter,
I have sent to ftp://support.mysql.com/pub/mysql/secret the table definition
and data (Giros.txt) in a compressed file named Giros.zip so you can
invetigate it.
You can see the following queries:
SELECT TIPO,DOC,NRE
FROM GIROS
WHERE (GIROS.TIPO
Hello,
In MySQL Control Center 0.9.10 you cannot add an hotkey for
"cell edit" (double click on cell to edit it's content). I think that
adding a key for this is very important so the user will not need the
mouse to edit cells.
Sorin Sbarnea
Hi!
Ok, now I think I understand the problem. Since you use the -q option, the
client mysql retrieves rows in the result set in chunks of some size. As
InnoDB keeps the adaptive hash index latch S-locked till the end of the the
big
SELECT ... ORDER BY ...
query, it will probably be S-latched wh
Hi!
Your email address gives the error:
"
DNS for host dev.noris.de is mis-configured
The following recipients did not receive this message:
<[EMAIL PROTECTED]>
"
Still one question: is this a deadlock of threads at all? Maybe the sorting
which mysqld does, or the fetches which:
mys
69 matches
Mail list logo
