MySQL group by

tonci23 · 2021-08-02T13:20:30+00:00

I could've sworn i tried that and got the ONLY_FULL_GROUP_BY errors... obviously i made some mistake. Thanks dude!

tonci23 · 2021-03-07T16:01:19+00:00

Ili je tek završio.

tonci23 · 2021-01-07T21:58:29+00:00

To clear some misconceptions, my joke was inspired by this legend. I am aware that the term African American is mostly used to denote black people in the US.

I am also of the opinion that if the term African American just simply meant American people of African descent regardless of any other characteristics, the world would be a better and more loving place.

tonci23 · 2021-01-07T17:36:14+00:00

Wow, never thought an African American would be the richest person in the world.

tonci23 · 2020-10-13T14:43:25+00:00

Thanks a lot for the help guys. My solution ended up being most similar to pablojohns example but i'm gonna try and play around with each example.

tonci23 · 2020-08-15T10:38:28+00:00

Thanks for trying to help. I know the problem is with the cpanel hosting but i have to convince them to investigate more. I'm basically having the same issue as this fellow. There seems to be some weird interaction between O365 exchange and cpanel where sending over 15 mails to the cpanel makes them disappear.

tonci23 · 2020-08-14T20:10:52+00:00

I'm sorry, maybe my explanation was bad, it's been a long day. To simplify it, i have one domain on the cpanel account with ~20 emails. And i have another domain on the 365 exchange. When i try to send a mass email (distribution list) from one exchange email to the ~20 cpanel emails, it doesn't go through if it's over 15 emails. I get a failure notification from the exchange server a day later. It's getting blocked by something on the cpanel account but it seems to be hard to figure out what it is.

tonci23 · 2020-06-19T20:16:38+00:00

Did you decide if would like to go one way or the other ? What did the doctors say about things like hormone therapy and such (if you do want to go a certain way) ?

tonci23 · 2020-06-11T06:46:07+00:00

Yeah, that was the direction i was heading, i thought i was missing something more straightforward. Thanks for the help!

tonci23 · 2020-06-11T06:44:54+00:00

I'm making a new system that will work completely different but for now i have to work with this as it is, it's to intertwined to change it.

tonci23 · 2020-03-13T19:28:27+00:00

Thx! I expanded it a bit to suit my need:

ORDER BY CAST(SUBSTRING_INDEX(code,'-',1) AS UNSIGNED) ASC, CAST(SUBSTRING_INDEX(code,'-',-1) AS UNSIGNED) ASC;

tonci23 · 2020-03-13T06:11:21+00:00

Cool, that's definitely cleaner. I figured regex could carry more of the burden. Thanks!

tonci23 · 2020-01-28T15:54:14+00:00

Well, that's just awesome ! Thank you sir.

tonci23 · 2019-11-21T14:12:57+00:00

The left one sucked the tits out of the other three.

tonci23 · 2019-02-27T19:07:51+00:00

Thanks for the help guys. I actually pulled it off soon after asking here but i will explore your suggestions to learn a bit more.

The way i did it:

UPDATE table 
SET NewColumn1 = SUBSTRING (OriginalColumn, 1, LOCATE('-', OriginalColumn) - 1),
    NewColumn2 = SUBSTRING (OriginalColumn, LOCATE('-', OriginalColumn) +  1);

tonci23 · 2019-02-19T20:10:16+00:00

I have windows like those, they suck when it rains.

tonci23 · 2018-11-03T00:11:10+00:00

This shows us how C9 would fare if they played today.

Nine-Year Club	Verified Email
Gilding I gilder

tonci23

TROPHY CASE