MySQL execute query only if a statement is verified -


i have query working well:

select     disciplina,     categoria,     if (max(`london 2012`) > 0, 'yes', 'no') 'london 2012',     if (max(`beijing 2008`) > 0, 'yes', 'no') 'beijing 2008',     if (max(`athens 2004`) > 0, 'yes', 'no') 'athens 2004',     if (max(`sydney 2000`) > 0, 'yes', 'no') 'sydney 2000',     if (max(`atlanta 1996`) > 0, 'yes', 'no') 'atlanta 1996',     if (max(`barcelona 1992`) > 0, 'yes', 'no') 'barcelona 1992',     if (max(`seoul 1988`) > 0, 'yes', 'no') 'seoul 1988',     if (max(`los angeles 1984`) > 0, 'yes', 'no') 'los angeles 1984',     if (max(`moscow 1980`) > 0, 'yes', 'no') 'moscow 1980',     if (max(`montreal 1976`) > 0, 'yes', 'no') 'montreal 1976',     if (max(`munich 1972`) > 0, 'yes', 'no') 'munich 1972',     if (max(`mexico 1968`) > 0, 'yes', 'no') 'mexico 1968',     if (max(`tokyo 1964`) > 0, 'yes', 'no') 'tokyo 1964',     if (max(`rome 1960`) > 0, 'yes', 'no') 'rome 1960',     if (max(`melbourne / stockholm 1956`) > 0, 'yes', 'no') 'melbourne / stockholm 1956',     if (max(`helsinki 1952`) > 0, 'yes', 'no') 'helsinki 1952',     if (max(`london 1948`) > 0, 'yes', 'no') 'london 1948',     if (max(`berlin 1936`) > 0, 'yes', 'no') 'berlin 1936',     if (max(`los angeles 1932`) > 0, 'yes', 'no') 'los angeles 1932',     if (max(`amsterdam 1928`) > 0, 'yes', 'no') 'amsterdam 1928',     if (max(`paris 1924`) > 0, 'yes', 'no') 'paris 1924',     if (max(`antwerp 1920`) > 0, 'yes', 'no') 'antwerp 1920',     if (max(`stockholm 1912`) > 0, 'yes', 'no') 'stockholm 1912',     if (max(`london 1908`) > 0, 'yes', 'no') 'london 1908',     if (max(`st louis 1904`) > 0, 'yes', 'no') 'st louis 1904',     if (max(`paris 1900`) > 0, 'yes', 'no') 'paris 1900',     if (max(`athens 1896`) > 0, 'yes', 'no') 'athens 1896'     (         select              disciplina,              categoria,              if (olimpiade = 'london 2012', 1, 0) 'london 2012',             if (olimpiade = 'beijing 2008', 1, 0) 'beijing 2008',             if (olimpiade = 'athens 2004', 1, 0) 'athens 2004',             if (olimpiade = 'sydney 2000', 1, 0) 'sydney 2000',             if (olimpiade = 'atlanta 1996', 1, 0) 'atlanta 1996',             if (olimpiade = 'barcelona 1992', 1, 0) 'barcelona 1992',             if (olimpiade = 'seoul 1988', 1, 0) 'seoul 1988',             if (olimpiade = 'los angeles 1984', 1, 0) 'los angeles 1984',             if (olimpiade = 'moscow 1980', 1, 0) 'moscow 1980',             if (olimpiade = 'montreal 1976', 1, 0) 'montreal 1976',             if (olimpiade = 'munich 1972', 1, 0) 'munich 1972',             if (olimpiade = 'mexico 1968', 1, 0) 'mexico 1968',             if (olimpiade = 'tokyo 1964', 1, 0) 'tokyo 1964',             if (olimpiade = 'rome 1960', 1, 0) 'rome 1960',             if (olimpiade = 'melbourne / stockholm 1956', 1, 0) 'melbourne / stockholm 1956',             if (olimpiade = 'helsinki 1952', 1, 0) 'helsinki 1952',             if (olimpiade = 'london 1948', 1, 0) 'london 1948',             if (olimpiade = 'berlin 1936', 1, 0) 'berlin 1936',             if (olimpiade = 'los angeles 1932', 1, 0) 'los angeles 1932',             if (olimpiade = 'amsterdam 1928', 1, 0) 'amsterdam 1928',             if (olimpiade = 'paris 1924', 1, 0) 'paris 1924',             if (olimpiade = 'antwerp 1920', 1, 0) 'antwerp 1920',             if (olimpiade = 'stockholm 1912', 1, 0) 'stockholm 1912',             if (olimpiade = 'london 1908', 1, 0) 'london 1908',             if (olimpiade = 'st louis 1904', 1, 0) 'st louis 1904',             if (olimpiade = 'paris 1900', 1, 0) 'paris 1900',             if (olimpiade = 'athens 1896', 1, 0) 'athens 1896'         summertotalmedals         sport='athletics'     ) games group disciplina, categoria order disciplina asc, categoria asc

