I have a log file that captures data from various sensors every minute that
we use to draws graphs on our website.
The table looks like this:
CREATE TABLE `log` (
`id` int(14) NOT NULL auto_increment,
`VarName` varchar(255) NOT NULL,
`TimeString` datetime NOT NULL,
`VarValue` decimal(25,6
I don't suppose I am the first to notice this, but most of
the pages on dev.mysql.com have been listed by google
as "attack pages", e.g http://dev.mysql.com/downloads/.
Has there been a problem, or is google being overzealous?
Thanks!
-Mike
I have been struggling with this issue most of the day. I can get the result
I need by using 2 queries, but that takes way too long. I'm trying to see if
there is a way to get the same result within a single query.
Here's the table
CREATE TABLE `log` (
`id` int(14) NOT NULL auto_increment,
`Va
Scott,
Thanks. That appears to be the solution.
Albert
On Fri, Jan 22, 2010 at 10:42 AM, Scott Swaim wrote:
> I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change
> in
> the logic for the Joins. I determined that the FROM clause needs to be in
> parenthesis.
contactinfo.ContactTypeID =2
Error: Unknown column 'person.PersonID' in 'on clause' (1054)
There are several of these type scripts and all are giving a similar error.
The server version is 5.0.87. I suspect the hosting company may have
upgraded to a new version of mysql.
Thanks.
Albert
pdata' for update in FROM clause
What can I use to fix this?
|
--
Albert E. Whale, CHS CISA CISSP
Sr. Security, Network, Risk Assessment and Systems Consultant
ABS Computer Technology, Inc. <http://www.ABS-CompTech.com&g
Is there a limit of connections (open and close) that mysql can carry? or a
limit by second?
I have a big memory crash (double free or corruption) in my program and I
smell that it could be mysql,
thanks a lot,
Albert
How do I change:
| collation_connection| latin1_swedish_ci
|
| collation_database | latin1_swedish_ci
|
| collation_server| latin1_swedish_ci
to latin1_bin?
Is this in my.cnf? or is this another way to do this?
--
Albert E. Whale, CHS CISA CISSP
Sr
T 50
Thanks.
Al
On Oct 31, 2006, at 4:01 PM, Albert Padley wrote:
Dan,
On Oct 31, 2006, at 3:41 PM, Dan Buettner wrote:
Albert, it seems like the first query could be simplified, like so:
SELECT id, subject, updated FROM mrldisc
WHERE updated > SUBDATE(NOW(), INTERVAL 48 HOUR)
ORDER
Dan,
On Oct 31, 2006, at 3:41 PM, Dan Buettner wrote:
Albert, it seems like the first query could be simplified, like so:
SELECT id, subject, updated FROM mrldisc
WHERE updated > SUBDATE(NOW(), INTERVAL 48 HOUR)
ORDER BY updated DESC LIMIT 50
This query won't work. The table
I have a query that works and returns the correct results. However,
it is very slow ( 6-12 seconds on 5000 row table). Since this table
will grow to several hundred thousand rows very shortly, I am worried.
Here is the query that works:
SELECT id, subject, updated FROM mrldisc WHERE (id IN (
On Sep 15, 2006, at 12:56 PM, Chris W wrote:
Albert Padley wrote:
I have the following query that has worked fine for displaying
standings for a soccer league.
SELECT * FROM standings WHERE division = 'BU10' AND pool = '1'
ORDER BY tpts DESC, spts DESC, w DESC, ga
I have the following query that has worked fine for displaying
standings for a soccer league.
SELECT * FROM standings WHERE division = 'BU10' AND pool = '1' ORDER
BY tpts DESC, spts DESC, w DESC, ga ASC, team_number ASC
As I said, works fine. Now, however, the league wants a slightly
diff
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
my firewall is off and I know it is not the port becuase when I configure it
as 'anonymous" it works like a charm. Please help me
---
Keith,
I agree that would be a good option to change the table.
Unfortunately, that's not an option at this point. I don't control
the schema. Thanks for the suggestion anyway.
Albert Padley
On Jun 14, 2006, at 3:59 PM, Keith Roberts wrote:
Hi Chris.
I cannot see how it c
Dan,
Thanks. I'll take a further look at GROUP_CONCAT.
Albert
On Jun 14, 2006, at 1:16 PM, Dan Buettner wrote:
Albert, MySQL's GROUP_CONCAT function might work for you:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
In your case something like this:
SEL
m trying to come up with a query to return all the `values` of a
single userid in a single row. I've checked my books, the manual and
tried every type of join I can think of without success. I'd
appreciate some direction.
Thanks.
Albert Padley
--
MySQL General Mailing List
For l
Sol and Peter,
Thanks for your feedback. Both of your suggestions got me going in
the right direction and I was able to solve the problem using
temporary tables and left joins.
Thanks again.
Albert Padley
On Jul 23, 2005, at 11:00 AM, sol beach wrote:
create table count_temp1 select
hing. I can't change the table structure because I have
simplified it here for finding a solution. The above columns are part
of a much larger table that is currently in use for other purposes.
Thanks.
Albert Padley
--
MySQL General Mailing List
For list archives: http://lists.m
eason by sum
(`points`) as total_points. How would I find the total goals scored
against a team in the context of the query below?
Thanks.
Albert Padley
On Jul 11, 2005, at 1:13 PM, [EMAIL PROTECTED] wrote:
SELECT `coach`
, sum(`standingpts`) as standings
, count(`game_id`
_home
Specifically the =3,1,0 in the first line and the = 'H',1.0 in the
second line.
Thanks.
Albert Padley
On Jul 11, 2005, at 1:13 PM, [EMAIL PROTECTED] wrote:
SELECT `coach`
, sum(`standingpts`) as standings
, count(`game_id`) as games
, sum(if
ER BY losses
I would think this would be a fairly common issue. However, I don't
know enough to even know where to start looking. How do I accomplish
this?
Thanks.
Albert Padley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, Jun 06, 2005 at 04:19:16PM -0500, Dan Nelson wrote:
> In the last episode (Jun 06), Albert Chin said:
> > I'm trying to build mysql-4.1.12 on HP-UX 10.20 with gcc-3.4.3. HP-UX
> > 10.20 has CMA threads.
> >
> > I have the following build failure:
> >
def os_thread_t os_thread_id_t;
So, gcc is complaining about the cast from cma_t_handle to ulong. What
should I do?
--
albert chin ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Feb 17, 2005, at 10:34 AM, [EMAIL PROTECTED] wrote:
Albert Padley <[EMAIL PROTECTED]> wrote on 02/17/2005 12:08:31 PM:
> I have the following 2 tables:
>
> CREATE TABLE `division_info` (
> `id` int(11) NOT NULL auto_increment,
> `division` varchar
I have the following 2 tables:
CREATE TABLE `division_info` (
`id` int(11) NOT NULL auto_increment,
`division` varchar(50) NOT NULL default '',
`spots` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `division` (`division`),
KEY `spots` (`spots`)
) TYPE=MyISAM
CREATE TABLE `team_
computing the standings (10
game_pts and 15 total_ref_pts). Make sense?
Albert
On Oct 22, 2004, at 11:46 AM, Juan M. Quiroz wrote:
I have some questions.
Is the information on those fields used as their true value? Meaning
are
you always have to manipulate the data, then why not enter the correct
Jeff and Shawn,
Thanks for coming up with similar solutions. Jeff, I have used yours
because it was more complete. I wasn't aware of the Case statement in
mysql. I guess I still have a lot to learn.
Thanks again.
Albert
On Oct 22, 2004, at 10:10 AM, Jeff Burgoon wrote:
This will solve
Nothing? Not even a "You're out of luck?"
Thanks.
Albert
On Oct 21, 2004, at 9:48 PM, Albert Padley wrote:
I've inherited a problem for a youth soccer league. Their standings
are computed by adding 3 columns (game_pts, ref_pts and
adjust_ref_pts) together. However, the
is important to know also.
Unfortunately, I don't have the luxury of being able to change the
table structure.
Using mysql 4.0.18
Thanks.
Albert Padley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the best version of PHP to use with MySQL on Win32 to
interact with the MySQL database in web-enabled forms with submit
button?
Thank you for your help.
Albert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Does anyone know what prompt the message below to be sent by the list?
I have now been getting a few of these and cannot figure out why.
Thanks for any input
Uma
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 11:39 AM
Subject: No valid command
OK I think I got it, in Win32 it has to be done from the mysql client screen
and not from the command prompt.
Either that or use another GUI client as the front end for MySQL I guess and
I have had some suggestions on that one.
I will try doing so. Thanks for the help
Albert
- Original
o the
calculations there rather than in the DB itself.
Anyway this is a long answer to your response but I wanted those who read
this to get an idea of what I am working with.
Any suggestions are welcomed.
Albert
- Original Message -
From: "Fortuno, Adam" <[EMAIL PROTECTED]>
T
This is the error I get and yes uma is a user and listed in my.ini file
actually
C:\mysql\bin>SHOW GRANTS FOR uma;
'SHOW' is not recognized as an internal or external command,
operable program or batch file.
C:\mysql\bin>
Albert
- Original Message -
From: "F
ather than in the DB itself.
Anyway this is a long answer to your response but I wanted those who read
this to get an idea of what I am working with.
Any suggestions are welcomed.
Albert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Matthew (UK),
I have two questions regarding this:
1. are you using the tick that is under the ~ sign on US keyboards, or the '
which is under the " quotes on US keyboards?
I tried both and get an error executing the following query in mysql client
gui screen
GRANT ALL mysql.* TO US
When I enter :
mysql\bin>SHOW GRANTS FOR uma;
I get a response that show is not a command etc..
This is on Win32 version 4.x
The same happens when I try it from mysql>
and also after I run mysqld
Any ideas what is wrong here?
Thanks
Albert
- Original Message -
From:
Roger,
Thanks for the additional clarification
Albert
Atlanta
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Albert" <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 8:00 AM
Subject: Re:
ather than in the DB itself.
Anyway this is a long answer to your response but I wanted those who read
this to get an idea of what I am working with.
Any suggestions are welcomed.
Albert
- Original Message -
From: "Stefan Kuhn" <[EMAIL PROTECTED]>
To: <[EMAIL P
Stefan,
Do you imply that tables cannot be sorted desc or asc based on one of the
columns e.g. a last name? or am I misunderstanding you.
Albert
Atlanta
(anyone else in Atlanta?)
- Original Message -
From: "Stefan Kuhn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
You should be able to change that ins sqlsysadmin (the traffic light) under
the section options if I remember correctly and change default 10 to
whatever you wish
Albert
- Original Message -
From: "Pam Vermeer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[E
I have a similar problem but not with the clicking but with filling out a
survey that is captured in mysql, twice.
Any help would be appreciated
Albert
- Original Message -
From: "Joseph" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 31
Can this tool be used on Windows and if so what version do I need to DL and
does it need anything else besides the software (e.g. Perl - which I see
listed for the nix versions.
Thanks
Albert
- Original Message -
From: "K Old" <[EMAIL PROTECTED]>
To: <[EMAIL PROT
splay
many this message but no any documents, reply or helpdest to explain it.
Therefore, I would like you to suggestion some guide or solutions for me.
best regards,
Albert Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
splay
many this message but no any documents, reply or helpdest to explain it.
Therefore, I would like you to suggestion some guide or solutions for me.
best regards,
Albert Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
splay
many this message but no any documents, reply or helpdest to explain it.
Therefore, I would like you to suggestion some guide or solutions for me.
best regards,
Albert Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
splay
many this message but no any documents, reply or helpdest to explain it.
Therefore, I would like you to suggestion some guide or solutions for me.
best regards,
Albert Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've read it now a few times around here and was curious what
"innodb" means. Is it a table-type for MySQL or a completely
different DBMS?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it looking in root/tmp for anything
any ideas on where to start??
Thanks
Albert
___
http://www.webmail.co.za the South-African free email service
NetWiseGurus.Com Portal - Your Own Internet Business Today!
ot;-L/opt/TWWfsw/readline42a/lib/sparcv9 \
-L/opt/TWWfsw/zlib11/lib/sparcv9 -L/opt/TWWfsw/ncurses5/lib/sparcv9 \
-L/opt/TWWfsw/readline42a/lib/sparcv9 \
-R/opt/TWWfsw/readline42a/lib/sparcv9:\
/opt/TWWfsw/zlib11/lib/sparcv9:/opt/TWWfsw/ncurses5/lib/sp
On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > $ grep SIZEOF_LONG config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> > $ grep SIZEOF_LONG incldue/my_config.h
> > #define
On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > MySQL 3.23.46 was built with the Sun C++ compiler:
> > $ CC -V
> > CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19
> >
> > It was built
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> > Yes, SIZEOF_INT is 4:
> > $ grep SIZEOF_INT config.h
> > #define SIZEOF_INT 4
> > $ gr
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> > Yes, SIZEOF_INT is 4:
> > $ grep SIZEOF_INT config.h
> > #define SIZEOF_INT 4
> > $ gr
On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > $ grep SIZEOF_LONG config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> > $ grep SIZEOF_LONG incldue/my_config.h
> > #define
On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > MySQL 3.23.46 was built with the Sun C++ compiler:
> > $ CC -V
> > CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19
> >
> > It was built
ot;-L/opt/TWWfsw/readline42a/lib/sparcv9 \
-L/opt/TWWfsw/zlib11/lib/sparcv9 -L/opt/TWWfsw/ncurses5/lib/sparcv9 \
-L/opt/TWWfsw/readline42a/lib/sparcv9 \
-R/opt/TWWfsw/readline42a/lib/sparcv9:\
/opt/TWWfsw/zlib11/lib/sparcv9:/opt/TWWfsw/ncurses5/lib/sp
as 1G, not 4.5G.
The Solaris 8 machine this is running on has 6GB real memory and
14.5GB of swap.
--
albert chin ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Hello,
I have a few questions. First I work on a very high traffic site that
uses vbulletin 1.1 to run its bb. The bb is very high traffic around
60-200 concurrent users. We are starting to run into some serious
locking issues, and I am thinking about converting the high use
tables(maby all)
You may want to check your /tmp partion. it may be creating some temp tables.
-t, --tmpdir=path
Path for temporary files. It may be useful if your default /tmp directory
resides on a partition too small to hold temporary tables.
Byron
[EMAIL PROTECTED] wrote:
> Hello All,
>
> Background
Is there a way to have SELECT return sets for rows that were grouped
together? So if I had a table like:
Table:
ID DATA
1a
1b
2X
2Y
310
320
I want to do something like this:
SELECT MAKE_SET(-1,DATA) as LIST
FROM Table
GROU
How does one tell if mysql is using BDB? Do I have to somehow specify BDB
when creating a new database? I've installed BerkeleyDB and mysql, yet it
doesn't look like it's using bdb. Unable to rollback any insert
Just started using mysql and was wondering if there's a way to specify the
autocommit mode on a per database rather on a per server. I know I can
using the BEGIN/COMMIT to turn off autocommit for a particular call. But
it would be nice to have a coarser granularity.
Thanks,
A
Hello,
I am trying to tune mysql on linux for a web based application. Reading
the docs I found thread_cache_size I checked what it was set to by
default and found that it was 0. In the docs it says That it doesn't
make much difference if you have a good thread implementation. So my
ques
I am trying to tune mysql on linux for a web based application. Reading
throw the docs I found thread_cache_size I checked what it was set to by
default and found that it was 0. In the docs it says That it doesn't
make much difference if you have a good thread implementation. So my
major question
66 matches
Mail list logo
