Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update date time database failed
Maybe you should set the $dateID-Variable in the WHERe-Clause also in quotes. Thomas -
SELECT DISTINCT on only one column
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... -
Syntax error MySQL CC
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... -
Optimizing query
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 -
Need help with A query
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... -
German Daynames with DATE_FORMAT()
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... -
German Daynames with DATE_FORMAT()
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... -
mySQL Control Center - is there ANY Help available?
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...