i'd obtain single query, 2 types of queries.

1) first 1 obtain same information disciplina ='yes' @ london 2012

2) second 1 obtain same information disciplina = 'no' @ london 2012.

could this? tried myself poor results.

i'm not saying database design... ;)

why don't add filter in inner query this:

1) first 1 obtain same information disciplina ='yes' @ london 2012

select     disciplina,     categoria,     if (max(`london 2012`) > 0, 'yes', 'no') 'london 2012',     if (max(`beijing 2008`) > 0, 'yes', 'no') 'beijing 2008',     if (max(`athens 2004`) > 0, 'yes', 'no') 'athens 2004',     if (max(`sydney 2000`) > 0, 'yes', 'no') 'sydney 2000',     if (max(`atlanta 1996`) > 0, 'yes', 'no') 'atlanta 1996',     if (max(`barcelona 1992`) > 0, 'yes', 'no') 'barcelona 1992',     if (max(`seoul 1988`) > 0, 'yes', 'no') 'seoul 1988',     if (max(`los angeles 1984`) > 0, 'yes', 'no') 'los angeles 1984',     if (max(`moscow 1980`) > 0, 'yes', 'no') 'moscow 1980',     if (max(`montreal 1976`) > 0, 'yes', 'no') 'montreal 1976',     if (max(`munich 1972`) > 0, 'yes', 'no') 'munich 1972',     if (max(`mexico 1968`) > 0, 'yes', 'no') 'mexico 1968',     if (max(`tokyo 1964`) > 0, 'yes', 'no') 'tokyo 1964',     if (max(`rome 1960`) > 0, 'yes', 'no') 'rome 1960',     if (max(`melbourne / stockholm 1956`) > 0, 'yes', 'no') 'melbourne / stockholm 1956',     if (max(`helsinki 1952`) > 0, 'yes', 'no') 'helsinki 1952',     if (max(`london 1948`) > 0, 'yes', 'no') 'london 1948',     if (max(`berlin 1936`) > 0, 'yes', 'no') 'berlin 1936',     if (max(`los angeles 1932`) > 0, 'yes', 'no') 'los angeles 1932',     if (max(`amsterdam 1928`) > 0, 'yes', 'no') 'amsterdam 1928',     if (max(`paris 1924`) > 0, 'yes', 'no') 'paris 1924',     if (max(`antwerp 1920`) > 0, 'yes', 'no') 'antwerp 1920',     if (max(`stockholm 1912`) > 0, 'yes', 'no') 'stockholm 1912',     if (max(`london 1908`) > 0, 'yes', 'no') 'london 1908',     if (max(`st louis 1904`) > 0, 'yes', 'no') 'st louis 1904',     if (max(`paris 1900`) > 0, 'yes', 'no') 'paris 1900',     if (max(`athens 1896`) > 0, 'yes', 'no') 'athens 1896'     (         select              disciplina,              categoria,              if (olimpiade = 'london 2012', 1, 0) 'london 2012',             if (olimpiade = 'beijing 2008', 1, 0) 'beijing 2008',             if (olimpiade = 'athens 2004', 1, 0) 'athens 2004',             if (olimpiade = 'sydney 2000', 1, 0) 'sydney 2000',             if (olimpiade = 'atlanta 1996', 1, 0) 'atlanta 1996',             if (olimpiade = 'barcelona 1992', 1, 0) 'barcelona 1992',             if (olimpiade = 'seoul 1988', 1, 0) 'seoul 1988',             if (olimpiade = 'los angeles 1984', 1, 0) 'los angeles 1984',             if (olimpiade = 'moscow 1980', 1, 0) 'moscow 1980',             if (olimpiade = 'montreal 1976', 1, 0) 'montreal 1976',             if (olimpiade = 'munich 1972', 1, 0) 'munich 1972',             if (olimpiade = 'mexico 1968', 1, 0) 'mexico 1968',             if (olimpiade = 'tokyo 1964', 1, 0) 'tokyo 1964',             if (olimpiade = 'rome 1960', 1, 0) 'rome 1960',             if (olimpiade = 'melbourne / stockholm 1956', 1, 0) 'melbourne / stockholm 1956',             if (olimpiade = 'helsinki 1952', 1, 0) 'helsinki 1952',             if (olimpiade = 'london 1948', 1, 0) 'london 1948',             if (olimpiade = 'berlin 1936', 1, 0) 'berlin 1936',             if (olimpiade = 'los angeles 1932', 1, 0) 'los angeles 1932',             if (olimpiade = 'amsterdam 1928', 1, 0) 'amsterdam 1928',             if (olimpiade = 'paris 1924', 1, 0) 'paris 1924',             if (olimpiade = 'antwerp 1920', 1, 0) 'antwerp 1920',             if (olimpiade = 'stockholm 1912', 1, 0) 'stockholm 1912',             if (olimpiade = 'london 1908', 1, 0) 'london 1908',             if (olimpiade = 'st louis 1904', 1, 0) 'st louis 1904',             if (olimpiade = 'paris 1900', 1, 0) 'paris 1900',             if (olimpiade = 'athens 1896', 1, 0) 'athens 1896'         summertotalmedals         sport='athletics'         , olimpiade = 'london 2012' , disciplina='yes'     ) games group disciplina, categoria order disciplina asc, categoria asc

