Home » Open Source » MySQL » how to retrive all COUNTRY from a table (MYSQL Workbench 6.3)
how to retrive all COUNTRY from a table [message #666709] Tue, 21 November 2017 03:19 Go to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
/forum/fa/13699/0/Hi All,

Am working on purchasing application. Here we are search the supplier with filter and without filter. Please check screen shot.

when am not filter anything, it will give all COUNTRY---- it's fine
client search with a particular COUNTRY that time it will show that particular country but client want all the country with that particular country.

S1:- Search Without filter
S2:- Result of S1 Search
S3:- Search With filter
S4:- Result of S3 Search

this is the SQL.
select sup.FO_DUNS_ID DUNS_ID,
sup.SUPPLIER_NAME SUP_NAME, GROUP_CONCAT(DISTINCT entCntry.COUNTRY_FK) COUNTRY from SUPPLIER sup
LEFT OUTER JOIN TURNOVER trn ON sup.PROCUBE_SEQ_ID = trn.SUPPLIER_FK
LEFT OUTER JOIN TMP_ENTITY_COUNTRY entCntry ON entCntry.ENTITY_FK = trn.LEGAL_ENTITY_ID
where sup.PROCUBE_SEQ_ID = '006173082';

output:
DUNS_ID
'001007830',
SUP_NAME
'DRAPER BROTHERS COMPANY',
COUNTRY
'US,AR,BE,CZ,FR,GB,BR,MX,TR,CN,SE,DE,NL,DK,IT,IN,PL,ES,CA,NO,FI,AU,JP,CH,AT,IE,PT,RO,AE,QA,EE,ZA,HU,KR,EG,CO,LU,SG,MY,ID,TH,TW,NZ,MA, SK,LV,OM,VN,LT,KW,LB,RU,SA,JO,VE,RS,CL,HK,GR,UA,BT'


My question is that what changes should i make in SQL so i'll get all the country with that particular country.
Am not able to upload screenshot it's showing file size more that 1024kb but my screen shot size is less than 1024kb


Thanks,
Amit
Re: how to retrive all COUNTRY from a table [message #666710 is a reply to message #666709] Tue, 21 November 2017 03:25 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
S1
  • Attachment: s1.png
    (Size: 30.91KB, Downloaded 3333 times)
Re: how to retrive all COUNTRY from a table [message #666711 is a reply to message #666710] Tue, 21 November 2017 03:26 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
PFA.
  • Attachment: s2.PNG
    (Size: 43.26KB, Downloaded 3262 times)
Re: how to retrive all COUNTRY from a table [message #666712 is a reply to message #666711] Tue, 21 November 2017 03:26 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
PFA
  • Attachment: s3.PNG
    (Size: 40.05KB, Downloaded 3445 times)
Re: how to retrive all COUNTRY from a table [message #666713 is a reply to message #666712] Tue, 21 November 2017 03:27 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
PFA
  • Attachment: s4.PNG
    (Size: 13.39KB, Downloaded 2672 times)
Re: how to retrive all COUNTRY from a table [message #666714 is a reply to message #666713] Tue, 21 November 2017 03:28 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
PFA
  • Attachment: s5.png
    (Size: 29.79KB, Downloaded 2849 times)
Re: how to retrive all COUNTRY from a table [message #666717 is a reply to message #666714] Tue, 21 November 2017 03:33 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Surely there's only ever one country with a particular country?
Re: how to retrive all COUNTRY from a table [message #666718 is a reply to message #666709] Tue, 21 November 2017 03:37 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I can't understand what you are trying to do. Please can you run the query, with and without the filter,
in SQL*Plus and copy/paste the whole SQL*Plus session here: queries plus results. Do be sure to enclose
everything in [code] tags, as described here
How to use [code] tags and make your code easier to read
Re: how to retrive all COUNTRY from a table [message #666719 is a reply to message #666718] Tue, 21 November 2017 04:09 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
Am sorry... i don't know how to connect Db through sql plus. Please check complete SQl with and without filter.

With filter SQL
SELECT DISTINCT
    (DUNS_ID),
    SUP_NAME,
    COUNTRY,
    SIGNED,
    CHARTVERSION,
    CHARTER_VERSION_ID,
    SIGN_DATE,
    SEND_DATE,
    RELAUNCH_DATE,
    ACTIVITY,
    ISGRPHEADER,
    SUPPLIER_ID,MYSTATUS2
    HASATIVECONTACT,
    AMOUNT,
    SUPADDR,
    WCA_RATING,
    GLOBAL_RATING,
    CSRAVERAGE,
    IS_TO_SEND,
    STATUS,
    SUBSIDIARIES,
    IRRELEVANT,
    APPROVE,
    CSR_ASSESSMENT_SENT
FROM
    ((SELECT 
        sup.FO_DUNS_ID DUNS_ID,
            sup.SUPPLIER_NAME SUP_NAME,
            GROUP_CONCAT(DISTINCT entCntry.COUNTRY_FK) COUNTRY,
            sign.SIGNED SIGNED,
            charVersion.CHARTER_VERSION CHARTVERSION,
            charVersion.CHARTER_VERSION_ID CHARTER_VERSION_ID,
            sign.SIGNATURE_DATE SIGN_DATE,
            sign.SEND_DATE SEND_DATE,
            sign.RELAUNCH_DATE RELAUNCH_DATE,
            GROUP_CONCAT(DISTINCT ssc.SUBCATEGORY_FK) ACTIVITY,
            wca.WCA_RATING AS WCA_RATING,
            csrInt.GLOBAL_RATING AS GLOBAL_RATING,
            ecovadis.GLOBAL_RATING AS CSRAVERAGE,
            sup.ISGRPHEADER AS ISGRPHEADER,
            sup.PROCUBE_SEQ_ID AS SUPPLIER_ID,
            (SELECT 
                    MIN(CONTACT_ID)
                FROM
                    CONTACT
                WHERE
                    SUPPLIER_FK = sup.PROCUBE_SEQ_ID
                        AND ACTIVE = 1) AS HASATIVECONTACT,
            sup.AMOUNT,
            sup.ADDRESS SUPADDR,
            sign.IS_TO_SEND IS_TO_SEND,
            st.STATUS STATUS,
            si.IRRELEVANT IRRELEVANT,
            pv.APPROVE APPROVE,
            ca.ASSESSMENT_ID AS CSR_ASSESSMENT_SENT
    FROM
        SUPPLIER sup
    LEFT OUTER JOIN SIGNATURE sign ON sup.PROCUBE_SEQ_ID = sign.SUPPLIER_FK
        AND sign.SIGNATURE_ID = (SELECT 
            MAX(SIGNATURE_ID)
        FROM
            SIGNATURE
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CHARTER_VERSION charVersion ON sign.CHARTER_VERSION_FK = charVersion.CHARTER_VERSION_ID
        AND charVersion.CHARTER_VERSION_ID = (SELECT 
            MAX(CHARTER_VERSION_ID)
        FROM
            CHARTER_VERSION
        WHERE
            ACTIVE = 1)
    LEFT OUTER JOIN SUPPLIER_QUESTIONNAIRE suppquest ON sup.PROCUBE_SEQ_ID = suppquest.SUPPLIER_FK
    LEFT OUTER JOIN ECOVADIS_RATING ecovadis ON sup.PROCUBE_SEQ_ID = ecovadis.SUPPLIER_FK
        AND ecovadis.ECOVADIS_ID = (SELECT 
            MAX(ECOVADIS_ID)
        FROM
            ECOVADIS_RATING
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN WCA_RATING wca ON sup.PROCUBE_SEQ_ID = wca.SUPPLIER_FK
        AND wca.WCA_ID = (SELECT 
            MAX(WCA_ID)
        FROM
            WCA_RATING
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CSR_INTERNAL_AUDIT csrInt ON sup.PROCUBE_SEQ_ID = csrInt.SUPPLIER_FK
        AND csrInt.CSR_ID = (SELECT 
            MAX(CSR_ID)
        FROM
            CSR_INTERNAL_AUDIT
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CSR_ASSESSMENT ca ON sup.PROCUBE_SEQ_ID = ca.SUPPLIER_FK
        AND ca.ASSESSMENT_ID = (SELECT 
            MAX(ASSESSMENT_ID)
        FROM
            CSR_ASSESSMENT
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CAP_STATUS cap ON sup.PROCUBE_SEQ_ID = cap.SUPPLIER_FK
    LEFT OUTER JOIN SUPPLIER_SUBCATEGORIES ssc ON sup.PROCUBE_SEQ_ID = ssc.SUPPLIER_FK
    LEFT OUTER JOIN TURNOVER trn ON sup.PROCUBE_SEQ_ID = trn.SUPPLIER_FK
    LEFT OUTER JOIN TMP_ENTITY_COUNTRY entCntry ON entCntry.ENTITY_FK = trn.LEGAL_ENTITY_ID
    LEFT OUTER JOIN SUPP_STATUS st ON st.SUPPLIER_ID = sup.PROCUBE_SEQ_ID
    LEFT OUTER JOIN SUPP_IRRELEVANT si ON si.SUPPLIER_ID = sup.PROCUBE_SEQ_ID
    LEFT OUTER JOIN PURCHASER_VALIDATION pv ON pv.SUPPLIER_FK = sup.PROCUBE_SEQ_ID
        AND pv.APPROVE = - 1
    WHERE
        sup.AMOUNT > 0.0
            AND (si.IRRELEVANT <> 1
            OR si.IRRELEVANT IS NULL)
    GROUP BY sup.PROCUBE_SEQ_ID
    HAVING COUNTRY IN ('PT')
    LIMIT 500) QR1
    LEFT OUTER JOIN (SELECT 
        st.SUPPLIER_ID AS SUPPLIER_ID1,
            GROUP_CONCAT(TRIM(su.SUPPLIER_NAME), ' - ', IF(sg.SIGNATURE_DATE IS NOT NULL, 'SIGNED', 'NOT SIGNED'), ',') SUBSIDIARIES
    FROM
        SUPP_STATUS st
    INNER JOIN SUPPLIER_HIERARCHY sh ON st.SUPPLIER_ID = sh.GROUP_HEADER_ID
        AND sh.GROUP_HEADER_ID != sh.PROCUBE_SEQ_ID
    LEFT OUTER JOIN SUPPLIER su ON su.PROCUBE_SEQ_ID = sh.PROCUBE_SEQ_ID
    INNER JOIN SIGNATURE sg ON sg.SUPPLIER_FK = sh.PROCUBE_SEQ_ID
    WHERE
        st.STATUS = 'VS'
            AND sg.SIGNATURE_DATE IS NOT NULL
    GROUP BY SUPPLIER_ID1) QR2 ON QR1.SUPPLIER_ID = QR2.SUPPLIER_ID1)
ORDER BY ISGRPHEADER , SUP_NAME , AMOUNT , CHARTER_VERSION_ID DESC;

without filter :--
SELECT DISTINCT
    (DUNS_ID),
    SUP_NAME,
    COUNTRY,
    SIGNED,
    CHARTVERSION,
    CHARTER_VERSION_ID,
    SIGN_DATE,
    SEND_DATE,
    RELAUNCH_DATE,
    ACTIVITY,
    ISGRPHEADER,
    SUPPLIER_ID,
    HASATIVECONTACT,
    AMOUNT,
    SUPADDR,
    WCA_RATING,
    GLOBAL_RATING,
    CSRAVERAGE,
    IS_TO_SEND,
    STATUS,
    SUBSIDIARIES,
    IRRELEVANT,
    APPROVE,
    CSR_ASSESSMENT_SENT
FROM
    ((SELECT 
        sup.FO_DUNS_ID DUNS_ID,
            sup.SUPPLIER_NAME SUP_NAME,
            GROUP_CONCAT(DISTINCT entCntry.COUNTRY_FK) COUNTRY,
            sign.SIGNED SIGNED,
            charVersion.CHARTER_VERSION CHARTVERSION,
            charVersion.CHARTER_VERSION_ID CHARTER_VERSION_ID,
            sign.SIGNATURE_DATE SIGN_DATE,
            sign.SEND_DATE SEND_DATE,
            sign.RELAUNCH_DATE RELAUNCH_DATE,
            GROUP_CONCAT(DISTINCT ssc.SUBCATEGORY_FK) ACTIVITY,
            wca.WCA_RATING AS WCA_RATING,
            csrInt.GLOBAL_RATING AS GLOBAL_RATING,
            ecovadis.GLOBAL_RATING AS CSRAVERAGE,
            sup.ISGRPHEADER AS ISGRPHEADER,
            sup.PROCUBE_SEQ_ID AS SUPPLIER_ID,
            (SELECT 
                    MIN(CONTACT_ID)
                FROM
                    CONTACT
                WHERE
                    SUPPLIER_FK = sup.PROCUBE_SEQ_ID
                        AND ACTIVE = 1) AS HASATIVECONTACT,
            sup.AMOUNT,
            sup.ADDRESS SUPADDR,
            sign.IS_TO_SEND IS_TO_SEND,
            st.STATUS STATUS,
            si.IRRELEVANT IRRELEVANT,
            pv.APPROVE APPROVE,
            ca.ASSESSMENT_ID AS CSR_ASSESSMENT_SENT
    FROM
        SUPPLIER sup
    LEFT OUTER JOIN SIGNATURE sign ON sup.PROCUBE_SEQ_ID = sign.SUPPLIER_FK
        AND sign.SIGNATURE_ID = (SELECT 
            MAX(SIGNATURE_ID)
        FROM
            SIGNATURE
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CHARTER_VERSION charVersion ON sign.CHARTER_VERSION_FK = charVersion.CHARTER_VERSION_ID
        AND charVersion.CHARTER_VERSION_ID = (SELECT 
            MAX(CHARTER_VERSION_ID)
        FROM
            CHARTER_VERSION
        WHERE
            ACTIVE = 1)
    LEFT OUTER JOIN SUPPLIER_QUESTIONNAIRE suppquest ON sup.PROCUBE_SEQ_ID = suppquest.SUPPLIER_FK
    LEFT OUTER JOIN ECOVADIS_RATING ecovadis ON sup.PROCUBE_SEQ_ID = ecovadis.SUPPLIER_FK
        AND ecovadis.ECOVADIS_ID = (SELECT 
            MAX(ECOVADIS_ID)
        FROM
            ECOVADIS_RATING
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN WCA_RATING wca ON sup.PROCUBE_SEQ_ID = wca.SUPPLIER_FK
        AND wca.WCA_ID = (SELECT 
            MAX(WCA_ID)
        FROM
            WCA_RATING
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CSR_INTERNAL_AUDIT csrInt ON sup.PROCUBE_SEQ_ID = csrInt.SUPPLIER_FK
        AND csrInt.CSR_ID = (SELECT 
            MAX(CSR_ID)
        FROM
            CSR_INTERNAL_AUDIT
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CSR_ASSESSMENT ca ON sup.PROCUBE_SEQ_ID = ca.SUPPLIER_FK
        AND ca.ASSESSMENT_ID = (SELECT 
            MAX(ASSESSMENT_ID)
        FROM
            CSR_ASSESSMENT
        WHERE
            SUPPLIER_FK = sup.PROCUBE_SEQ_ID)
    LEFT OUTER JOIN CAP_STATUS cap ON sup.PROCUBE_SEQ_ID = cap.SUPPLIER_FK
    LEFT OUTER JOIN SUPPLIER_SUBCATEGORIES ssc ON sup.PROCUBE_SEQ_ID = ssc.SUPPLIER_FK
    LEFT OUTER JOIN TURNOVER trn ON sup.PROCUBE_SEQ_ID = trn.SUPPLIER_FK
    LEFT OUTER JOIN TMP_ENTITY_COUNTRY entCntry ON entCntry.ENTITY_FK = trn.LEGAL_ENTITY_ID
    LEFT OUTER JOIN SUPP_STATUS st ON st.SUPPLIER_ID = sup.PROCUBE_SEQ_ID
    LEFT OUTER JOIN SUPP_IRRELEVANT si ON si.SUPPLIER_ID = sup.PROCUBE_SEQ_ID
    LEFT OUTER JOIN PURCHASER_VALIDATION pv ON pv.SUPPLIER_FK = sup.PROCUBE_SEQ_ID
        AND pv.APPROVE = - 1
    WHERE
        sup.AMOUNT > 0.0
            AND (si.IRRELEVANT <> 1
            OR si.IRRELEVANT IS NULL)
    GROUP BY sup.PROCUBE_SEQ_ID
    LIMIT 500) QR1
    LEFT OUTER JOIN (SELECT 
        st.SUPPLIER_ID AS SUPPLIER_ID1,
            GROUP_CONCAT(TRIM(su.SUPPLIER_NAME), ' - ', IF(sg.SIGNATURE_DATE IS NOT NULL, 'SIGNED', 'NOT SIGNED'), ',') SUBSIDIARIES
    FROM
        SUPP_STATUS st
    INNER JOIN SUPPLIER_HIERARCHY sh ON st.SUPPLIER_ID = sh.GROUP_HEADER_ID
        AND sh.GROUP_HEADER_ID != sh.PROCUBE_SEQ_ID
    LEFT OUTER JOIN SUPPLIER su ON su.PROCUBE_SEQ_ID = sh.PROCUBE_SEQ_ID
    INNER JOIN SIGNATURE sg ON sg.SUPPLIER_FK = sh.PROCUBE_SEQ_ID
    WHERE
        st.STATUS = 'VS'
            AND sg.SIGNATURE_DATE IS NOT NULL
    GROUP BY SUPPLIER_ID1) QR2 ON QR1.SUPPLIER_ID = QR2.SUPPLIER_ID1)
ORDER BY ISGRPHEADER , SUP_NAME , AMOUNT , CHARTER_VERSION_ID DESC;

my question is very simple..one supplier belong to multiple countries....

for example:

A is supplier who belongs to
INDIA
NEW ZEALAND
AUSTRALIA
NETHERLANDS
LUXEMBOURG
BELGIUM
URUGUAY
PARAGUAY
CHILE

NOW if i search supplier with country ='INDIA' then it should return all countries with india.

Thanks,
Amit
Re: how to retrive all COUNTRY from a table [message #666721 is a reply to message #666719] Tue, 21 November 2017 04:29 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Again all the countries with india is: india.

saying you want all the countries with the country specified will never make sense.
You need to explain in detail the relationship between the countries you want in the output to the country specified in the filter.
Re: how to retrive all COUNTRY from a table [message #666723 is a reply to message #666721] Tue, 21 November 2017 05:10 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
Again all the countries with india is: india.

No it's

INDIA
NEW ZEALAND
AUSTRALIA
NETHERLANDS
LUXEMBOURG
BELGIUM
URUGUAY
PARAGUAY
CHILE

Output should come as S2.png
Re: how to retrive all COUNTRY from a table [message #666724 is a reply to message #666723] Tue, 21 November 2017 05:44 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Doesn't this filter
    HAVING COUNTRY IN ('PT')
exclude everything that isn't PT? You need to filter on supplier, not country.

(You also need to learn to use SQL*Plus. It isn't difficult.)
Re: how to retrive all COUNTRY from a table [message #666725 is a reply to message #666719] Tue, 21 November 2017 06:32 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ajamitjain129@gmail.com wrote on Tue, 21 November 2017 04:09
Am sorry... i don't know how to connect Db through sql plus. Please check complete SQl with and without filter.
sqlplus is the most fundamental command line client for accessing an Oracle database. For anyone who works with an Oracle database in any capacity to say they don't know how to use sqlplus is like an auto mechanic saying they don't know how to use a wrench. Start your education here: https://docs.oracle.com/cd/E11882_01/server.112/e16604/toc.htm

As for your attachments, many work sites block attachments. And many of us who do not have them blocked will refuse to open them for the same reason other sites block them.

As for the queries themselves, can you write a sql query against a table for which you do not have the definition? Neither can anyone else. Can you test a query against a table for which you have no data? Neither can anyone else. You need to provide the CREATE TABLE and INSERT statements to load the table with representative test data.
Re: how to retrive all COUNTRY from a table [message #666726 is a reply to message #666724] Tue, 21 November 2017 06:46 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
You are write...we should remove HAVING COUNTRY IN ('PT') after that what we need to add for list of country including particular country.

I know sqlplus with oracle but i don't for mysql.
Re: how to retrive all COUNTRY from a table [message #666727 is a reply to message #666726] Tue, 21 November 2017 07:24 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
Please find CREATE TABLE and INSERT statements in the attachment.
Re: how to retrive all COUNTRY from a table [message #666728 is a reply to message #666727] Tue, 21 November 2017 07:24 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
PFA.
Re: how to retrive all COUNTRY from a table [message #666729 is a reply to message #666728] Tue, 21 November 2017 07:25 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
PFA.
Re: how to retrive all COUNTRY from a table [message #666730 is a reply to message #666729] Tue, 21 November 2017 07:25 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
PFA.
Re: how to retrive all COUNTRY from a table [message #666731 is a reply to message #666730] Tue, 21 November 2017 07:30 Go to previous messageGo to next message
ajamitjain129@gmail.com
Messages: 36
Registered: July 2014
Location: bangalore
Member
We have to work on below SQL.

select sup.FO_DUNS_ID DUNS_ID,
sup.SUPPLIER_NAME SUP_NAME, GROUP_CONCAT(DISTINCT entCntry.COUNTRY_FK) COUNTRY from SUPPLIER sup
LEFT OUTER JOIN TURNOVER trn ON sup.PROCUBE_SEQ_ID = trn.SUPPLIER_FK
LEFT OUTER JOIN TMP_ENTITY_COUNTRY entCntry ON entCntry.ENTITY_FK = trn.LEGAL_ENTITY_ID;

Please let me know, if you need anything else.
Re: how to retrive all COUNTRY from a table [message #666741 is a reply to message #666726] Wed, 22 November 2017 07:00 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ajamitjain129@gmail.com wrote on Tue, 21 November 2017 06:46


I know sqlplus with oracle but i don't for mysql.
Mysql?

MYSQL?

You never said you were working with a mysql database. So why are you asking on an Oracle forum and not a MySQL forum? In spite of the ANSI standards, teh SQL language is NOT implemented uniformly across all rdbms products.

https://forums.mysql.com/
Re: how to retrive all COUNTRY from a table [message #666745 is a reply to message #666741] Wed, 22 November 2017 07:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
EdStevens wrote on Wed, 22 November 2017 05:00
ajamitjain129@gmail.com wrote on Tue, 21 November 2017 06:46


I know sqlplus with oracle but i don't for mysql.
Mysql?

MYSQL?

You never said you were working with a mysql database. So why are you asking on an Oracle forum and not a MySQL forum? In spite of the ANSI standards, teh SQL language is NOT implemented uniformly across all rdbms products.

https://forums.mysql.com/
PLEASE observe thread Title which clears states "MYSQL"
Re: how to retrive all COUNTRY from a table [message #666751 is a reply to message #666745] Thu, 23 November 2017 02:59 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
And Oracle owns MySQL.
Previous Topic: JSON extract
Next Topic: OLE DB provider "OraOLEDB.Oracle" for linked server "GTPFR" returned message "ORA-00907: missing rig
Goto Forum:
  


Current Time: Thu Mar 28 11:48:15 CDT 2024