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
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 List,
Table structure:
mysql> DESCRIBE FlightRoutes;
+-++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-++--+-+-+---+
| EntryID | char(36) | NO | PRI | NULL| |
| Dep | varcha
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
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;
> +-++
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
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
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
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
