Subscribe by EmailArchives
- mySQL error with query SELECT itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) as Day FROM nucleus_item WHERE iblog=1 and itime <="2024-04-18 10:24:23" and idraft=0 and icat=3 GROUP BY Year, Month ORDER BY itime DESC: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mohammad_cms.nucleus_item.itime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
August 01, 2008: The life of me!
Once a man went to a Veterinary Doctor and said:
"Doctor I have come on vacation for a month so that I can get myself
treated fully within this period."
Doctor: I think you should go to the Doctor opposite to my clinic, see that board.
Man: No, Doctor, I have come to you only
Doctor: But, gentleman I am a Veterinary Doctor. I am an animal specialist.
I do not treat human beings.
Man: I know, Doctor very well and that is why I have come to you only...
Doctor: I can not, because you speak like me, think like me, talk like me which means
you are a human being and not an animal.
Man: I know I am a human but litsen to my complaints first:
Doctor: OK. Tell me.
Man:
I sleep like a dog thinking about my work load whole night.
I get up in the morning like a horse....
I go to work running like a deer.......
I work all the day like a donkey....
I run around for 11 months like a bull without any holiday.
I wag my tail in front of all my bosses.....
I play with my children like a monkey if I get time.....
I am like a rabbit before my wife..........
Doctor: Are you an engineer?
Man: Yes
Doctor: Instead of telling this long history you should have told me in the beginning
itself that you are an engineer. Come man, no one can treat you better than me.