select row having one kind of value only while missing other from a pair












0














I have to select row which has one kind of value in one row but not the other row, both row having a key entity common



Sample model :



+------+---------+---------------+

| key  | status  |   arrival_p   |

+------+---------+---------------+

|  k1  | failure |      came     |

|  k1  | success |      gone     |

|  k2  | failure |      came     |

|  k3  | success |      came     |

|  k3  | failure |      gone     |

|  k4  | success |      came     |

|  k5  | success |      came     |

|  k2  | success |      gone     |

|  k6  | success |      gone     |

+------+---------+---------------+


so in this case, except for k4 and k5, all have come and gone. how can i find folks who have come but not gone??
k6 has just gone, so its an outlier, good to catch it but not immediate priority.



i tried below query but it doesn't work (i know of exact value in actual table which matches my description but below query returns no value at all) :



select ap1.`key`

from `arrival_pattern` ap1

    left join `arrival_pattern` ap2

    on ap1.`key` = ap2.`key`

where ap2.`key` is NULL

    and ap1.`arrival_p` = 'came'

    and ap2.`arrival_p` = 'gone'

limit 10;


any help or pointers in right direction as to what might be wrong in my join is helpful. i am on mysql.



TIA :)






mysql sql







share|improve this question






















  • Possible values for arrival_p are exclusively came and gone? For each key there's at most 1 record with arrival_p=came and at most 1 record with arrival_p=gone?
    – Robert Kock
    Nov 21 at 8:54










  • yes sir...its an enum from code with only possible values of came / gone, key + arrival_p have unique constraint
    – NoobEditor
    Nov 21 at 8:56


















0














I have to select row which has one kind of value in one row but not the other row, both row having a key entity common



Sample model :



+------+---------+---------------+

| key  | status  |   arrival_p   |

+------+---------+---------------+

|  k1  | failure |      came     |

|  k1  | success |      gone     |

|  k2  | failure |      came     |

|  k3  | success |      came     |

|  k3  | failure |      gone     |

|  k4  | success |      came     |

|  k5  | success |      came     |

|  k2  | success |      gone     |

|  k6  | success |      gone     |

+------+---------+---------------+


so in this case, except for k4 and k5, all have come and gone. how can i find folks who have come but not gone??
k6 has just gone, so its an outlier, good to catch it but not immediate priority.



i tried below query but it doesn't work (i know of exact value in actual table which matches my description but below query returns no value at all) :



select ap1.`key`

from `arrival_pattern` ap1

    left join `arrival_pattern` ap2

    on ap1.`key` = ap2.`key`

where ap2.`key` is NULL

    and ap1.`arrival_p` = 'came'

    and ap2.`arrival_p` = 'gone'

limit 10;


any help or pointers in right direction as to what might be wrong in my join is helpful. i am on mysql.



TIA :)






mysql sql







share|improve this question






















  • Possible values for arrival_p are exclusively came and gone? For each key there's at most 1 record with arrival_p=came and at most 1 record with arrival_p=gone?
    – Robert Kock
    Nov 21 at 8:54










  • yes sir...its an enum from code with only possible values of came / gone, key + arrival_p have unique constraint
    – NoobEditor
    Nov 21 at 8:56
















0












0








0







I have to select row which has one kind of value in one row but not the other row, both row having a key entity common



Sample model :



+------+---------+---------------+

| key  | status  |   arrival_p   |

+------+---------+---------------+

|  k1  | failure |      came     |

|  k1  | success |      gone     |

|  k2  | failure |      came     |

|  k3  | success |      came     |

|  k3  | failure |      gone     |

|  k4  | success |      came     |

|  k5  | success |      came     |

|  k2  | success |      gone     |

|  k6  | success |      gone     |

+------+---------+---------------+


so in this case, except for k4 and k5, all have come and gone. how can i find folks who have come but not gone??
k6 has just gone, so its an outlier, good to catch it but not immediate priority.



i tried below query but it doesn't work (i know of exact value in actual table which matches my description but below query returns no value at all) :



select ap1.`key`

from `arrival_pattern` ap1

    left join `arrival_pattern` ap2

    on ap1.`key` = ap2.`key`

where ap2.`key` is NULL

    and ap1.`arrival_p` = 'came'

    and ap2.`arrival_p` = 'gone'

limit 10;


any help or pointers in right direction as to what might be wrong in my join is helpful. i am on mysql.



TIA :)






mysql sql







share|improve this question













I have to select row which has one kind of value in one row but not the other row, both row having a key entity common



