I have a table called cc_calls and there I have many call records I want to count them and group them in months I have a timestamp called starttime and I can use that row to extract the month, also limit the count for 12 months  the results should be like:  Month       Count  January     768768 February    876786 March       987979 April       765765 May         898797 June        876876 July        786575 August      765765 September   689787 October     765879 November    897989 December    876876   Can anyone guide me or show me the mysql query that I need to get this result.
Is it possible to make a simple query to count how many records I have in a determined period of time like a year, month, or day, having a TIMESTAMP field, like:   SELECT COUNT(id) FROM stats WHERE record_date.YEAR = 2009 GROUP BY record_date.YEAR   Or even:  SELECT COUNT(id) FROM stats GROUP BY record_date.YEAR, record_date.MONTH   To have a monthly statistic.   Thanks!
Has the concept of non-integer $(n+m)$-dimensional spacetime ever been investigated by theoretical physicists? The following image serves to aid the reader in understanding the "privileged character" of $3+1$-spacetime.    The wikipedia article on , and the  "The priveleged character of $3+1$-dimensional spacetime" in particular, made me think a bit about the possibility that we might live in a non-integer amount of spatial and/or time dimensions.   The notion of attaching a non-negative real number to a metric space has at least mathematically already been described by such concepts as "" and "".   This may sound silly/ignorant/absurd to professional practicing theoretical physicists. To me (a layman), however, it doesn't sound much stranger than the idea of wrapping up six extra dimensions (which is, from what I understand, considered to be a serious possibility by those who study $10$-dimensional String Theory) into intricate shapes called "Calabi-Yau Manifolds".   Has any research on $(a +b)$-dimensional spacetime (where $a,b \in \mathbb{R}_{\geq 0} $) ever been done? If so, what where the findings? If not, why not? How to distinguish between American Indians and Indian Indians in native English (language) parlance? How to distinguish between American Indians and Indian Indians in native English (language) parlance?  Can I say Indian Indian to say Indian from Asia compared to the Native Americans? Background Video is shown in Rendered mode but not when szene is rendered i have a 3D Object and want to add a background image( if possible even a movie) to this 3D Object. I use Cycles to render and tried a plane with the  image as texture. When i go into render mode, it looks like this(picture with background) and when rendered, it has no background. The key also looks into  a different direction.  Should i even use Cycles for this or use motion tracking? i tried to use that but had several problems.     Rendered mode   When scene is rendered I've been using the beta iCloud Photo Library for a week and a bunch of photos got duplicated and I'd like to wipe all the photos out and start over.  I have backups of all the photos and have turned off iPhoto Cloud Library on all iOS devices. When I log into the web app - it still shows dozens of albums and I can delete all the photos, then go to deleted items and then purge them, but the ghost albums are still there messing things up.  I've turned off the library entirely and you can see there is a 30 day waiting period.     If I click on albums, there are pages of them and no delete button anywhere. If I turn on the library on an iOS device, data starts flooding back as if I wanted to recover the photos.  I don't want to recover anything, I want a clean wipe and clean slate.  Currently, there are 7807 photos in the deleted album and no way to mass delete them. I have 31 albums that show up in iCloud and no way to delete them.  Is there some way to accelerate this or must people wait a month for a corrupt library to eventually be purged to start over?  (I have tickets open with AppleCare after  and it's escalated to engineering, but I was informed that it might be a week or two before it gets seen :-( Perhaps someone has a better idea to clear things out or noticed something I've missed.) Old title - "change resolution to 1280x1024 using xrandr gives: X Error of failed request: BadValue (integer parameter out of range for operation)"  I have installed a fresh Ubuntu 17.10 and have a monitor with 5:4 resolution. settings has no resolution higher than 1024x768. But I need the resolution 1280x1024 (5:4).  I use the default motherboard graphics card:  # lspci|grep VGA 00:02.0 VGA compatible controller: Intel Corporation 4 Series Chipset Integrated Graphics Controller (rev 03)   Also xrandr gives the following:  $ xrandr Screen 0: minimum 320 x 200, current 1024 x 768, maximum 8192 x 8192 XWAYLAND0 connected 1024x768+0+0 (normal left inverted right x axis y axis) 0mm x 0mm    1024x768      59.92*+   I tried to add the 1280x1024 resolution using xrandr. so first created the resolution information using gtf:  $ gtf 1280 1024 60    # 1280x1024 @ 60.00 Hz (GTF) hsync: 63.60 kHz; pclk: 108.88 MHz   Modeline "1280x1024_60.00"  108.88  1280 1360 1496 1712  1024 1025 1028 1060  -HSync +Vsync   Then added to resolutions:  xrandr --newmode "1280x1024_60.00"  108.88  1280 1360 1496 1712  1024 1025 1028 1060  -HSync +Vsync   then again did the command: xrandr --addmode XWAYLAND0 1280x1024_60.00  Then nothing changed. When I tried to change it using xrandr --output XWAYLAND0 --mode 1280x1024_60.00 --rate 60 But an error occurred:  $ xrandr --output XWAYLAND0 --mode 1280x1024  --rate 60 X Error of failed request:  BadValue (integer parameter out of range for operation)   Major opcode of failed request:  140 (RANDR)   Minor opcode of failed request:  7 (RRSetScreenSize)   Value in failed request:  0x0   Serial number of failed request:  21   Current serial number in output stream:  22   I don't know what did I do wrong. Or how to change resolution to the correct one: 1280x1024 text processing rows to columns for a block Making adult decisions "is" or "are" really not fun: Which is correct? Is a URI (specifically an HTTP URL) allowed to contain one or more space characters? If a URL must be encoded, is + just a commonly followed convention, or a legitimate alternative?    In particular, can someone point to an RFC that indicates that a URL with a space must be encoded?  Motivation for question: While beta-testing a web site, I noted that some URLs were constructed with spaces in them. Firefox seemed to do the right thing, which surprised me! But I wanted to be able to point the developers to an RFC so that they would feel the need to fix those URLs. I just attempted to fix a typo on a question on cooking.stackexchange.com and saw this     Oops! Your edit couldn't be submitted because:         Your edit summary must be at least 10 characters   This edit is less than 6 characters; surely more can be improved with your edit?      So, misspelled words have to just be left misspelled?  That could prevent the post from being found in a search. Safari autofill multiple e-mail adresses Evaluation inside Button stops after some seconds Am I too old for academia after a PhD? How Does the Community User Set Bounties? I decided on poking around some profiles and I hit the . I knew that Community was a background process but then I noticed that it had set some bounties. What criteria does Community follow to know what questions to set bounties on? Are these questions with a lot of views or upvotes or all of the above? Extracting raster values at points using Open Source GIS? These two exercises I encountered recently seem to develop some type of connection between GCD and LCM I can't quite figure out. Exercise 1:  Find all the numbers $x$ and $y$ such that: $a) \ GCD(x,y)=15, \ LCM(x,y)=150$ $b) \ GCD(x,y)=120 \ LCM(x,y)=1320$ $c) \ GCD(x,y)=100 \ LCM(x,y)=990$  Exercise 2:   Find all the numbers $m,n$ such that $GCD(m,n)=pq , \ LCM(m,n)=p^2qs$  where $p,q,s$ are prime  The first thing that is known to me is that $GCD(x,y) \cdot LCM(x,y)= x \cdot y$ Also $LCM(x,y)$ is at most $x \cdot y$ while $GCD(x,y)$ is at most $\max \{x,y\}$. Last thing is that $GCD(x,y)|LCM(x,y)$. Using all this I tried to solve the first exercise: $a)$ First two obvious pairs are $x=15, y=150$ and $y=15, x=150$. Now neither of the numbers can be bigger than $150$ or smaller than $15$. So we are looking for numbers in the range $15-150$ that satisfy $x \cdot y = 15 \cdot 150$ Another such pair is $(x,y)=(30,75), \ (x,y)=(75,30)$. Similarly for $b)$ we find that the only possible values are permutations of the set {$120,1320$} and in $c)$ since $100$ does not divide $990$ no such numbers exist. Now exercise 2 is what made me think there is actually another connection I'm not quite aware of since now it's about arbitrary prime numbers and the previous method doesn't work anymore. My intuition is that it has something to do with $GCD$ or $LCM$ of the $GCD(x,y), \ LCM(x,y)$ Can we implement a dead time on answers for high reputation user Summary: High reputation users on SO come swooping in the second a simple question is posted, and get the first answer in before I've even opened my Python interpreter to test my idea out.  This actually is a problem because it prevents use lower users who aren't as good  at programming from getting any answers in.  This makes it very hard to build up reputation.  Thus, I propose a short dead time for high reputation users where their answers do not appear.  The Problem: This isn't just reputation.  By answering questions and having discussions with OP, we all get better at our language.  Teaching is one of the best ways of learning, and a more well versed population is absolutely good for SO.  (If anyone wants to argue that, go home)  While its nice to have folks who can quickly answer nearly all questions in a jiffy, its a little frustrating for those of use who simply aren't as fast, but still want to contribute.  The result is that many people do not answer questions because they feel like they just can't get an edge in.  SO should aim to incentivize as many answers by as many users as possible.  The most answers from the most users is the most beneficial situation for the site and the community. Once we accept this idea, it is clear that something needs to be done to address the issue at hand    The Solution: Luckily, this is an easy problem to solve; we use a dead time.  High reputation users can post answers whenever they like, but they won't appear until after the dead time is completed.  The trick is balance, a dead time which is too long will harm the OP as the question will remain unanswered, however, a dead time which is too short won't actually fix the problem.  There definitely needs to be a discussion about what "high reputation" means and what dead time to use, but it should be independent of whether y'all agree that this is a problem.  So, what do you think?  EDIT: Wow, -18, I leave for lunch for 30 minutes and this is what happens!  I guess y'all think this is a bad idea, but let me try to clarify a few things on which I was unclear earlier.  This is not about reputation.  This is not about getting the first answer just for the sake of getting to say "in before..."  This is about learning.  By getting a shot at answering questions before the high reputation users, people learn. Think of it as doing an example problem in class before the teacher does it. You get a chance to try it yourself, test your knowledge, and if you fail, then the teacher is right behind you to show the correct solution.  This is what I'm trying to accomplish. However, seeing the solution, and then trying to answer the question, is not very helpful. This is how I view the status quo.    In response to Mr. Pieters' answer and comments: You're absolutely right, this is not about quantity, its about quality.  The fastest answer isn't always the best.  But asking the high reputation users to take a step back for a few minutes is a means of getting there.    Hopefully this clears things up a bit. Review bans should escalate beyond 30 days completing the square for Gaussian multivariate estimation I have been trying to derive the posterior distribution in the case of weighted Bayesian regression in the case of multivariate normal distribution for a few days and have been stuck. I am not sure if this is due to lack of my linear algebra skills or if I have done something really wrong.  In my case, the distributional assumptions are:  $$ y = N (B x, W^{-1} \nabla) $$  The parameters $B$ have a normal prior.   $$ P(B) = N (B_0, \Sigma_{B}) $$  The conditional posterior distribution for $B$ is proportional to $P(y|B) P(B)$. This is proportional to:  $$ \exp \big((B - B_0)^T \Sigma (B - B_0) + (y - Bx)^T \nabla (y - Bx)\big) $$  I have seen the textbooks mention something called completing the square which as far as I can tell equates to matching like terms. Even though I could work out for scalar variance terms, I am having trouble figuring out how to deal with the precision matrices and how this can be decoupled.   [EDIT]:  So, I tried to make a run with Glen_b's suggestion and came this far:  Original expression without the exponential (I will simplify notation slightly):  $$ (B - B_0)^T \Sigma (B - B_0) + ( y - Bx)^T \nabla (y - Bx) $$ Expanding:  $$ B^T\Sigma B - 2 B_0^T \Sigma B + B_0^T \Sigma B_0 + y^T \nabla y - 2 y^T \nabla B x + (Bx)^T \nabla Bx $$  $$ = B^T(\Sigma + x^T \nabla x)B - 2 (B_0^T \Sigma B + y^T \nabla B x) + C $$  So I am not sure how to make further progress with the second term. I guess I have to make it in the form 2(some_term)B but not sure how that can be done. It is company policy for admins to login to the servers via a personal username, and then run sudo -i to become root.  Upon running sudo -i, sudo will create an environmental variable called SUDO_USER, which contains the original user's username.  Is there a way to log ALL commands within syslog with something akin to the following syntax:  ${TIME/DATE STAMP}: [${REAL_USER}|${SUDO_USER}]: ${CMD}   An example entry would be:  Sat Jan 19 22:28:46 CST 2013: [root|ksoviero]: yum install random-pkg   Obviously it doesn't have to be exactly the above syntax, it just has to include a minimum of the real user (eg. root), the sudo user (eg. ksoviero), and the full command that was run (eg. yum install random-pkg).  I've already tried snoopy, but it did not include the SUDO_USER variable. $\nabla U=0 \implies U=\mathrm{constant}$ only if $U$ is defined on a connected set?