I have a table with a list of pollutants. I have a table of locations, site
names, counties, etc. I can join the these tables together and get a list of
of all the pollutants at a site. But, what I am really wanting is a list of
all the pollutants with a integer field, zero for pollutant
I am at a higher level than that. Here is my query:
SELECT distinct emt.group_name
FROM epa.aq_ambient_nad83 aq_,
epa.aq_ambient_pollutants pol,
epa.emtb_pollutant_group emt,
epa.pollutant pt
WHERE (aq_.siteid = pol.siteid)
AND (emt.group_code = pt.ambient_group_code)
AND
Only allow your users select rights.
--ja
On Wed, 28 Jun 2006, Clyde Lewis wrote:
All,
Does MySQL have an option where the database can startup in READ-ONLY
mode? The idea is to have the server running with users connected,
but now allowing any updates to me applied to the database.
Any idea why libmysqlclient_r.so is not being created when I compile after a
configure --without-server?
I did two other boxes this morning and everything went just fine. Now this one
(RH 9) is not getting it's libraries created. The compile/install looks like
it works just fine.
--ja
--
That happens sometimes. Do a mysqladmin shutdown and then try to restart it.
It should start just fine.
--ja
On Wed, 8 Feb 2006, Michael Satterwhite wrote:
I use a local MySQL server (we're using 4.0) for development. It's been
running cleanly for months - and the configuration file has
On Mon, 24 Oct 2005 [EMAIL PROTECTED] wrote:
Martijn Tonies [EMAIL PROTECTED] wrote on 10/24/2005 10:16:21 AM:
Michael Stassen wrote:
snip
Second, no, it won't overflow:
mysql SELECT SEC_TO_TIME(60*60*24*5);
+-+
|
I have a table doing time tracking. I don't use timestamps, I use datetime
fields to record punch in times and punch out times. I have this query that
computes the amount of time between a punch in and punch out:
select SEC_to_time(unix_timestamp(TTendTime) - unix_timestamp(TTstartTime))
as
I have a table of votes with four fields, a primary key, and userID, that are
just there for tracking purposes. But then I have questionID and vote fields.
For each question, a user could pick a number of it's importance from 1 to 5.
That number is what gets stored in the vote field.
So,
I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with
boat loads of ram. They are not real busy servers but they have some pretty
good sized tables, one of them with a few million rows.
My question is, I have Nagios setup to monitor the seconds behind master on the
] jabbott]# more secondsBehind.sh
#!/bin/sh
mysql -pMYSECRET -e show slave status\G | grep Seconds
Then I have this that I run in the rc.local. This sets up a port that listens
for a connection on port 5151. I have hole open in my firewall into my dmz for
port 5151
[EMAIL PROTECTED] jabbott
I took a couple of days vacation last week and naturally the /data partition of
my database server filled up because of something I was running and had
forgotten about. So my backup guy, thinking to help out, gzipped all my .bin
logs. Now I am noticing replication seems to have stopped on my
I have two tables, cutting out the extra stuff they boil down to:
users:
userID int,
username varchar(11),
realname varchar(40)
logins:
ID int,
lastLogin timestamp
So, what I am doing is:
select user.id, username, realname, lastLogin
from users left join logins on users.id = logins.id
If we get triggers in mysql 5, couldn't you setup something like this?
--ja
On Tue, 31 May 2005, Philip Denno wrote:
I doubt you would find this feature in any database. You would have to
implement at the application code level. Basically whenever you insert
into a table have the
I have a table that the important parts look something like:
keynum int,
entryDate datetime,
amount varchar(10)
What I want to do is a query that gets me every day of the year and just has
null values for the days that don't have anything in the amount column. Is
something like that possible
It has been a rough day today. I am using mysql with coldfusion. Something
somehwere on my site is causing mysql to take up 100% of the cpu. This causes
coldfusion to lock. Is there any sort of query log I can look at to see what
queries have run in, say, the last hour? If I see what
Hello All,
Here is a problem I have been trying to debug for a few days. I had a mysql
server running for about a month. I did a mysql dump of all the tables on the
master and setup a second machine to be the slave, loading all the tables. I
set the replication stuff up in the slave my.cnf.
An answer to my own question. I have solved this problem which seems to be due
to the way mysql 4.1.7 stores it's passwords. I used the mysql function
OLD_PASSWORD to make mysql store it's passwords in the pre 4.1.x method.
Basically the syntax is:
mysql UPDATE mysql.user SET Password =
I have done some looking in the archive for this but can't seem to find
anything recent that seems to apply.
I have a brand new install of 4.1.7 on a Redhat 9 box. I compiled it with:
CFLAGS=-O3 -mcpu=pentiumpro CXX=gcc CXXFLAGS=-O3 -mpentiumpro
-felide-constructors -fno-exceptions -fno-rtti
I have heard also that it helps to keep the table with the blobs having a low number
of fields. Like just a primary key and the blob field. Have all your other metadata
in a seperate table. Especially if you are going to be occasionally doing queries of
just the metadata and don't want to
What I am trying to do is select the hostname out of a refering url. Such as:
http://www.google.com/search?hl=enie=UTF-8q=%22Third+Park+Point+Beach+Water+Contact+Advisory+Posted%3B+May+Indicate+Long-Term+Problem%22btnG=Google+Search
All I really want to get is:
http://www.google.com/
So I
Hello List,
I have done some googling around but can't find an answer to this one. Brand new box,
installed with RedHat 9 and trying to run 4.1.2. This is what I get.
--ja
[EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user mysql --log
Installing all prepared tables
040618 11:06:51
You might want to read it again. He is saying the performance and consistancy exists
in the database whereas it doesn't in a file system.
--ja
On Thu, 20 May 2004, David Blomstrom wrote:
[EMAIL PROTECTED] wrote:
Another perspective on the subject of BLOB vs.
Links.
Links are
I have an application where I serve out blobs. I store the PDF files in blob fields
for two reasons.
1. I want to make an interface where staff can upload pdf's into the server but not
actually give them access to the server. I use my code to maintain the security of
who gets to write to
On Thu, 12 Feb 2004, John Berman wrote:
Try adding some ()s:
SELECT * FROM marriage WHERE (groom_surname like (' globsurname ') or
bride_surname like (' globsurname ')) and community like (' community
')
--
--
MySQL General Mailing List
For list archives:
Got any indexes?
--ja
On Wed, 11 Feb 2004, nyem wrote:
Hello,
I have this table which stores an ever changing price of items.
CREATE TABLE shop (
articleINT(4) UNSIGNED ZEROFILL NOT NULL default '',
date DATE NOT NULL default '-00-00',
price
I have been reading and following the instructions from:
http://www.mysql.com/doc/en/Resetting_permissions.html
But, if I do:
./bin/mysqld_safe --skip-grant-tables
And then I:
mysqladmin -u root password 'mypassword'
I get:
mysqladmin: unable to change password; error: 'You must have privileges
Change your query to use BETWEEN rather that = and =.
--ja
On Tue, 11 Nov 2003, Michael Shuler wrote:
OK, I give up. To anyone out there who can help me, please explain why this
query runs slower than dirt. The table has about 1,300,000 records in it,
which is not supposed to be a big deal
I am having some compile problems too:
make[4]: Entering directory `/usr/src/mysql-4.1.0-alpha/sql'
source='sql_lex.cc' object='sql_lex.o' libtool=no \
depfile='.deps/sql_lex.Po' tmpdepfile='.deps/sql_lex.TPo' \
depmode=gcc /bin/bash ../depcomp \
gcc -DMYSQL_SERVER
Download http://cocoamysql.sourceforge.net/
It's really great. Painless install. I spent hours trying to get mysqlcc to install
and I was ending up playing the one library short game where it seems like if you
install just one more thing it will work, but then it never does. cocoamysql
I have a question about how long queries should be taking and if my server is too
small for what I want to be doing. I have a table setup to record stats from an
apache web server. I import the file currently once per month. Here is my table:
mysql describe hitStats;
Yes, it is an indexed field:
mysql explain select count(*) from hitstats where year(apacheDate) = 2003 and
- month(apacheDate) = 9;
++-+--+---+---+---+-+--+-+--+
| id | select_type | table| type |
I sent this out on last friday but I never actually saw it post to the list so maybe I
messed up the address. If this is showing up a second time, sorry.
I have a database where I want to count the number of days where a field gets to a
certain value. I am using two seperate queries to count
The trouble with this is it returns 1. It seems to pick the max value for the year
instead of by day.
--ja
On Mon, 20 Oct 2003, Franz, Fa. PostDirekt MA wrote:
Hi,
maybe I didn't understand the question wrong.
I have tried to work in the MAX(aqiNumber) into the query but I get a
I dunno, the font seems fairly fixed when I view it in pine
--ja
On Fri, 17 Oct 2003, Jerry Rocteur wrote:
Hi,
I'm new to the list and I am just wondering..
Why don't you guys use a fixed font when pasting mysql queries..
Wouldn't it better to see something like this 'Monaco font
I have a database where I want to count the number of days where a field gets to a
certain value. Right now I am using:
SELECT count(DISTINCT aqiValues.readingDate) as greenCount
FROMaqiRegions, aqiSites, aqiValues
WHERE aqiRegions.aqiRegionID = aqiSites.aqiRegionID AND
I am running it on a production server for about two weeks. So far it has been very
stable.
--ja
On Thu, 9 Oct 2003, boka wrote:
Bob Brands wrote:
No, its supported by version 4.1
MySQL 4.1 -- Alpha release (use this for new development) ... is this
stable enough to use it on
As I understand it, and I confess I am not totally sure I do, sql injection is more of
a problem in your page code than what database (/version) you run.
--ja
On Thu, 9 Oct 2003, Dwight Trumbower wrote:
Are there any SQL injection threats for MySQL less than 4.1?
Dwight Trumbower
T
Subqueries don't show up until v4.1 which I have running on one of my servers. Runs
great and I have it into production.
--ja
On Wed, 8 Oct 2003, Rory McKinley wrote:
Problem 1 : Your query contains a subquery :
SELECT MAX( plan_submission_number )
FROM 'artifacts'
WHERE product_id =
Hope I am posting to the right list. I am new here.
I have a sun system:
SunOS spot 5.6 Generic_105181-05 sun4u sparc SUNW,Ultra-4
With gcc installed:
# gcc -v
Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.7.2.3/specs
gcc version 2.7.2.3
I am trying to compile:
39 matches
Mail list logo