On 19.04.2013 06:49, Kapil Karekar wrote:
snip
Though I would recommend not using such names. Some poor guy working
on your application six months down the line is going to wonder why
his queries are failing, spend a day trying to figure out and will
post the same question again to this list
Hello Richard,
the count(*) for each week of 2013 so that I end up with:
http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html
Ilya.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Fri, Apr 19, 2013 at 8:24 AM, Richard Reina gatorre...@gmail.com wrote:
Hello All,
Happy Friday! I know how to do the following query:
select count(*) from sales where WEEK(sale_date)=15 AND
YEAR(sale_date)=2013;
But can someone tell me I can do a query that will give me:
the count(*)
Perfect! Thank you Larry et all.
Have a great weekend.
2013/4/19 Larry Martell larry.mart...@gmail.com
On Fri, Apr 19, 2013 at 8:24 AM, Richard Reina gatorre...@gmail.com
wrote:
Hello All,
Happy Friday! I know how to do the following query:
select count(*) from sales where
Hello All,
Happy Friday! I know how to do the following query:
select count(*) from sales where WEEK(sale_date)=15 AND
YEAR(sale_date)=2013;
But can someone tell me I can do a query that will give me:
the count(*) for each week of 2013 so that I end up with:
WEEK | COUNT
1 | 22
2
Hello,
nbsp; I want to place an order in your store,and i will like to know if you
ship to Australia and my method of payment will be credit card.so please let me
know if you can assist me with the order ,And please do not forget to include
your web page in your replying back to my mail.I
Hi all.
In a specific MySQL installation of 5.6.10 using InnoDB tables, I
am observing unusual memory consumption patterns. The memory
usage is growing constantly - even beyond the physical memory
limits. The entire on-disk storage is 41 GB (uncompressed), yet
memory usage is happily growing
Hello,
Try to use tuning-primer.sh: this scripts reads your variables and prints
memory size you need for that.
Here is example of its output:
MEMORY USAGE
Max Memory Ever Allocated : 2.86 G
Configured Max Per-thread Buffers : 1.80 G
Configured Max Global Buffers : 2.10 G
Configured Max Memory
What's the STATUS value of Threads_running? If it really is ~60-100
connection threads, then there could be any of a few temp allocations for the
queries. Some allocations are per-subquery.
5.6 has a lot of new tricks for optimizing certain subqueries -- such as
testing out all possible
