Re: Запрос

более отчетливо английски применения :-p - Original Message - > From: "Andre Polykanine" > To: "Виктор Ефимович" > Cc: mysql@lists.mysql.com > Sent: Thursday, 28 April, 2011 12:04:01 PM > Subject: Re: Запрос > > Hello Виктор, > > Из какого приложен

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

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 que

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

Re: Insert only if the entry doesn't exist

, 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: Rolando Edwards To: Andre Polykanine Date created: , 11:01:40 PM Subject: Insert only if the entr

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" escreveu na mensagem news:1621362474.20110214201...@oire.org... Hi all, Thanks for your fast answer to my

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 rat

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");