Hi,
The difference in the behaviour of browser interpratation might only be on
Style sheet/CSS file. So the improperness might be of PHP. So better trace
the 'insert' or check the method. If it is GET method, sure the length is
a constraint and there may be chance for data to get eliminate
On Wednesday 27 December 2006 17:12, Ashley M. Kirchner wrote:
> Chris Comparini wrote:
> > Try something like this:
> >
> > select hour(time) as the_hour, avg(temp_f) as average_temp_f
> > from data
> > where time > now() - interval 24 hour
> > group by the_hour;
>
> Thanks Chris. Questi
Chris Comparini wrote:
Try something like this:
select hour(time) as the_hour, avg(temp_f) as average_temp_f
from data
where time > now() - interval 24 hour
group by the_hour;
Thanks Chris. Question though, why is it that when I change that to
48 hours, it only gives me 24 results (s
On Wednesday 27 December 2006 16:24, Ashley M. Kirchner wrote:
>[...]
>
> I want to display a graph for the last 24 hours by averaging each
> hour. Since I get (at most) 60 readings per hour, I need to average
> them out to get a number for that hour. Do I have to do this averaging
> outside
Hi All,
I have a table that's described as follows:
++---+--+-+---++
| Field | Type | Null | Key | Default |
Extra |
++---+--+-+-
FYI
-- Forwarded message --
From: Juan Eduardo Moreno <[EMAIL PROTECTED]>
Date: Dec 27, 2006 9:30 PM
Subject: Fwd: innodb_log_files_in_group
To: [EMAIL PROTECTED]
Dave,
The default (and recommended) is 2. The log files, save the trasactions into
file in circular order. This fil
Is there any benefit/reason to set innodb_log_files_in_group to
something other than 2?
Thanks,
ds
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If the problem is browser-dependent, then it isn't a MySQL problem. I don't
know what is going on, but have found that IE handles failing controls in a
non-standard way. My issue was with "button" controls, but if I were you I
would take a very close look at the REQUEST data.
Regards,
Jerry Schwa
You do not absolutely need a primary key, but I suggest you add an
auto-increment primary key anyways. When you start coding your PHP
application, you may find that you need to identify a specific record and
this auto-increment field will be your way to do that.
Regards,
Jerry Schwartz
Global Inf
On Wednesday 27 December 2006 18:45, Matt Neimeyer wrote:
> We recently started getting reports that when users access our PHP based
> CRM system that it "didn't work". After much debugging and tracking down it
> looks like that ultimately what's happening is that SOMETIMES with a
> statement like.
We recently started getting reports that when users access our PHP based CRM
system that it "didn't work". After much debugging and tracking down it looks
like that ultimately what's happening is that SOMETIMES with a statement
like...
INSERT INTO Customers (A,B,C) VALUES ("One","Two","Three")
wow 30GB is a lot of data. Do let us know what kind of hardware / OS
you are using.
In the past I have worked with larger tables then these, but I was
using Objectivity DB running on UltraSPARC 64bit architecture.
--
Saqib Ali, CISSP, ISSAP
http://www.full-disk-encryption.net
--
MySQL General M
Hi,
In our opinion, you can opt any or all of these:
a) Build indexes; or rebuild indexes with REPAIR TABLE
b) Take Periodic backup(mysqldump) based on the importance of the data.
Clear the current table on specific condition.
c) If clearing the table affects the transactions that depends on
13 matches
Mail list logo
