Re: Why can't I delete these records?

Hi all! I got it to work! :-) And all I did was replacing IS NULL with = '-00-00 00:00:00' in the DELETE-statement... Does anyone have an explanation for this...? Regards, Evert Michael Stassen wrote: Evert wrote: Hi all! Who can tell me why the following does not work...? When

Message could not be delivered

The original message was received at Mon, 28 Aug 2006 09:00:17 +0200 from mysql.com [196.94.146.79] - The following addresses had permanent fatal errors - mysql@lists.mysql.com - Transcript of session follows - while talking to lists.mysql.com.: MAIL From:[EMAIL PROTECTED]

Re: ALTER TABLE

Hi, Try this: To modify an existing field: ALTER TABLE doc MODIFY docts timestamp DEFAULT CURRENT_TIMESTAMP; or To add new field ALTER TABLE doc ADD docts timestamp DEFAULT CURRENT_TIMESTAMP; Thanks, ViSolve DB Team. - Original Message - From: Peter Lauri [EMAIL PROTECTED] To:

Re: Why can't I delete these records?

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 | +-+

Re: Why can't I delete these records?

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): Michael

Re: displaying a sing thumbnail

$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 -

Re: mysqlimport csv file import problem

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

How to find the no of Inserts and selects

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

Re: How to find the no of Inserts and selects

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 |

Re: Seperating Application server and Database server

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

Re: Seperating Application server and Database server

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.

RE: Seperating Application server and Database server

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

Re: mysqlimport csv file import problem

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 2006-08-3 CIGAX

Sometime connnection request fails

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

Re: Server-Crash - What to do?

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

Connection Pooling with mysql-5.1.11-beta-linux-i686

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

**** Probably Spam (6.1) **** Slow performance - any suggestions?

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.

Locked Table Issue..

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

MySQL 5.1

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

Re: Locked Table Issue..

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 records,

Re: Anyone tried solidDB for MySQL?

What is this solidDB? where can i get much info on this?? Thanks, Ratheesh Bhat K J

what should be the value of innodb_flush_log_at_trx_commit

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

Conditional Insert

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

Re: Conditional Insert

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:

Re: MySQL 5.1

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

Re: what should be the value of innodb_flush_log_at_trx_commit

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