Sample model :



+------+---------+---------------+

| key  | status  |   arrival_p   |

+------+---------+---------------+

|  k1  | failure |      came     |

|  k1  | success |      gone     |

|  k2  | failure |      came     |

|  k3  | success |      came     |

|  k3  | failure |      gone     |

|  k4  | success |      came     |

|  k5  | success |      came     |

|  k2  | success |      gone     |

|  k6  | success |      gone     |

+------+---------+---------------+


so in this case, except for k4 and k5, all have come and gone. how can i find folks who have come but not gone??
k6 has just gone, so its an outlier, good to catch it but not immediate priority.



i tried below query but it doesn't work (i know of exact value in actual table which matches my description but below query returns no value at all) :



select ap1.`key`

from `arrival_pattern` ap1

    left join `arrival_pattern` ap2

    on ap1.`key` = ap2.`key`

where ap2.`key` is NULL

    and ap1.`arrival_p` = 'came'

    and ap2.`arrival_p` = 'gone'

limit 10;


any help or pointers in right direction as to what might be wrong in my join is helpful. i am on mysql.



TIA :)






mysql sql




mysql sql






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 21 at 8:42









NoobEditor

11.2k84879




11.2k84879












  • Possible values for arrival_p are exclusively came and gone? For each key there's at most 1 record with arrival_p=came and at most 1 record with arrival_p=gone?
    – Robert Kock
    Nov 21 at 8:54










  • yes sir...its an enum from code with only possible values of came / gone, key + arrival_p have unique constraint
    – NoobEditor
    Nov 21 at 8:56




















  • Possible values for arrival_p are exclusively came and gone? For each key there's at most 1 record with arrival_p=came and at most 1 record with arrival_p=gone?
    – Robert Kock
    Nov 21 at 8:54










  • yes sir...its an enum from code with only possible values of came / gone, key + arrival_p have unique constraint
    – NoobEditor
    Nov 21 at 8:56


















Possible values for arrival_p are exclusively came and gone? For each key there's at most 1 record with arrival_p=came and at most 1 record with arrival_p=gone?
– Robert Kock
Nov 21 at 8:54




Possible values for arrival_p are exclusively came and gone? For each key there's at most 1 record with arrival_p=came and at most 1 record with arrival_p=gone?
– Robert Kock
Nov 21 at 8:54












yes sir...its an enum from code with only possible values of came / gone, key + arrival_p have unique constraint
– NoobEditor
Nov 21 at 8:56






yes sir...its an enum from code with only possible values of came / gone, key + arrival_p have unique constraint
– NoobEditor
Nov 21 at 8:56














2 Answers
2






active

oldest

votes


















3














Since both came and gone can appear only once for a specific key, you might as well select the elements for which a single record exists:



SELECT   `key`,

         COUNT(*)

FROM     arrival_pattern

GROUP BY `key`

HAVING   COUNT(*) = 1;


This solves also the second question ('k6 has just gone').



Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.






share|improve this answer























  • ohh maannnn....sometimes overthinking kills the simple solution, this is clean +1!!!
    – NoobEditor
    Nov 21 at 9:04






  • 1




    @NoobEditor Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.
    – Madhur Bhaiya
    Nov 21 at 9:04








  • 1




    @MadhurBhaiya : this is just a reference schema buddy, dont go by my screen name, m not really that noob! :D
    – NoobEditor
    Nov 21 at 9:13










  • @NoobEditor ;) well I am not a telepath :P
    – Madhur Bhaiya
    Nov 21 at 9:14










  • If any key just contain 'gone' that key also return on this query but if your real data is like sample no exception that I thought then it will work fine
    – Zaynul Abadin Tuhin
    Nov 21 at 14:10





















1














use not exists



select t1.* from  arrival_pattern t1

where not exists ( select 1 

                   from arrival_pattern t2 

                   where t2.key=t1.key 

                         and t2.arrival_p='gone')


you can try below self join



select t1.* arrival_pattern t1 

 left join 

(select key from 

  arrival_pattern t2 where arrival_p='gone'

) t2

 on t1.key=t2.key where t2.key is null





share|improve this answer























  • any way using joins??
    – NoobEditor
    Nov 21 at 8:45










  • @NoobEditor yes you can use self join
    – Zaynul Abadin Tuhin
    Nov 21 at 8:46










  • what exactly is select 1 doing in not exist this case????
    – NoobEditor
    Nov 21 at 8:48








  • 1




    @NoobEditor actually EXISTS operator returns true if the subquery returns one or more records so i select constant value 1 rather any column selection you can read docs of sql how exists work
    – Zaynul Abadin Tuhin
    Nov 21 at 8:50













Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53408142%2fselect-row-having-one-kind-of-value-only-while-missing-other-from-a-pair%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes









