Re: DBA Mentor?

2011-05-05 Thread Jigal van Hemert
Hi, On 5-5-2011 0:52, Akachi Pictures wrote: perhaps u misinterpreted. didn't get angry. just moved on :) The reason why you get some surprised messages on the list is because we see the following: May 4th 19:06 - your first message about a mentor May 4th 19:57 - a reply by Claudio

Re: RV: independent tables

2011-05-05 Thread Hal�sz S�ndor
2011/05/04 16:57 +0200, Rocio Gomez Escribano I suppose my solution is an Join, but they have no intersection Really? Your examples are very much like a simple join, a special case of ... client OUTER JOIN user ON clientCodeDrivingLicense = userCodeDrivingLicense What is wrong with that?

RE: DBA Mentor?

2011-05-05 Thread Jerry Schwartz
Folks, I have no skin in this game whatsoever; but I thought the original question was reasonable (given that the person was new to the list), and I thought the first answer was rude. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796

RE: Join based upon LIKE

2011-05-05 Thread Jerry Schwartz
-Original Message- From: Nuno Tavares [mailto:nuno.tava...@dri.pt] Sent: Tuesday, May 03, 2011 6:21 PM To: mysql@lists.mysql.com Subject: Re: Join based upon LIKE Dear Jerry, I've been silently following this discussion because I've missed the original question. But from your last

Re: DBA Mentor?

2011-05-05 Thread Govinda
Folks, I have no skin in this game whatsoever same with me ^^^ . ...but I was just never sure what the OP meant by mentor. [...] take me under his or her wing [...] ...seemed to imply wanting to hire someone to soften/expedite the $free self-study process. When I really look into people's

Re: [PHP] mysql error

2011-05-05 Thread Daniel Brown
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote: Can smbd please look  at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log (  idlog int auto_increment not null,  imepriimek varchar(50),  clock

Re: [PHP] mysql error

2011-05-05 Thread Michael Dykman
CREATE TABLE log (  idlog int auto_increment not null,  imepriimek varchar(50),  clock timestamp,  action varchar(30),  onfile varchar(100), filesize float(6,2), uniqueid(idlog) ); -- here is your mistake the syntax for that should be 'unique key(idlog)' if you only wanted to specify a

Input needed...

2011-05-05 Thread J M
Hi, I have this stats: I have tuned some of it but I was wondering if someone can give inputs regarding it: * __ Key _ Buffer used54.63M of 384.00M %Used: 14.23 Current 123.21M%Usage: 32.09 Write hit

Re: Input needed...

2011-05-05 Thread Reindl Harald
please post your my.cnf settings becuase stats are useless without knowing the configuration and without knowing your hardware (memory!) nobody can say what buffers are making sense i would use mysqltuner.pl because it shows in the most cases good advises Am 05.05.2011 20:42, schrieb J M: Hi,