f



Select .. WHERE lang="nl" or lang="en"

Hi,

I have a table `cities`:
city_id
countrycode
languagecode
name
primary key (city_id, languagecode)

I want fetch all cities with countrycode=3D"fr" and languagecode=3D"nl",
If city_id in languagecode=3D"nl" not exists, I want fetch THIS city in
languagecode=3D"en"


EXAMPLE:
city_id  countrycode  languagecode  name:
1  fr  en  Paris
2 fr  en Bordeaux
1 fr  pl Pary=BF
2 fr  pl (null OR '')

countrycode=3D"fr" and languagecode=3D"pl":
2 fr  en Bordeaux
1 fr  pl Pary=BF


Any ideas?

0
dagers001 (1)
7/2/2007 1:54:19 PM
comp.databases.mysql 6944 articles. 1 followers. laredotornado (869) is leader. Post Follow

4 Replies
924 Views

Similar Articles

[PageSpeed] 27

dag wrote:
> Hi,
>
> I have a table `cities`:
> city_id
> countrycode
> languagecode
> name
> primary key (city_id, languagecode)
>
> I want fetch all cities with countrycode="fr" and languagecode="nl",
> If city_id in languagecode="nl" not exists, I want fetch THIS city in
> languagecode="en"
>
>
> EXAMPLE:
> city_id  countrycode  languagecode  name:
> 1  fr  en  Paris
> 2 fr  en Bordeaux
> 1 fr  pl Pary�
> 2 fr  pl (null OR '')
>
> countrycode="fr" and languagecode="pl":
> 2 fr  en Bordeaux
> 1 fr  pl Pary�
>
>
> Any ideas?

You said: 'If city_id in languagecode=... not exists, I want fetch THIS city 
in
languagecode="en"'

But in the example you have given, the city_id 2 with countrycode = "fr" and 
languagecode="pl" DOES exist, and yest you have said that the output should 
ignore it!


0
Paul
7/2/2007 2:05:32 PM
On 2 Lip, 16:05, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
> > EXAMPLE:
> > city_id  countrycode  languagecode  name:
> > 1  fr  en  Paris
> > 2 fr  en Bordeaux
> > 1 fr  pl Pary=BF
> > 2 fr  pl (null OR '')
>
> > countrycode=3D"fr" and languagecode=3D"pl":
> > 2 fr  en Bordeaux
> > 1 fr  pl Pary=BF
>
> > Any ideas?
>
> You said: 'If city_id in languagecode=3D... not exists, I want fetch THIS=
 city
> in
> languagecode=3D"en"'
>
> But in the example you have given, the city_id 2 with countrycode =3D "fr=
" and
> languagecode=3D"pl" DOES exist, and yest you have said that the output sh=
ould
> ignore it!

Yes, I want ignore rows with empty Name.

In other way, I can delete all rows which have name=3D=3D"", after I added
data to table.

1=2E
the city_id 2 with countrycode =3D "fr" and
languagecode=3D"pl" DOES exist with empty name (name=3D"")

2=2E
the city_id 2 with countrycode =3D "fr" and
languagecode=3D"pl" DOESN'T exist

I'm looking for tips.

0
dag
7/3/2007 8:19:03 PM
On 3 Jul, 21:19, dag <dagers...@gmail.com> wrote:
> On 2 Lip, 16:05, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
>
>
>
>
>
> > > EXAMPLE:
> > > city_id  countrycode  languagecode  name:
> > > 1  fr  en  Paris
> > > 2 fr  en Bordeaux
> > > 1 fr  pl Pary=BF
> > > 2 fr  pl (null OR '')
>
> > > countrycode=3D"fr" and languagecode=3D"pl":
> > > 2 fr  en Bordeaux
> > > 1 fr  pl Pary=BF
>
> > > Any ideas?
>
> > You said: 'If city_id in languagecode=3D... not exists, I want fetch TH=
IS city
> > in
> > languagecode=3D"en"'
>
> > But in the example you have given, the city_id 2 with countrycode =3D "=
fr" and
> > languagecode=3D"pl" DOES exist, and yest you have said that the output =
should
> > ignore it!
>
> Yes, I want ignore rows with empty Name.
>
> In other way, I can delete all rows which have name=3D=3D"", after I added
> data to table.
>
> 1.
> the city_id 2 with countrycode =3D "fr" and
> languagecode=3D"pl" DOES exist with empty name (name=3D"")
>
> 2.
> the city_id 2 with countrycode =3D "fr" and
> languagecode=3D"pl" DOESN'T exist
>
> I'm looking for tips.- Hide quoted text -
>
> - Show quoted text -

