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
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 very
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
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
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
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
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 as specified
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
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 default
Anybody knows how to reference MySQL in a scientific paper?
Thanks
Bernd
- 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 the MySQL
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
--
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:
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,
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
manner like MS SQL
--
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 mysqldump?? If
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
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
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.
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
Actually mysqld parameter bind-address work great for different IP addresses on same
port for different servers on same machine. One can use -h hostname for clients
connection to a specific MySQL database server.
Thanks !
-Original Message-
From: Peter Lovatt [mailto:[EMAIL
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
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 delimit
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
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
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
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.
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
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. ``` vs.
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
- 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,
REVIEWCOMMENTS
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
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
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
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
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
On Fri, 10 Sep 2004 05:54:42 +1000, Matthew Boulter [EMAIL PROTECTED] wrote:
snip/
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
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
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
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.
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.
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
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 documentation,
- 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
pointers to
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
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
46 matches
Mail list logo