If you are using a relational DB you must see that a table is mostly 2-dimensional: these two dimensions can be regarded as horizontal and vertical.
A SELECT-Statement will give you any result you want and you can restrict it horizontically as well as vertically. Each restriction is done by the...
Hi, techhead,
I made a similar experience like you did, and so i changed to phpMyAdmin. It's easy to install and it works fine.
In my sight MySQL CC is just a work in progress and an awful dummy - no Manual, no help available, nothing.
I don't want to blame the team that develops mysql CC...
you must list every column that isn't an aggregate in the group by-Clause
SELECT max(class.ID) as x, class.name, max(values.number) as z, values.othercolumn from ... ... group by class.name, values.othercolumn
Hi, Wiz,
how can you show events from Monday?
Use the 'dayofweek()'-function
select bla bla
from table
where dayofweek(event)=2
;
With this you get ALL events that occured on any Monday in the past and will occur in the future (if registered).
To show events from next Monday only you can...
Dear Rudy,
thank you very much for translating my posting in english so accurately and so fast.
I'm certainly aware that english is the "lingua franca" of IT, but I was in a little hurry and so I wrote it all in German.
Please, for this time, excuse my misbehaving, I won't do it...
Hi Roland,
da du deutsche Wochentage brauchst, schreib ich dir auf deutsch.
Ich hab auch keinen Sprachsupport gefunden, also ist es nötig, eine kleine Umsetztabelle einzuführen. Das sieht auf den ersten Blick komplex aus, aber es funktioniert. Ich würde Dir empfehlen, den Select, wie ich ihn...
Hi, folks,
i want to RTFM of mysqlcc-0.9.1-linux-glibc22 and even by STFW for what is now hours i didn't find this @*!+@-Manual.
So my question is: Is there a manual available for the Control-Center? And is me a dumb German who cannot find it because i misused too much Munich Beer in an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.