Just to get this straight.

In your first post you said:
'If city_id in languagecode=3D"nl" not exists, I want fetch THIS city in
languagecode=3D"en"'

But you are now saying this is wromg.

Instead you want
'If name is blank, I want to fetch this city in languagecode=3D"en"'

Or do you still want the first. It makes a difference as to what the
answer will be.

0
Captain
7/4/2007 10:19:35 AM
> Just to get this straight.
>
> In your first post you said:
> 'If city_id in languagecode="nl" not exists, I want fetch THIS city in
> languagecode="en"'
>
> But you are now saying this is wromg.
>
> Instead you want
> 'If name is blank, I want to fetch this city in languagecode="en"'
>
> Or do you still want the first. It makes a difference as to what the
> answer will be.

Hi

CASE #1
the city_id 2 with countrycode = "fr" and
languagecode="pl" *DOES exist* with empty name (name="")

if not solved case #1 (because I can delete all rows with name=""):
CASE #2.
the city_id 2 with countrycode = "fr" and
languagecode="pl" *DOESN'T exist*

So, I'm looking for tips for CASE #1, if this isn't to solve, for Case
#2.

0
dag
7/6/2007 7:19:28 AM
Reply:

Similar Artilces:

""""""""""""""""""""""ADD ME""""""""""""""""""""
Hi , Hope you are doing great. Please let me take this opportunity to introduce myself, Iam Karthik working with BhanInfo Inc, a NY based company. We have consultants on our bench on various technologies, my request is to add me to your distribution list and kindly do send me the requirements. i have the below list available 1. Mainframe 2. Java 3.. Financial Analyst 4. Data Architect If there is any vendor ship agreement which has to be signed then I would like to take an opportunity to represent my company and expect your cooperation... We look forward to build a ve...

"""""""""ADD ME""""""""""
Hi , Hope you are doing great. Please let me take this opportunity to introduce myself, Iam Karthik working with BhanInfoi Inc, a NY based company. We have consultants on our bench on various technologies, my request is to add me to your distribution list and kindly do send me the requirements. i have the below list available 1. Mainframe 2. Java 3.. Financial Analyst 4. Data Architect If there is any vendor ship agreement which has to be signed then I would like to take an opportunity to represent my company and expect your cooperation... ...

Urgent Requirement in """""""""""""NEW YORK""""""""""""""""
Hello Partners, Please find the requirement below. Please send the updated resume along with rate and contact no. REQ#1: Title : Java Developer ( Rating Project) Duration : 6 months Rate : open Location : NY strong java, WebLogic 9.2, Web Services, Oracle REQ#2: Title : Java Developer Duration : 4 months Rate : open Location : NY Strong java, SQL REQ#3: Title : VB.Net Consultant Location : NY Duration : 4 months Rate : open Primarily looking at someone who has Excel, VB.net a...

"out" and "in out"
Hi i found the following explaination: In Ada, "in" parameters are similar to C++ const parameters. They are effectively read-only within the scope of the called subprogram. Ada "in out" parameters have a reliable initial value (that passed in from the calling subprogram) and may be modified within the scope of the called procedure. Ada "out" parameters have no reliable initial value, but are expected to be assigned a value within the called procedure. What does "have no reliable initial value" mean when considering the "out" parameter? By c...