3














Since both came and gone can appear only once for a specific key, you might as well select the elements for which a single record exists:



SELECT   `key`,

         COUNT(*)

FROM     arrival_pattern

GROUP BY `key`

HAVING   COUNT(*) = 1;


This solves also the second question ('k6 has just gone').



Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.






share|improve this answer























  • ohh maannnn....sometimes overthinking kills the simple solution, this is clean +1!!!
    – NoobEditor
    Nov 21 at 9:04






  • 1




    @NoobEditor Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.
    – Madhur Bhaiya
    Nov 21 at 9:04








  • 1




    @MadhurBhaiya : this is just a reference schema buddy, dont go by my screen name, m not really that noob! :D
    – NoobEditor
    Nov 21 at 9:13










  • @NoobEditor ;) well I am not a telepath :P
    – Madhur Bhaiya
    Nov 21 at 9:14










  • If any key just contain 'gone' that key also return on this query but if your real data is like sample no exception that I thought then it will work fine
    – Zaynul Abadin Tuhin
    Nov 21 at 14:10


















3














Since both came and gone can appear only once for a specific key, you might as well select the elements for which a single record exists:



SELECT   `key`,

         COUNT(*)

FROM     arrival_pattern

GROUP BY `key`

HAVING   COUNT(*) = 1;


This solves also the second question ('k6 has just gone').



Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.






share|improve this answer























  • ohh maannnn....sometimes overthinking kills the simple solution, this is clean +1!!!
    – NoobEditor
    Nov 21 at 9:04






  • 1




    @NoobEditor Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.
    – Madhur Bhaiya
    Nov 21 at 9:04








  • 1




    @MadhurBhaiya : this is just a reference schema buddy, dont go by my screen name, m not really that noob! :D
    – NoobEditor
    Nov 21 at 9:13










  • @NoobEditor ;) well I am not a telepath :P
    – Madhur Bhaiya
    Nov 21 at 9:14










  • If any key just contain 'gone' that key also return on this query but if your real data is like sample no exception that I thought then it will work fine
    – Zaynul Abadin Tuhin
    Nov 21 at 14:10
















3












3








3






Since both came and gone can appear only once for a specific key, you might as well select the elements for which a single record exists:



SELECT   `key`,

         COUNT(*)

FROM     arrival_pattern

GROUP BY `key`

HAVING   COUNT(*) = 1;


This solves also the second question ('k6 has just gone').



Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.






share|improve this answer














Since both came and gone can appear only once for a specific key, you might as well select the elements for which a single record exists:



SELECT   `key`,

         COUNT(*)

FROM     arrival_pattern

GROUP BY `key`

HAVING   COUNT(*) = 1;


This solves also the second question ('k6 has just gone').



Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.







share|improve this answer














share|improve this answer



share|improve this answer








edited Nov 21 at 9:04









Madhur Bhaiya

19.5k62236




19.5k62236










answered Nov 21 at 9:01









Robert Kock

3,9591617




3,9591617












  • ohh maannnn....sometimes overthinking kills the simple solution, this is clean +1!!!
    – NoobEditor
    Nov 21 at 9:04






  • 1




    @NoobEditor Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.
    – Madhur Bhaiya
    Nov 21 at 9:04








  • 1




    @MadhurBhaiya : this is just a reference schema buddy, dont go by my screen name, m not really that noob! :D
    – NoobEditor
    Nov 21 at 9:13










  • @NoobEditor ;) well I am not a telepath :P
    – Madhur Bhaiya
    Nov 21 at 9:14










  • If any key just contain 'gone' that key also return on this query but if your real data is like sample no exception that I thought then it will work fine
    – Zaynul Abadin Tuhin
    Nov 21 at 14:10




















  • ohh maannnn....sometimes overthinking kills the simple solution, this is clean +1!!!
    – NoobEditor
    Nov 21 at 9:04






  • 1




    @NoobEditor Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.
    – Madhur Bhaiya
    Nov 21 at 9:04








  • 1




    @MadhurBhaiya : this is just a reference schema buddy, dont go by my screen name, m not really that noob! :D
    – NoobEditor
    Nov 21 at 9:13










  • @NoobEditor ;) well I am not a telepath :P
    – Madhur Bhaiya
    Nov 21 at 9:14










  • If any key just contain 'gone' that key also return on this query but if your real data is like sample no exception that I thought then it will work fine
    – Zaynul Abadin Tuhin
    Nov 21 at 14:10


















