Dear All,
Thanks for the prompt replies. The version of MySQL we are using
(4.1.14-standard-log) supports INSERT ON DUPLICATE, hence I am using this.
Have a fantastic day!
Regards,
Ravi.
_
From: Douglas Sims [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 29 August, 2006 12:02 PM
To: Jo
Douglas Sims wrote:
Hi Ravi
You are correct. I was just sitting here thinking about this after I
sent that and realized that what I said was incorrect; the "REPLACE"
command will not do what you want, because it delete a record instead
of updating it, it has no way to know what the previ
Much better. Good job.
Douglas Sims
[EMAIL PROTECTED]
On Aug 29, 2006, at 1:26 AM, Johan Höök wrote:
Hi Ravi,
you can take a look at:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
which might take care of your problem.
/Johan
Douglas Sims skrev:
Hi Ravi
You are correct
Hi Ravi,
you can take a look at:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
which might take care of your problem.
/Johan
Douglas Sims skrev:
Hi Ravi
You are correct. I was just sitting here thinking about this after I
sent that and realized that what I said was incorrec
Hi Ravi
You are correct. I was just sitting here thinking about this after I
sent that and realized that what I said was incorrect; the "REPLACE"
command will not do what you want, because it delete a record instead
of updating it, it has no way to know what the previous value is.
You p
Hi Douglas,
Thanks for your prompt reply. I read through the description of REPLACE and
tested it as well. It seems just fine, but the idea that it would DELETE and
then insert if a match is found, seems like a warning to me.
I need to know this: can it happen that in between this delete and ins
Hi,
InnoDB provides MySQL with a transaction-safe (ACID compliant) storage engine
that has commit, rollback, and crash recovery capabilities. MyISAM, the default
storage engine. Unless compiled with InnoDB, MySQL is not ACID compliant.
When innodb_flush_log_at_trx_commit
=0 the log buffer is
The cluster engine has been available since the 4.0 tree, I believe. You can
begin using it immediately with 5.0 (which is GA).
David
Logan, David (SST - Adelaide) wrote:
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster
Hi Ravi
Standard SQL syntax doesn't provide for that. You could wrap the
whole thing in a transaction, possibly in a stored procedure, but
this would be rather awkward.
However, MySQL has a command called "REPLACE" which I think will do
exactly what you want:
http://dev.mysql.com/doc/r
Dear Members,
I wish to insert and update conditionally into a table using a single SQL
statement. That is if a record already exists in a table, the statement
should update it, else it should insert it. Probably something like this:
if (select * from UserPoints where username = 'ravi') then
(
hello all,
We do not run transactions at all on our db. All our queries are autocommit. So
what should be the value set to this variable : innodb_flush_log_at_trx_commit
We currently have it set to 1 and all our tables are Innodb. Since we are not
running any transactions at all, is it better t
What is this solidDB? where can i get much info on this??
Thanks,
Ratheesh Bhat K J
Thomas Trutt wrote:
> Hello all...
>
> And thanks ahead of time for the help...
>
> I'm having an issue with a locked table...
>
> I have about 27 tables in MySQL Db that i am working with with
> multiple MS Access front ends.. The problem is one of my tables is
> locked, but only the first 400 re
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster as I have several databases
(around 50) totalling 26Gb and would like to consider moving to this
version because of the Cluster Disk Data Storage and the fact the
current hardw
Hello all...
And thanks ahead of time for the help...
I'm having an issue with a locked table...
I have about 27 tables in MySQL Db that i am working with with multiple
MS Access front ends.. The problem is one of my tables is locked, but
only the first 400 records, the rest is fine... Any id
Spam detection software, running on the system "marmalade.snp.org", has
identified this incoming email as possible spam. The original message
has been attached to this so you can view it (if it isn't spam) or label
similar future email. If you have any questions, see
[EMAIL PROTECTED] for details
Greetings all,
I'm working with mysql-5.1.11-beta-linux-i686 set up using the NDB
cluster. I was wondering if there are any limitations or inefficiencies
if I was to use a connection pool to the mysql server(s) front-ending
the cluster? Several processes will make a request of our server and
the
Karel W. Dingeldey wrote:
Ok, I will do it more clearly. The server has two harddisks, one for the
system, one for the data. The system harddisk breaked, hardware failure. It
seems that this happed while mysqld was writing some data, so that some
tables are corrupted. Most tables are reconstruc
Hello All,
I am not a database person and I am just using mysql database to store some
factory parameters. I am running my code over a cluster and I am having the
problem of connection with the server. We have a 64 node cluster and all node
request connections to the mysql server. Sometimes
On Mon, 2006-08-28 at 13:47 +0200, Thomas Spahni wrote:
> On Sun, 27 Aug 2006, Jim Seymour wrote:
>
> > Hi,
> >
> > I download a csv file from Yahoo in this format:
> >
> > ABIAX
> >20.63
> >2006-08-3
> > ACEIX
> > 8.78
> >2
The only reason that I can think of is to balance the load among systems.
This might be because you want to split the load between the data base
server and the application, or because you want to run the application on
more than one server.
Regards,
Jerry Schwartz
Global Information Incorporated
I am a bit confused here!!!
We thought seperating our App server and DB server bcoz we spotted some
performance problems. There are queries taking about 40 seconds to fetch
about 300 odd rows ( dont kno if I can relate this to a fight b/w app and db
for cpu and/or mem).
We have a 4GB RAM. Wh
In addition to what the others told you, security would be a big reason. If the application server is compromised, whether through
your application code or some other service on the box, then they also have local access to the database files.
If you setup a database server, you can open just the
mysql> show status like 'com_update';
+---+---+
| Variable_name | Value |
+---+---+
| Com_update| 0 |
+---+---+
1 row in set (0.00 sec)
mysql> show status like 'com_insert';
+---+---+
| Variable_name | Value |
+--
Hello all,
I need to find out to some point of accuracy the ratio of Number
Inserts/Updates to that of Selects. This is because we are thinking of setting
up a Replication sysytem with one master and one slave. Now replication would
be optimal only if there if the Select queries are dominating,
On Sun, 27 Aug 2006, Jim Seymour wrote:
> Hi,
>
> I download a csv file from Yahoo in this format:
>
> ABIAX
>20.63
>2006-08-3
> ACEIX
> 8.78
>2006-08-3
> CIGAX
>10.08
>2006-08-3
> FSCTX
>
$query = "SELECT distinct gallery FROM thumbnails";
that only returns the numbers 7 & 8. I need the all the info from the rows -
id, binary data etcsomething like (although it doesn't work)
$query = "SELECT * FROM DISTINCT gallery FROM thumbnails";
any ideas?
- Original Message
I'll double-check it on another MySQL server I have here (uses same
version of MySQL) and will file a bug report if I indeed can replicate
the problem.
Thank you all for the swift replies! :-)
Regards,
Evert
Joerg Bruehe wrote:
> Hi Evert, all!
>
>
> Evert Meulie wrote (re-ordered):
>> Mic
Hi Evert, all!
Evert Meulie wrote (re-ordered):
Michael Stassen wrote:
Evert wrote:
Hi all!
Who can tell me why the following does not work...?
When I do:
SELECT COUNT(*) AS counter FROM table1 WHERE condition1 = 'A' AND
condition2 IS NULL;
it returns:
+-+
| counter |
+-+
|
29 matches
Mail list logo