"If then; if then;" and "If then; if;"
I have a raw data set which is a hierarchical file: H 321 s. main st P Mary E 21 F P william m 23 M P Susan K 3 F H 324 S. Main St I use the folowing code to read the data to creat one observation per detail(P) record including hearder record(H): data test; infile 'C:\Documents and Settings\retain.txt'; retain Address; input type $1. @; if type='H' then input @3 Address $12.; if type='P' then input @3 Name $10. @13 Age 3. @16 Gender $1.; run; but the output is not what I want: 1 321 s. main H 2 321 s. main P Mary E 21 F 3 321 s...

"/a" is not "/a" ?
Hi everybody, while testing a module today I stumbled on something that I can work around but I don't quite understand. >>> a = "a" >>> b = "a" >>> a == b True >>> a is b True >>> c = "/a" >>> d = "/a" >>> c == d True # all good so far >>> c is d False # eeeeek! Why c and d point to two different objects with an identical string content rather than the same object? Manu Emanuele D'Arrigo wrote: >>>> c = "/a" >>>&...

why "::", not "."
Why does the method of modules use a dot, and the constants a double colon? e.g. Math::PI and Math.cos -- Posted via http://www.ruby-forum.com/. On Oct 26, 2010, at 01:48 , Oleg Igor wrote: > Why does the method of modules use a dot, and the constants a double > colon? > e.g. > Math::PI and Math.cos For the same reason why inner-classes/modules use double colon, because = they're constants and that's how you look up via constant namespace. Math::PI and ActiveRecord::Base are the same type of lookup... it is = just that Base is a module and PI is a float....

"my" and "our"
Hi, while testing a program, I erroneously declared the same variable twice within a block, the first time with "my", the second time with "our": { my $fz = 'VTX_Link'; .... ( around 200 lines of code, all in the same block) our $fz = 'VTX_Linkset'; ... } So the initial contents of the $fz declared with "my" is lost, because "our" creates a lexical alias for the global $fz, thus overwriting the previous "my" declaration. It was my error, no question. But I wonder why Perl doesn't mention this - even with "use s...

about "++" and "--"
why this program snippet display "8,7,7,8,-7,-8" the program is: main() { int i=8; printf("%d\n%d\n%d\n%d\n%d\n%d\n",++i,--i,i++,i--,-i++,-i--); } > why this program snippet display "8,7,7,8,-7,-8" Ask your compiler-vendor because this result is IMHO implementation-defined. Check this out: http://www.parashift.com/c++-faq-lite/misc-technical-issues.html#faq-39.15 http://www.parashift.com/c++-faq-lite/misc-technical-issues.html#faq-39.16 Regards, Irina Marudina fxc123@gmail.com wrote: > why this program snippet display "8,7,7,8,-7,-8&q...