ohh maannnn....sometimes overthinking kills the simple solution, this is clean +1!!!
– NoobEditor
Nov 21 at 9:04




ohh maannnn....sometimes overthinking kills the simple solution, this is clean +1!!!
– NoobEditor
Nov 21 at 9:04




1




1




@NoobEditor Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.
– Madhur Bhaiya
Nov 21 at 9:04






@NoobEditor Also, note that key is a Reserved Keyword in MySQL. You should seriously consider naming your column to something else.
– Madhur Bhaiya
Nov 21 at 9:04






1




1




@MadhurBhaiya : this is just a reference schema buddy, dont go by my screen name, m not really that noob! :D
– NoobEditor
Nov 21 at 9:13




@MadhurBhaiya : this is just a reference schema buddy, dont go by my screen name, m not really that noob! :D
– NoobEditor
Nov 21 at 9:13












@NoobEditor ;) well I am not a telepath :P
– Madhur Bhaiya
Nov 21 at 9:14




@NoobEditor ;) well I am not a telepath :P
– Madhur Bhaiya
Nov 21 at 9:14












If any key just contain 'gone' that key also return on this query but if your real data is like sample no exception that I thought then it will work fine
– Zaynul Abadin Tuhin
Nov 21 at 14:10






If any key just contain 'gone' that key also return on this query but if your real data is like sample no exception that I thought then it will work fine
– Zaynul Abadin Tuhin
Nov 21 at 14:10















1














use not exists



select t1.* from  arrival_pattern t1

where not exists ( select 1 

                   from arrival_pattern t2 

                   where t2.key=t1.key 

                         and t2.arrival_p='gone')


you can try below self join



select t1.* arrival_pattern t1 

 left join 

(select key from 

  arrival_pattern t2 where arrival_p='gone'

) t2

 on t1.key=t2.key where t2.key is null





share|improve this answer























  • any way using joins??
    – NoobEditor
    Nov 21 at 8:45










  • @NoobEditor yes you can use self join
    – Zaynul Abadin Tuhin
    Nov 21 at 8:46










  • what exactly is select 1 doing in not exist this case????
    – NoobEditor
    Nov 21 at 8:48








  • 1




    @NoobEditor actually EXISTS operator returns true if the subquery returns one or more records so i select constant value 1 rather any column selection you can read docs of sql how exists work
    – Zaynul Abadin Tuhin
    Nov 21 at 8:50


















1














use not exists



select t1.* from  arrival_pattern t1

where not exists ( select 1 

                   from arrival_pattern t2 

                   where t2.key=t1.key 

                         and t2.arrival_p='gone')


you can try below self join



select t1.* arrival_pattern t1 

 left join 

(select key from 

  arrival_pattern t2 where arrival_p='gone'

) t2

 on t1.key=t2.key where t2.key is null





share|improve this answer























  • any way using joins??
    – NoobEditor
    Nov 21 at 8:45










  • @NoobEditor yes you can use self join
    – Zaynul Abadin Tuhin
    Nov 21 at 8:46










  • what exactly is select 1 doing in not exist this case????
    – NoobEditor
    Nov 21 at 8:48








  • 1




    @NoobEditor actually EXISTS operator returns true if the subquery returns one or more records so i select constant value 1 rather any column selection you can read docs of sql how exists work
    – Zaynul Abadin Tuhin
    Nov 21 at 8:50
















1












1








1






use not exists



select t1.* from  arrival_pattern t1

where not exists ( select 1 

                   from arrival_pattern t2 

                   where t2.key=t1.key 

                         and t2.arrival_p='gone')


you can try below self join



select t1.* arrival_pattern t1 

 left join 

(select key from 

  arrival_pattern t2 where arrival_p='gone'

) t2

 on t1.key=t2.key where t2.key is null





share|improve this answer














use not exists



select t1.* from  arrival_pattern t1

where not exists ( select 1 

                   from arrival_pattern t2 

                   where t2.key=t1.key 

                         and t2.arrival_p='gone')


you can try below self join



select t1.* arrival_pattern t1 

 left join 

(select key from 

  arrival_pattern t2 where arrival_p='gone'

) t2

 on t1.key=t2.key where t2.key is null






share|improve this answer














share|improve this answer



