You could also try it this way, and then in the application, you can find
out what the dates are, that they are between.
SELECT YEARWEEK(`datefield`) AS 'week',
COUNT(`visits`) AS 'visits'
FROM `mytable` WHERE YEAR(`datefield`) = '2009'
GROUP BY YEARWEEK(`datefield`);
(this was just tak
I downloaded a MySQL script that backs up all my databases
automatically which looks to work amazing. My question is in this
particular script (linked below) there is a section to add a user name
and password for someone who has access to the databases I am
attempting to backup with the script. Now
Neil,
I would start with something like this, assuming the date column is called "d":
SELECT
FROM
GROUP BY d - INTERVAL DAYOFWEEK(d) DAY;
- Baron
On Thu, Apr 29, 2010 at 8:12 AM, Tompkins Neil
wrote:
> Hi
>
> We need to produce a query to return the total number of user visits between
> two
group by week(yourdate) ?
On Thu, Apr 29, 2010 at 2:12 PM, Tompkins Neil wrote:
> Hi
>
> We need to produce a query to return the total number of user visits
> between
> two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29.
> My question is how can I compute the totals for
Chris,
The index on (Dep, Des) is not a full-text index. If you use SHOW
CREATE TABLE, I think this becomes much easier to see at a glance.
- Baron
On Thu, Apr 29, 2010 at 8:10 AM, Chris Knipe wrote:
> Hi List,
>
> Table structure:
> mysql> DESCRIBE FlightRoutes;
> +-++
Hi
We need to produce a query to return the total number of user visits between
two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29.
My question is how can I compute the totals for each week within a query ?
for example
2009-04-29 to 2009-05-06 100 visits
2009-05-07 to 200
Hi List,
Table structure:
mysql> DESCRIBE FlightRoutes;
+-++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-++--+-+-+---+
| EntryID | char(36) | NO | PRI | NULL| |
| Dep | varcha
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.0.1 Pro "
Version 4 introduced full Unicode support, 4.0.1 fixes some issues
found in that initial release, like MySQL Stored Procedures/Functions
me
Hi Carlos,
I would say the below grants for a user to perform backup is the minimum
grants which we can provide..
grant select , lock tables, file on *.* to backup_user'@'localhost'
identified by 'somepassword';
Thanks
Anand
On Wed, Apr 28, 2010 at 10:28 PM, Carlos Mennens wrote:
> I download