"or" and "and"
Hi, I'm just getting to discover ruby, but I find it very nice programming language. I just still don't understand how the "or" and "and" in ruby... I was playing with ruby and for example made a def to print Stem and Leaf plot (for those who didn't have a statistics course or slept on it, e.g. http://cnx.org/content/m10157/latest/) Here is the Beta version of it: class Array def n ; self.size ; end def stem_and_leaf(st = 1) # if st != (2 or 5 or 10) then ; st = 1 ; end k = Hash.new(0) self.each {|x| k[x.to_f] += 1 } k = k.sort{|a, b| a[0].to_f <=&g...

Urgent Requirement for """""""""""""""INFORMATICA DEVELOPER"""""""""""""
Hello Partners, How are you ? Please find the requirements below. Title: Database/ETL Developer Duration: 6 months Location: NY Exp: 7+ Locals preferred Database/ETL requirements (Mandatory) Candidate must have worked with financial instruments, preferably Mutual Funds but, Equities are also ok. PL/SQL - packages, Stored procs, Functions, Aggregate functions, Pipelined Functions Informatica 8.6 - especially complex mappings, complex maplets, complex workflows, transformations Oracle 10g/11g Unix/Linux shell scripting ...

Urgent need """""""""""INFORMATICA DEVELOPER"""""""""""""
Hello Partners, How are you ? Please find the requirements below. Title: Database/ETL Developer Duration: 6 months Location: NY Exp: 7+ Locals preferred Database/ETL requirements (Mandatory) Candidate must have worked with financial instruments, preferably Mutual Funds but, Equities are also ok. PL/SQL - packages, Stored procs, Functions, Aggregate functions, Pipelined Functions Informatica 8.6 - especially complex mappings, complex maplets, complex workflows, transformations Oracle 10g/11g Unix/Linux shell scripting Database/ETL requirements (Optional) Data warehousing experience Threading and job concepts in 10g/11g Cost based Optimizer concepts in 10g/11g Must : Experience with XML files and partitioning concepts in Oracle, Collections, Material Views Note : No phone calls please. : send Resumes to karthik@bhaninfo.com Thanks & Regards Karthik BhanInfo karthik@bhaninfo.com ...

"In" "Out" and "Trash"
I just bought a new computer and I re-installed Eudora Light on my new computer. But when I open Eudora, the "In", "Out" and "Trash" links are not on the left side of the screen the way they were on my old computer. How can I get these links back on the left side of the screen? Thank you. On 25 Mar 2007 09:49:22 -0700, "abx" <abfunex@yahoo.com> wrote: >I just bought a new computer and I re-installed Eudora Light on my new >computer. But when I open Eudora, the "In", "Out" and "Trash" links >are ...

Does it need a ";" at the very after of "if" and "for"
write code like: int main(void) { int a=10; if(a<20) {} } Compiler ok on dev-cpp . don't we have to add a ";" after if statement? marsarden said: > write code like: > > int main(void) > { > int a=10; > if(a<20) > {} > } > > Compiler ok on dev-cpp . don't we have to add a ";" after if > statement? The syntax for 'if' is: if(expression) statement There is no semicolon after the ) but before the statement. The statement is either a normal statement (which can be empty), ending in a semicolon:- if(expr) ...