the second, need change disciplina='no'. you're expecting of didn't understand question?


Comments

Post a Comment

Popular posts from this blog

javascript - jQuery: Add class depending on URL in the best way -

i have html progress meter: <div class="col-md-3" style="margin-left: -20px;"> <div class="progress-pos active" id="progess-1"> <div class="progress-pos-inner"> login </div> </div> </div> <div class="col-md-3 progress-pos-container"> <div class="progress-pos" id="progess-2"> <div class="progress-pos-inner"> scan items </div> </div> </div> <div class="col-md-3 progress-pos-container"> <div class="progress-pos" id="progess-3"> <div class="progress-pos-inner"> confirm address </div> </div> </div> <div class="col-md-3 progress-pos-container"> <div class="progress-pos" id="progess-4"> <div class="progress-pos-in...
Read more

caching - How to check if a url path exists in the service worker cache -

i need check if particular url path exists in service worker cache. example, suppose url is: /myserviceworker/service?a=110&b=70 this url exists in cache, there many of them different values of , b. now, suppose want refresh of these urls, how can that? i want know how access key values service worker cache. if know key, plan follows: var url = new url(key); if(url.pathname === "\/myserviceworker/service") refetch key but not sure how cache key , in format is. mean, string or url? cache api has match() method returns promise resolving in response object if match or undefined if no match exists. second parameter object can specify ignoresearch not take account url parameters. the ignoresearch option supported firefox ( chrome status here ). in other hand, retrieve cache entries, can use keys() method.
Read more

Redirect to a HTTPS version using .htaccess -

i need modify .htaccess file redirect urls https version without "www". http://example.com --> https://example.com http://www.example.com --> https://example.com https://www.example.com --> https://example.com this how .htaccess file looks like: rewriteengine on rewritecond %{request_filename} !-d rewritecond %{request_filename} !-f rewriterule ^(.*)$ redirect.php?id=$1&page=$2 [qsa,l] what modifications need make .htaccess in order forward https without "www"? it depends on doing current code. looks file called redirect trying display php page seo friendly url. think might confusing people. anyway, need , force https without www, need 1 more rule above. also second rule needs two capture groups in rewriterule test string because wanting 2 different values using $1 , $2 references. rewriteengine on #rediect www non www and/or http https --- combinations. rewritecond %{http_host} !^example\.com [nc,or] rewritecond %{https} !^...
Read more