Hi,
MySQL 4.0.21, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in source
and binary form for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites.
Note that not all mirror sit
After Shawn's guidance, I tried inserting with the temporary table method
using this:
CREATE TEMPORARY TABLE tmpStats (KEY(product_id))
SELECT TP.thread_id, COUNT(TP.thread_id) AS num_posts, MAX(TP.post_date) AS
last_update
FROM thread_post AS TP
INNER JOIN thread_link AS TL ON TP.thread_i
- Original Message -
From: "Tim Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 09, 2004 9:36 PM
Subject: List of MySQL Keywords
> Hello All:
> I would like to make up a complete (if possible)
> list of MySQL query keywords. I would appreciate
> pointe
In the last episode (Sep 09), Tim Johnson said:
> Hello All:
> I would like to make up a complete (if possible)
> list of MySQL query keywords. I would appreciate pointers to
> documentation that might hold such a list, without too much
> extraneous or extra text.
>
> In my current documentati
Hello All:
I would like to make up a complete (if possible)
list of MySQL query keywords. I would appreciate
pointers to documentation that might hold such a list,
without too much extraneous or extra text.
In my current documentation, the Manual Function Index
is a good source, but if I could
Dears,
I have a bank with 3 tables.
tbl_1 : username & password
tbl_2 : personal information
tbl_3 : user accountting
Each row related one.Record 3 from tbl_1 related to
recorde 3 from another tbl.
If i want to reduce overhead,How i do it?
Please guide me.
Y
A unique index can actually be faster than a regular index. The reason
is that MySQL knows that there can only be a single matching row for
each value. In particular, this allows you to get "const" and "eq_ref"
for the type in an EXPLAIN, which are two of the fastest methods of
table access.
I don't think your problem has anything to do with your Update statement or
Select statements, assuming you reported them accurately.
Could another user of the system have emptied your table? Could you have
inadvertently executed a statement or a script that would have emptied it?
Those seem like
The uniqueness constraint would only be enforced during an INSERT or an
UPDATE. If your table is read-only, declaring the index as UNIQUE will be
overkill. I can't tell you about any kind of performance hit during
reading but I try to follow the maxim "don't ask for it if you won't need
it". I
On Fri, 10 Sep 2004 05:54:42 +1000, Matthew Boulter <[EMAIL PROTECTED]> wrote:
> Any help with the values I should be using or any guidance on
> estimating a Queries Performance would be unimaginably appreciated.
This is an area in which I felt better armed when I used Oracle. I'm
curious to see
Hi:
I was wondering if there is any performance-related reason to use a
unique index versus a standard index? Is the only benefit of a unique
index that it will prevent duplicate values from being inserted into a
table unless explicitly allowed?
I have a column, colA, that I know contains only un
At 16:30 -0700 9-09-2004, Mauricio Pellegrini wrote:
Hi,
Sorry to ask this in here. If it's not the right place please ignore the
post.
I want to know if someone could claim a license upon an application wich
was developed using Php and a non-commercially-licensed copy of MySql.
I mean, the applica
Yes, you're right. Let me explain it more clearly.
Before UPDATE, there are 45 records in table "temp"
and I updated 9 of them.
Mysql returns how many rows were affected which is 9
rows.
Then, I opened the table temp and found that table is
empty!No records at all.
Therefore, that is why I feel so
G'day all, I was hoping to leech from your amalgamated knowledge:
I've been asked to estimate the query performance of several SQL
queries that power our Reporting system. At the moment we're
preparing to scale up enormously the amount of data we're using in our
system, and therefore I'm trying to
Hello:
I am trying to install Perl support with MySQL. After installing MySQL
(v4.0.20)I run the following commands:
% echo $PATH
% perl -MCPAN -e shell
Note: Answer no to auto-configure perl.
cpan> install Data::Dumper
(Upto this point. Following commands are n
- Original Message -
From: "Monet" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, September 09, 2004 2:13 PM
Subject: WHY this query keeps failure?
> Hello,
>
> I was working on a table, doing a simple update on
> table. Query is:
> Update temp
> SET Q1 = 14,
>
Hi,
Sorry to ask this in here. If it's not the right place please ignore the
post.
I want to know if someone could claim a license upon an application wich
was developed using Php and a non-commercially-licensed copy of MySql.
I mean, the application is designed to work only with MySql as databa
In the last episode (Sep 09), Fagyal Csongor said:
> Dan Nelson wrote:
> >In the last episode (Sep 09), leegold said:
> >>Could anyone link me or explain the purposes of backquotes in an
> >>SQL statement. I tried searching the manual and googling it but
> >>couldn't find a simple explaination. ```
Thanks Shawn, I'm going to give the temporary table idea a try.
I did omit the 'category' table while testing but when I used EXPLAIN the # of rows
for the thread_link join increased from 105 to 16326 so I decided to leave the
category table in. But I agree, it isn't needed.
My other idea I ha
Single and double quotes are usually string identifiers (double quoted
strings can sometimes also refer to database objects) Backticks
(backquotes) always refer to database objects (columns, tables, indexes,
databases, etc.). Here is the page in the manual that explains it all.
http://dev.mysql
> In the last episode (Sep 09), leegold said:
> > Could anyone link me or explain the purposes of backquotes in an SQL
> > statement. I tried searching the manual and googling it but couldn't
> > find a simple explaination. ``` vs. "regular" single quotes'''.
> > Thanks, Lee G.
>
> Backquotes are u
Hello,
I was working on a table, doing a simple update on
table. Query is:
Update temp
SET Q1 = 14,
REVIEWCOMMENTS =
CASE WHEN REVIEWCOMMENTS='WHO2' THEN ''
WHEN REVIEWCOMMENTS LIKE '%,WHO2' THEN TRIM(TRAILING
',WHO2' FROM REVIEWCOMMENTS)
WHEN REVIEWCOMMENTS LIKE 'WHO2,%' THEN TRIM(LEADING
'W
Dan Nelson wrote:
In the last episode (Sep 09), leegold said:
Could anyone link me or explain the purposes of backquotes in an SQL
statement. I tried searching the manual and googling it but couldn't
find a simple explaination. ``` vs. "regular" single quotes'''.
Thanks, Lee G.
Backquotes a
In the last episode (Sep 09), leegold said:
> Could anyone link me or explain the purposes of backquotes in an SQL
> statement. I tried searching the manual and googling it but couldn't
> find a simple explaination. ``` vs. "regular" single quotes'''.
> Thanks, Lee G.
Backquotes are used to delimi
Could anyone link me or explain the purposes of backquotes in an SQL
statement. I tried searching the manual and googling it but couldn't
find a simple explaination. ``` vs. "regular" single quotes'''.
Thanks, Lee G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Actually mysqld parameter bind-address work great for different IP addresses on same
port for different servers on same machine. One can use -h for clients
connection to a specific MySQL database server.
Thanks !
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: T
I know you said this was a translation of your original query. Assuming
that it is a faithful translation, I have the following suggestions:
Do not enclose numbers with quotes (category_id is a number, right? No
quotes are needed)
You do not need include the table "category" in this query. You
On Thursday, September 09, 2004 - Karam Chand said:
> Probably you should put it as a bug in SQLyogs forums.
I have put a bug request into the MySQL Query Browser bug track instead.
I like this tool very much, it has some very nice features like the
multithreaded results fetching.
Cheers
Hi
We have a machine with 2 IP addresses and mysql 3.23 on one and 4.10 on the
other. Both using port 3306
One instance listens on localhost, which maps to 127.0.0.1, and also on one
of the public IP addreses and the other listens to the other IP address.
I use the IP address in the connection s
One thing Jim didn't mention is that mysqldump is not a mysql client
command but a standalone executable. Run it from a shell prompt (DOS
prompt if you are using windows)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Jim Grill" <[EMAIL PROTECTED]> wrote on 09/09/2004 11:
>
> --
> help please
>
> please tell me how to extract a script file of a database from mysql
commandprompt.
>
> s.deepak
>
>
> This life is a hard fact; work your way through it boldly, though it may
be adamantine; no matter, the soul is stronger
>
> Swami Vivekananda
>
Are you looking for mysql
Probably you should put it as a bug in SQLyogs forums.
Karam
--- Jose_Miguel_Pérez <[EMAIL PROTECTED]> wrote:
> Karam Chand said:
>
> > I use SQLyog. It does allow you to create/delete
> FKs
> > with "ON UPDATE" criterias.
> >
> > Yeah, it does not allow you to create Fks in
> graphical
> > mann
I'm having a bit of a problem with a query that takes a very long time (up to 1
minute) when many matching rows are found.
The tables are all indexed and the explain seems to indicate that mysql is using the
indexes but it is still painfully slow:
mysql> SELECT COUNT(TP.thread_id) AS num_posts,
--
help please
please tell me how to extract a script file of a database from mysql commandprompt.
s.deepak
This life is a hard fact; work your way through it boldly, though it may be
adamantine; no matter, the soul is stronger
Swami Vivekananda
--
MySQL General Mailing List
For list archives: ht
The manual's often a friend, but not always, a case in point being the
suggestion on that manual page to "Upgrade all client programs to use a
4.1.1 or newer client library"--you will correct me if I am mistaken on
this, I hope, that one's only option now using ODBC and MySQL 4.1 or later
is to rev
- Original Message -
From: "Bernd Jagla" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, September 09, 2004 10:44 AM
Subject: referencing MySQL
> Anybody knows how to reference MySQL in a scientific paper?
What do you mean? Are you asking how to put a hyperlink to th
Anybody knows how to reference MySQL in a scientific paper?
Thanks
Bernd
> I have been getting following error.
> [polaris] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES)
>
> How to fix that?
> What is default port for mysqlserver?
> thx
> -seena
>
Is this a new install? Have you set the password yet? Have you forgotten the
password?
The
I don't know the source of the "INTERSECT" command that keeps popping up
on the list but this is a straight-forward JOIN situation if I have ever
seen one.
Please read for more details: http://dev.mysql.com/doc/mysql/en/JOIN.html
SELECT A.*, E.*
FROM A
INNER JOIN B
ON A.ID = B.parentid
> Hi,
>
> I am trying to compile MySQL. I know that it is possible to install this
> as a binary, that is not my goal.
>
> My environment consists of the following: If there are other tools that
> I need to specify please let me know.
> gcc-3.2-7
> libgcc-3.2-7
> gcc-c++-3.2-7
>
> I run configure a
Even the most recent version of the ODBC drivers act as though they are
pre-4.1 clients. Now that you know that, what you read in this article
should make better sense:
http://dev.mysql.com/doc/mysql/en/Old_client.html
It contains links to other details on the issue and some suggestions to
wor
I have been getting following error.
[polaris] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
How to fix that?
What is default port for mysqlserver?
thx
-seena
-
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB f
I need to add to my previous post -- You asked about using the SAME
operating system socket as well as using separate addresses with the same
port number (different IP sockets)
My answer to that is NOT ON YOUR LIFE. Think of the chaos. If one client
tried to connect to an OS socket that 3 diffe
An "IP socket" is the unique combination of an IP address and a port
number. I don't see why you couldn't run those separate instances of your
db servers on the same port but each with their own addresses as they
would each have their own unique "IP socket". I don't think you would
create any c
Karam Chand said:
> I use SQLyog. It does allow you to create/delete FKs
> with "ON UPDATE" criterias.
>
> Yeah, it does not allow you to create Fks in graphical
> manner like MS SQL Server but does my purpose. One
> feature I really miss is Editing of FKs.
Yeah, I also tried SQLyog. It's a v
Dear MySQL,
I have need to pass an INFINITY value to a FLOAT, as defined in:
http://research.microsoft.com/~hollasch/cgindex/coding/ieeefloat.html
Can you please tell me if this is possible using SQL, and if so, how
this is done?
Kind regards,
Ben Clewett.
--
MySQL General Mailing List
For list a
46 matches
Mail list logo