A problem about "[ ]" "( )" "="
I want to read several images saved in a director,and give them to I1,I2 ,I3....,using the following codes: filelist=dir(['c:\MATLAB701\work\...\*.jpg']); for i=1 :length(filelist) I=imread(fullfile('c:\MATLAB701\work\...',filelist(i).name)); end; but failed. Then I used I(i)=imread... ,still failed. How could I do? "John" <mailofww@126.com> wrote in message news:ef19e12.-1@webx.raydaftYaTP... >I want to read several images saved in a director,and give them to > I1,I2 ,I3....,using the following codes: > filelist=dir(['c:\MATLAB701\work\.....

Urgent JAVA Requirement in """"""NEW YORK"""""""""
Hello Partners, How are you ? Please find the requirement below. Location : NY Duration : 8 mnths Rate :Open Job description: Java/J2EE Web Service Developer =B7 (4+ years of application development experience in Java/J2EE and Web service technologies. =B7 Experience with spring & Hibernate. =B7 Experience with J2EE Application Server (preferably Web logic). =B7 Preferable Aqua logic DSP Experience =B7 Preferable Sonic ESB Composite Service experience Experience w...

puts "\\".gsub("\\", "\\\\")
Hello, I have a mini-ruby quiz. Guess what this line of code writes to the console, then try it for yourself: puts "\\".gsub("\\", "\\\\") Why is that so? Martin From: martinus [mailto:martin.ankerl@gmail.com]=20 # Hello, I have a mini-ruby quiz. Guess what this line of code writes to # the console, then try it for yourself: # puts "\\".gsub("\\", "\\\\") puts "\\".gsub("\\", "\\\\") \ #=3D> nil # Why is that so? faq. escaping the escape in sub/gsub. search the archives. maybe you want somethin...

Question about "sprintf" "@" "do for"
Hello, this works: A1=3D1 A2=3D2 A3=3D3 i=3D1 vari=3Dsprintf("A%.f",i) print vari,"=3D",@vari i=3Di+1 vari=3Dsprintf("A%.f",i) print vari,"=3D",@vari i=3Di+1 vari=3Dsprintf("A%.f",i) print vari,"=3D",@vari do for [i=3D1:3]{ vari=3Dsprintf("A%.f",i) print vari } But I want to have "print vari,"=3D",@vari" in the loop. But it dosen't=20 work. Why can't I use "print vari,"=3D",@vari" in the loop? Is there a=20 solution for? J=C3=B6rg Jörg ...

Gary Sokolich """"""
"""""""""" http://www.manta.com/c/mmlq5dm/w-gary-sokolich W Gary Sokolich 801 Kings Road Newport Beach, CA 92663-5715 (949) 650-5379 http://www.tbpe.state.tx.us/da/da022808.htm TEXAS BOARD OF PROFESSIONAL ENGINEERS February 28, 2008 Board Meeting Disciplinary Actions W. Gary Sokolich , Newport Beach, California �V File B-29812 - It was alleged that Dr. Sokolich unlawfully offered or attempted to practice engineering in Texas (...) Dr. Sokolich chose to end the proceedings by signing a Consent Order that was accepted by ...

"final" in "for"
What I also would like to see in a future Java version would be for( final int i = 0; i < n; ++i ) to be allowed, meaning that �i� can not be modified except for in the parentheses of the for statement. This does not invalidate any existing code, but would allow to express such an intention. Stefan Ram wrote: > What I also would like to see in a future Java version > would be > > for( final int i = 0; i < n; ++i ) > > to be allowed, meaning that �i� can not be modified > except for in the parentheses of the f...

"for" with "else"?
While trying to print a none empty list, I accidentaly put an "else" statement with a "for" instead of "if". Here is what I had: if ( len(mylist)> 0) : for x,y in mylist: print x,y else: print "Empty list" which was supposed to be: if ( len(mylist)> 0) : for x,y in mylist: print x,y else: print "Empty list" Is this to be expected? (python 2.2.2) ++++++++++++++++++++++++++++++= >>> for x in range(5): .... print x*x .... else: .... print "done" .... 0 1 4 9 16...

" | " and "~" on solaris
hi, someone know how configure the input keyboard. when i want "|" on the term i have "^\" when i want "~" i have "^^". someone can help me ? Thanks gege1234 wrote: > hi, > > someone know how configure the input keyboard. > when i want "|" on the term i have "^\" > when i want "~" i have "^^". > > someone can help me ? > > Thanks man xmodmap Hope this helps -- Axel i have try "loadkeys" and my keyboard became as before thanks ...

"A" is not equal "A"?
I was trying to convert String Array to String A through cycle and than compare the result with String B but eventhough results were the same it returned false. I'am working in BlueJ 3.1.0 Code is: public boolean Method () { String[] Example = {"a","b","c"}; String A = ""; String B = "abc" for (int i = 0; i<3 ; i++) { A = A + Example[i]; } if (A == B) { return true; } } never got true... I appreciate any suggestions how to solve this Den 08.04.2014 10:06, skrev 245dav@gmail.com:...

"for" inside "for"
dear community, there is no need to mention that i'm far from beeing a sh-professional. in a male file i am trying to do two things to all files in defined directories. < === snip =============================================== > @for FILE in $(TEMPLATES); do \ @for DIR_NAME in $(DIRS); do \ FILE_BASENAME=`basename $$FILE`; \ DIR_NAME=`dirname $$FILE`; \ mkdir -p $(DIRNAME); \ cat $$FILE \ | perl -pe "s%\@INSTALL_URL\@%$(INSTALL_URL)%g" \ > $(INSTALL_PATH)/$$FILE_BASENAME; \ done; done; < === snip ========================...

Web resources about - Select .. WHERE lang="nl" or lang="en" - comp.databases.mysql

Resources last updated: 2/22/2016 6:46:56 AM