Re: Запрос

Hello Виктор, Из какого приложения?) -- With best regards from Ukraine, Andre Skype: Francophile My blog: http://oire.org/menelion (mostly in Russian) Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Виктор Ефимович

Re: Запрос

английски применения :-p - Original Message - From: Andre Polykanine an...@oire.org To: Виктор Ефимович mr.victor-tutun...@yandex.ru Cc: mysql@lists.mysql.com Sent: Thursday, 28 April, 2011 12:04:01 PM Subject: Re: Запрос Hello Виктор, Из какого приложения?) -- Bier met

Re: LEFT JOIN and WHERE: identical or not and what is better?, etc.

://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Halбsz Sбndor h...@tbbs.net To: Andre Polykanine Date created: , 7:00:03 AM Subject: LEFT JOIN and WHERE: identical or not and what is better?, etc. 2011/04/25 17:42 +0300, Andre

LEFT JOIN and WHERE: identical or not and what is better?

Hello everyone, Sorry for my beginner question. Actually I have been using MySql for a long time but I just start using some advanced things (earlier I accomplished those tasks with PHP), so I will be asking stupid questions, please bear with me. Here is the first one. We have two

Changing the timezone

Hi everyone, since I'm using the shared hosting, I can't change the default timezone for MySql. Question is: is there any query that I could launch in my connect.php before other queries to make my timezone change? For instance, I make a mysql_query(SET CHARACTER_SET_DATABASE='utf8') or

Insert only if the entry doesn't exist

Hi all, Thanks for your fast answer to my last question! Here's one more problem I commonly deal with. There are cases when I need to insert the row only if such a row doesn't exist, otherwise I need either to update the row or to do nothing, just skip the query. The common case is the

Re: Insert only if the entry doesn't exist

Subject: Re: Insert only if the entry doesn't exist Instead of insert into you can use replace into. -- João Cândido de Souza Neto Andre Polykanine an...@oire.org escreveu na mensagem news:1621362474.20110214201...@oire.org... Hi all, Thanks for your fast answer to my last question! Here's one more

Re: Insert only if the entry doesn't exist

/menelion (mostly in Russian) Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Rolando Edwards redwa...@logicworks.net To: Andre Polykanine Date created: , 11:01:40 PM Subject: Insert only if the entry doesn't exist

Simplify 4 queries into 1

Hi all, Hope this question is appropriate here :-). I've got 4 queries: $q1=mysql_query(SELECT *FROM`CandidateQuestions`WHERE `Category`='1' ORDER BY RAND() LIMIT 1); $q2=mysql_query(SELECT *FROM`CandidateQuestions`WHERE `Category`='2' ORDER BY RAND() LIMIT 1);