o properly execute what it needed. So if you run into this
simply check each directory within the path and make sure of it's
settings"
-Original Message-----
From: Jay Paulson (CE CEN) [mailto:[EMAIL PROTECTED]
Sent: Wed 1/11/2006 11:17 AM
To: mysql@lists.mysql.com
Subject: LO
I'm creating a file via PHP after getting information from a log file. I
create a new file for data import into a table in MySQL. For some reason now
I'm getting this error below. I have no clue what it means. I've checked the
file and it is all there and I've even changed the permissions on
I would totally agree with this. I moved from using Fedora Core 3 to SuSE 9.3
and haven't looked back. YaST is one of the best tools out there. With the
stuff you have installed it would be best just to start over with a new
install. :)
jay
-Original Message-
From: George Law [mail
I was doing some testing with our development mysql server (4.1.x) and one of
the databases died and wouldn't let me do anything not even read the tables in
the database. So I thought I would bring it down and start it back up. I
proceeded to use ./mysqladmin shutdown command which did what I
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]
Sent: Fri 1/6/2006 12:40 PM
To: Michael Stassen
Cc: Jay Paulson (CE CEN); Gleb Paharenko; mysql@lists.mysql.com; [EMAIL
PROTECTED]
Subject: Re: Help with a SELECT query
[1] The reasoning behind this: Is it relevant for a 5.0 use
e your
application which inserts data to the database explicitly determine
the type of the content (perhaps, you should add a field which will
indicate the content. I agree, that this is a superfluity, however
the speed of the query is more important).
"Jay Paulson (CE CEN)" <[EM
Below is a query I'm trying to create and the sql for the table I'm pulling the
information out of. The query is definitely not the best query out there
especially since I'm still pretty new with sql. I know there has to be a
better way of getting the information I want. A little background.
> I have no idea what you are asking, which may explain why no one has
replied
> to your question yet.
>
> I've been working with relational databases for 20 years and I've never
> heard the term "calendar table". What are you trying to accomplish? If you
> describe clearly what you are trying to d
My query below returns however many rows fit the WHERE condition, in this case
when they year, period, week is <= 2009131. In my case it is returning 11 rows
because I have 11 rows where the year,period, week is 2006XXX. However, this
is not what I want. I only need 4 rows returned to me and
> You might be able to use the CAST() function.
>
> http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html
Unfortunately our producation machine is using MySQL 3.23.x and from what I've
found the cast() function isn't available. :(
"CAST() and CONVERT() are available as of MySQL 4.0.2."
> You can cast data tyes explicitly:
> http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html
Now that is cool. Too bad we are using MySQL 3.23.x on our production box. I
can't use it. :(
> If this table is going to get large then you might find it too slow to use
> that method. Your quer
I have a strange question for you all. I've inherated some code and the way
the code works is that I can only mess with the WHERE part of a query.
Therefore, I was wondering if something like this would be possible.
WHERE where concat(year,period,week) as type int < 2007031
Note that I'm tryi
12 matches
Mail list logo
