On Mon, 04 Oct 2010 16:11:08 -0400
kalin m wrote:
>
>
> what i'm trying to do is update the column only of one of those times
> isn't yet passed. and it works. except sometimes...
>
> like these 2 unix times:
>
> this was in the table under unix time: 12862162385941345...
>
> this 1286216
Hi
Find attached the first of my queries, I require to be checked over. Let me
know if you need any more information, I've included the query, EXPLAIN
output, and the relavant SHOW CREATE TABLE
Regards
Neil
On Mon, Oct 4, 2010 at 9:50 PM, Neil Tompkins
wrote:
> I've got a fair few number of qu
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my application, the values in the rating field are
changed.
Greetings,
I am attempting to set up permissions on DB with the following code from the
terminal on Mac OS 10.6
logged into mysql with a user that has access to the mysql database
GRANT SELECT ON pet_calendar.* TO username@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
I can get the u
Hi Steve
Your statement will allow you to SELECT from any table in the pet_calendar
database. You need to add INSERT, UPDATE, DELETE, CREATE etc to your GRANT
statement. If you would like to have a super user, just GRANT ALL
Mike
- Original Message -
From: "Steve Marquez"
To: "
hi Steve,
after you login with the new account , you can use the command
show grants;
to check which permission had been already granted to this account as below.
mysql> show grants;
+-+
| Grants for r...@localhost |
+
On Fri, Oct 1, 2010 at 12:24 PM, Jake Peavy wrote:
> All,
>
> I have a number of routers which report in with various stats
> periodicially. This period is not a regular interval and can drift based on
> other factors. Each router drifts independently. The stats the routers
> provide need to b
I don't think I'd seriously consider the max() option, especially if you're
expecting the table to grow large. Using a table to store the next record
number (your last_used_record_nums table) is a technique that is fairly
commonly used. You can increment and retrieve the value atomically if you
u
> How can we get our MySQL db upgraded to this version or greater ?
You can also find these at:
http://dev.mysql.com/downloads/
Cheers,
Craig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
