-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Hello:
I have recently posted the message attached at the bottom of
this one to the mailing list. Since then, I have continued to
work the sporadic and troublesome errors that are described in
that attached message
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ian Gibbons wrote:
On 27 Sep 2004 at 11:36, Rhino wrote:
snip
I really have no idea how Java is getting the information. I haven't tried
very many of the metadata methods yet so I don't know how much Java can
actually see and what is hidden. But
I didnt seeing it making it to the list, so please allow me to resend it.
(B
(B
(B
(B
(B Hi Mark,
(B
(B I have the parts for 4 Opteron systems here (Dual CPU machines)
(B
(B All Types 844 to 848 luying right in front of me.
(B 2x Sata HDD
(B 2x SCSI HDD
This is the first one I tried, it works great, thanks
- Original Message -
From: Gordon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; 'Diana Castillo' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 8:05 PM
Subject: RE: weird kind of join
You might also try
FROM
In article [EMAIL PROTECTED],
Kevin Cowley [EMAIL PROTECTED] writes:
If I knew why I wouldn't be asking. Now by our reconing the key of the
fields is 343 bytes, encoding in UTF8 makes that key 343 bytes Not 1000
since under utf8 each character is encode in 8 bits.
What makes you think so?
In article [EMAIL PROTECTED],
Aleksandr V. Dyomin [EMAIL PROTECTED] writes:
$key='somekeyvalue';
dbquery(update sometable set count=count+1 where keyfield='$key');
if(mysql_affected_rows()1)
dbquery('insert into sometable set keyfield='$key', count=1');
---
First question: this is
-Original Message-
From: Harald Fuchs [mailto:[EMAIL PROTECTED]
Sent: 30 September 2004 12:16
To: [EMAIL PROTECTED]
Subject: Re: Indexing problem with UTF8 in 4.1.4?
In article
[EMAIL PROTECTED],
Kevin Cowley [EMAIL PROTECTED] writes:
If I knew why I wouldn't be asking. Now
Perhaps someone can provide me with some of his or her experiences if
looking at MySQL to implement a secure from structure manipulation in a
commercial application using MySQL.
I am currently evaluating the possible migration of my app to MySQL as the
basis. I already have tested the
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
Thanks, it is working for the mentioned format.
Is there any method for importing directly the spooled file from oracle without
changing the file format into the required format like using tab and newline.
I don't know Oracle, but
Hi,
To solve this you can use the REPLACE command.
Regards,
Laercio.
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Harald Fuchs
Sent: quinta-feira, 30 de setembro de 2004 08:25
To: [EMAIL PROTECTED]
Subject: Re: (if !update then insert) sequence - result
All,
a number of error situations point to some kind of problem that I have not
been able to get to the bottom of so far, and cannot access some tables
after upgrading to 4.1.5-gamma.
First I got 'Could not fetch Schema Tables, MySQL Error Number 0' in MySQL
Query Browser when trying to open
Hi All,
This is more of a general SQL database question than a MySQL question, but
since I use MySQL almost exclusively I thought I would ask here.
Up until now, when designing a database, I always plotted out the
relationships on paper, with pen/pencil. I've filled large pieces of paper
with
Hi Joshua,
Hi All,
This is more of a general SQL database question than a MySQL question, but
since I use MySQL almost exclusively I thought I would ask here.
Up until now, when designing a database, I always plotted out the
relationships on paper, with pen/pencil. I've filled large
Hi people!
Since I've upgraded from MySQL 4.1.0 to MySQL 4.1.5 my system keeps
crashing.
The only messages I see on the screen are:
Out of Memory: Killed process 18440 (mysqld).
Out of Memory: Killed process 18441 (mysqld).
Out of Memory: Killed process 18442 (mysqld).
Out of Memory: Killed
As I mentioned in my post, I did wind up using a perl script, and I will
continue down that path in the future. I was mainly wondering about limits
to the mysql client for quick-n-dirty testing (as someone who is learning
MySQL, as opposed to developing for a production environment).
Thanks
I'd like to suggest the attached patch fixing a manpage formatting bug.
regards
Peter Breitenlohner [EMAIL PROTECTED]diff -ur mysql-4.0.21.orig/man/mysqlaccess.1.in mysql-4.0.21/man/mysqlaccess.1.in
--- mysql-4.0.21.orig/man/mysqlaccess.1.in 2004-09-07 00:29:40.0 +0200
+++
[snip]
SELECT COUNT(DISTINCT( `cycle_flag`)) as numCycles FROM
`crmReserve01`.`tblCDR` WHERE `cycle_flag` LIKE '___20__C_'
[/snip]
Query kept running and although stated as 'Killed' in processlist was
hung up and using resources like a hawg...
1. MySQL had to be restarted
2. Repaired the table
In article [EMAIL PROTECTED],
Laercio Xisto Braga Cavalcanti [EMAIL PROTECTED] writes:
Hi,
To solve this you can use the REPLACE command.
The problem is that Aleksandr wants to increment a counter, not set it
to some fixed value. How could you use REPLACE for that?
--
MySQL General Mailing
On 27.09.2004 07:08 (+0200), Donny Simonton wrote:
Look for OLD_PASSWORD in the manual. Basically create a new user and then
change the password with the OLD_PASSWORD function and then pre-4.1 clients
can connect without any problems. We use it all of the time.
Why is that not documented, again?
After some more study it turns out that my real problem seems to be that
ALTER TABLE does not work:
mysql alter table Foo type=myisam;
ERROR 1017 (HY000): Can't find file: 'Foo.MYI' (errno: 2)
The question remains, how do I get 4.1.5-gamma to recognize my ISAM tables?
Cheers,
Caro
Is there a variable or function in MySQL which resolves to the connecting
client's IP address? I have SQL clients which will be connecting through a NAT
firewall. I want to keep a record of IP of the client that connected to it. It
would look something like this:
UPDATE clients SET
Hi All,
I've been taking a look at DB Designer 4, and looking through the
documentation (http://www.fabforce.net/dbdesigner4/doc/index.html) I am a
little unclear on some of their nomenclature:
'1:1' - Ok, one to one. Got it.
'1:1' generalization - Don't know this. Obviously different
Hi All,
I'm confused by seemingly conflicting information between the mysql doc,
the high performance mysql book, and a mysql press release
(http://www.mysql.com/news-and-events/press-release/release_2003_05.html) regarding
mysql's SSL support. What's the difference between mysql 4.0's SSL
Use this variable:
$REMOTE_ADDR.
Such that:
$client_IP = $REMOTE_ADDR;
UPDATE clients SET ipaddr= $client_IP WHERE [EMAIL PROTECTED];
I hope this is useful for your code.
Mazhar Bilen
- Original Message -
From: Laszlo Thoth [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September
I am trying to come up with a query that shows duplicate last names and the
order numbers for each occurance of.
I can get as far as determining the duplicates but my query result only
outputs one order for each.
Here is my current query, an example of the results and an example of the
results I
Please post the structure of your orders table. (SHOW CREATE TABLE
orders). I need to know what you are using as a primary key in order to
help you to uniquely identify each duplicated row.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Paul Fine [EMAIL PROTECTED] wrote
Quoting Mazhar Bilen [EMAIL PROTECTED]:
Use this variable:
$REMOTE_ADDR.
Such that:
$client_IP = $REMOTE_ADDR;
UPDATE clients SET ipaddr= $client_IP WHERE [EMAIL PROTECTED];
This doesn't appear to work: I don't think the MySQL server recognizes
$REMOTE_ADDR as anything meaningful.
You might look at the USER() and CURRENT_USER() functions.
http://dev.mysql.com/doc/mysql/en/Information_functions.html
However, I think those will end up showing you the NAT server's address
and not the user's un-NATed address. If it were simple to de-NAT an
address, most firewalls would
Hi,
How to implement views/cursors in mysql 4.0?. Normally in mysql how the
selected data is maintained in the recordsets?. Is there any other alternatives to
implement views/cursors in mysql 4.0?. Please advise me for the better solution.
Thanks,
Narasimha
Confidentiality Notice
I want to know what to best way to keep a 4 mysql servers sync.
I have 4 remote locations, I am thinking about putting a mysql server
in each location and every hour have the 1 db that I need to sync to
sync together.
Is there away to do its in somewhat real time or even a delay maybe of
an
If you are using 4.1, you can look into the GROUP_CONCAT function.
Otherwise, try a self join like this:
SELECT A.LastName,A.OrderNum,B.OrderNum
FROM Orders AS A
LEFT JOIN Orders AS B ON A.LastName=B.LastName
WHERE A.OrderNum!=B.OrderNum
ORDER BY A.LastName
That joins the Order table with itself
Views and Cursors are not available in MySQL 4.x. Usually your scripting
language handles cursors for you (having them in 4.x would do you little
good as stored procedures don't exist yet. Look at the current 5.x
development for cursors and stored procedures). What language do you
I went to do some work on our database last night (dropping large
indexes, which can be time consuming). I checked to ensure that the
backup of that evening had run, but noticed that the size of the backup
was too small compared to previous days (I'm kicking myself for not
emailing the results
Hi,
Thank you for your response. Strictly we have to use mysql 4.0 only. Actually
the source data base is oracle 7.3, we need to migrate that database to mysql 4.0 . In
oracle 7.3 views/cursors are used. That is why i need an alternative for views/cursors
in mysql 4.0. We use C/C++ for
Views - instead of running queries against views, you will have to run
your queries against the underlying tables. This may mean lots of changes
to your SQL statements. What once appeared as a single query may now have
to be performed in multiple steps to achieve the same results. Usually,
Hi,
Thank you very much for your reply.
The existed system , a network management tool , is developed using C as
program lanuage and oracle 7.3 as the database. There are 3 layers in the database
like table layer, view layer and DBview layer. The DBView layer communicates
Could you please let me know the alternatives for stored procedures and
Triggers in mysql 4.0.
The only alternative is application code.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
My comments embedded below
[EMAIL PROTECTED] wrote on 09/30/2004 04:18:02 PM:
Hi,
Thank you very much for your reply.
The existed system , a network management tool , is developed
using C as program lanuage and oracle 7.3 as the database. There are
3 layers in the
Quoting [EMAIL PROTECTED]:
You might look at the USER() and CURRENT_USER() functions.
http://dev.mysql.com/doc/mysql/en/Information_functions.html
Aha! I think this is what I was looking for: the client host from which [I]
connected. I'll have to do some in-query string processing to
Hi,
Thank you very much for your reply. So for the cursors result set C API's will be
suitable ..right?.
thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of
Brent Baisley wrote:
If you are using 4.1, you can look into the GROUP_CONCAT function.
Otherwise, try a self join like this:
SELECT A.LastName,A.OrderNum,B.OrderNum
FROM Orders AS A
LEFT JOIN Orders AS B ON A.LastName=B.LastName
WHERE A.OrderNum!=B.OrderNum
ORDER BY A.LastName
That joins the
Does anybody know of any free tools to compare two mysql schemas? Thanks.
Hello:
While reading Red Hat / Apache 2 + SSL /PHP /mySQL
http://www.suteki.nu/howto.html, I came across the following configure state
(Page 3 Section 2):
./configure --with-openssl --with-isam --prefix=/usr/local/mysql
As you all know this configures the mySQL. My question is; what does
43 matches
Mail list logo