share|improve this answer








edited Nov 21 at 8:48

























answered Nov 21 at 8:44









Zaynul Abadin Tuhin

11.3k2831




11.3k2831












  • any way using joins??
    – NoobEditor
    Nov 21 at 8:45










  • @NoobEditor yes you can use self join
    – Zaynul Abadin Tuhin
    Nov 21 at 8:46










  • what exactly is select 1 doing in not exist this case????
    – NoobEditor
    Nov 21 at 8:48








  • 1




    @NoobEditor actually EXISTS operator returns true if the subquery returns one or more records so i select constant value 1 rather any column selection you can read docs of sql how exists work
    – Zaynul Abadin Tuhin
    Nov 21 at 8:50




















  • any way using joins??
    – NoobEditor
    Nov 21 at 8:45










  • @NoobEditor yes you can use self join
    – Zaynul Abadin Tuhin
    Nov 21 at 8:46










  • what exactly is select 1 doing in not exist this case????
    – NoobEditor
    Nov 21 at 8:48








  • 1




    @NoobEditor actually EXISTS operator returns true if the subquery returns one or more records so i select constant value 1 rather any column selection you can read docs of sql how exists work
    – Zaynul Abadin Tuhin
    Nov 21 at 8:50


















any way using joins??
– NoobEditor
Nov 21 at 8:45




any way using joins??
– NoobEditor
Nov 21 at 8:45












@NoobEditor yes you can use self join
– Zaynul Abadin Tuhin
Nov 21 at 8:46




@NoobEditor yes you can use self join
– Zaynul Abadin Tuhin
Nov 21 at 8:46












what exactly is select 1 doing in not exist this case????
– NoobEditor
Nov 21 at 8:48






what exactly is select 1 doing in not exist this case????
– NoobEditor
Nov 21 at 8:48






1




1




@NoobEditor actually EXISTS operator returns true if the subquery returns one or more records so i select constant value 1 rather any column selection you can read docs of sql how exists work
– Zaynul Abadin Tuhin
Nov 21 at 8:50






@NoobEditor actually EXISTS operator returns true if the subquery returns one or more records so i select constant value 1 rather any column selection you can read docs of sql how exists work
– Zaynul Abadin Tuhin
Nov 21 at 8:50




















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53408142%2fselect-row-having-one-kind-of-value-only-while-missing-other-from-a-pair%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

404 Error Contact Form 7 ajax form submitting

Image
0 The contact form does not work, and affects loading after one try. The chrome console shows the error message: POST http://example.com/wp-json/contact-form-7/v1/contact-forms/50/feedback 404 (Not Found) send @ jquery.js?ver=1.12.4:4 ajax @ jquery.js?ver=1.12.4:4 wpcf7.submit @ scripts.js?ver=5.0.3:346 (anonymous) @ scripts.js?ver=5.0.3:53 dispatch @ jquery.js?ver=1.12.4:3 r.handle @ jquery.js?ver=1.12.4:3 How to solve this issue? thanks in advance javascript wordpress contact-form-7 share | improve this question edited Jul 17 '18 at 5:39 Kiran Shahi 4,745 3 16 43 ...
Read more

How to know if a Active Directory user can login interactively

Image
1 I would like to know if and how is it possible to know if a AD user can login interactively (on a server) in a domain. I need to know if I can find it out using a LDAP search. Thanks. windows active-directory login user-permissions user-profile share | improve this question edited 1 hour ago yagmoth555 ♦ 11.6k 3 17 42 asked 1 hour ago Luigi Luigi 6 1 New contributor ...
Read more

Refactoring coordinates for Minecraft Pi buildings written in Python

Image
0 $begingroup$ I'm fairly new to coding and I wrote this script in Python for a house with a roof in Minecraft Pi. I've found different ways to write the coordinates to make the code base shorter, but I'm wondering if it is possible for me to refactor it any further so I don't have to list each coordinate line by line. import mcpi.minecraft as minecraft import mcpi.block as block mc = minecraft.Minecraft.create() p = mc.player.getTilePos() mc.setBlocks(p.x+1, p.y, p.z+1, #Main structure starting coordinates (DO NOT ALTER) p.x+19, p.y+4, p.z+6, #Structure size/coordinates (Alters cube size) block.STONE_BRICK) mc.setBlocks(p.x+2, p.y+1, p.z+2, #Hollowing out main structure interior p.x+18, p.y+3, p.z+5, block.AIR) mc.setBlocks(p.x, p.y...
Read more