hi,
I think the following link would be some help for you!
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
Leo Huang
2006/2/14, Octavian Rasnita <[EMAIL PROTECTED]>:
>
> Hi,
>
> From: "Rhino" <[EMAIL PROTECTED]>
> ...
> > > I need to extract a list which the followin
On Tuesday 14 February 2006 00:28, Ravi Kumar wrote:
> Permission denied 060213
I assume you are starting MySQL NOT as root..
Has the user write permissions on the directory and the socketfile?
--
Peter M. Groen
Open Systems Development
Klipperwerf 12
2317 DZ Leiden
T : +31-(0)71-5216317
M
Hi,
MySQL 5.1.6-alpha, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that no
Scott,
>I'm sure this type of problem is run up against all the time, and I'm
>wondering what the best practice methodology is from experienced DBA's.
It looks like the kind of problem database schemas are meant to
_avoid_.
>From your description it seems you have ...
part (
partID PRIM
I was just running some queries to get an approximate time that they
will run, and i saw this in the bottom left corner:
6 rows fetched in 0.0167s (0.4119s)
What do the two numbers mean, and why are they so different? I couldn't
find this in the help documentation.
thanks.
--
http://www.do
To my knowledge the only way you can do this is by running 2 daemons on
the same host. You can easily do this with the 'mysqld_multi' script that
comes with mysql.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Mon, 13 Feb 2006, Rob Gormley wrote:
> Short of running two MySQL instan
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances when the RFQ has an
invento
On Monday 13 February 2006 23:03, Ravi Kumar wrote:
> I have been noticing following message during mysql startup.the
> installation was fine.
>
> 060213 16:40:58 mysqld started
> 060213 16:40:59 InnoDB: Started; log sequence number 0 43655
> 060213 16:40:59 [ERROR] Can't start server : Bind on
I've just spent the last couple of hours trying various queries to get the
result you want. I'm afraid I didn't find an answer for you. I think I
understand exactly what you want but I couldn't figure out how to write the
query you need.
Unfortunately, I'm using 4.0.15 and I don't even have su
I have been noticing following message during mysql startup.the installation
was fine.
060213 16:40:58 mysqld started
060213 16:40:59 InnoDB: Started; log sequence number 0 43655
060213 16:40:59 [ERROR] Can't start server : Bind on unix socket: Permission
denied
060213 16:40:59 [ERROR] Do
All,
I have been tasked with setting up DR between two different sites. Is there
a favorite tool or GUI that someone could recommend for this task?
Regards,
Alan L. Fisher
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
"Brian Menke" <[EMAIL PROTECTED]> wrote on 02/12/2006 09:20:32 PM:
> I have a table with about 2000 entries with names and other data.
Ultimately
> I'm going to make a database backed web site with this and I want to
provide
> existing users with random id's that they will use for their password
PS, I have forgotten to tell that I am using MySQL 5.
Thank you.
Teddy
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Monday, February 13, 2006 10:00 PM
Subject: Re: selecting min, max
> Hi,
>
> From: "Rhino" <[EMAIL PROTECTED
Hi,
From: "Rhino" <[EMAIL PROTECTED]>
...
> > I need to extract a list which the following values from this table, for
> > each hour (in date_time field):
> >
> > - symbol
> > - min(price)
> > - max(price)
> > - price where date_time is the earliest for that certain hour.
> > - price where the dat
Anyone have any ideas on this one?
Many thanks.
RobL
On Friday 10 February 2006 15:07, Rob Lacey wrote:
> Running as root.
>
> RobL
>
> On Friday 10 February 2006 14:55, sheeri kritzer wrote:
> > Are you running the startup script as root, or is it setuid?
> >
> > -Sheeri
> >
> > On 2/10/06, Rob
Al Sparks <[EMAIL PROTECTED]> wrote on 13/02/2006 16:11:49:
> Basically, I'm new to mysql (or to any database for that matter).
>
> I have an old version installed on my linux machine. I thought, as a
> learning exercise I'd take 2 files (tab separated tables) load them
> into mysql and then mer
Basically, I'm new to mysql (or to any database for that matter).
I have an old version installed on my linux machine. I thought, as a
learning exercise I'd take 2 files (tab separated tables) load them
into mysql and then merge or join them.
So what are the steps? The first thing I tried was t
Octavian,
I need to extract a list which the following values from this table, for
each hour (in date_time field):
- symbol
- min(price)
- max(price)
- price where date_time is the earliest for that certain hour.
- price where the date_time is the last from that hour.
- The sum of volume from
oops! I hit SEND before I was done. (BAD FINGERS!)
SELECT *
FROM movies
LEFT JOIN director_movies
ON director_movies.movie_id=movies.id
LEFT JOIN director
ON director_movies.director_id = director.id
LEFT JOIN country_movies
ON country_movies.movie_id=movies.id
LEFT JOIN country
Hi,
I'm not very good at encoding either, but from what I understood, the client
specifies the encoding expected from the database,if you do a show variables
like '%char%', you will have a line character_set_client. In your case this
is probably set to latin_1.
If this is the case, mysql is s
Peter Brawley <[EMAIL PROTECTED]> wrote on 02/12/2006 03:40:52
PM:
> Jessica,
>
> Your first query, with inner joins, fails with the error message
>
> Unknown column 'movies.id' in 'on clause
>
> because the query inside parentheses in ...
> ...
> FROM movies
> INNER JOIN (director INN
Hi Ben, all!
[EMAIL PROTECTED] wrote:
Hi,
I have two different servers each running mysql. One is a SuSE and the other
a FreeBSD system.
mysql --version returns:
mysql Ver 12.22 Distrib 4.0.26, for portbld-freebsd5.4 (i386)
mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)
On the SuSE
MySQL List,
With the off list help of a member of this community, I have solved
the issue of accessing my database data from within PHP. It was an issue
related to PHP's register_globals setting.
However, the encoding issue remains. I've taken the text that
pertains only to that, and r
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To:
Sent: Monday, February 13, 2006 9:07 AM
Subject: selecting min, max
Hi,
I have a table with the following fields:
symbol, date_time, price, volume
I need to extract a list which the following values from this t
Hi,
I have a table with the following fields:
symbol, date_time, price, volume
I need to extract a list which the following values from this table, for
each hour (in date_time field):
- symbol
- min(price)
- max(price)
- price where date_time is the earliest for that certain hour.
- price where
Has anyone run into a problem with setting the root user password in mysql
using mysqld_safe with the '--init-file' option that contains the new
password for startup?
What I'm seeing after I issue the kill command for the 'host.pid' file and
then restarting 'mysqld_safe --init-file', is a short
We are running mysql on a Debian system, so we shouldn't have any of
those windows problems. It's really quite confusing, there were no
mysql errors when we noticed the problem.
The only guess we currently have is to wait until it happens again, and
make sure we dump the stats to further investig
st of features and fixes: http://www.upscene.com/news/20060213.htm
Database Workbench supports:
- Borland InterBase ( 4.x - 7.x )
- Firebird ( 1.x, 2.0 )
- MS SQL Server/MSDE ( v6.5, 7, 2000, 2005, MSDE 1 & 2, SQL Express )
- MySQL 4, 4.1, 5.0
- Oracle Database ( 8i, 9i, 10g )
If you exper
If you are running MySQL on Windows, then I'm wondering
whether you are having a problem with running out of
available ports, for clients to connect to MySQL on.
This may be your problem:
>From the manual, 2.3.16. MySQL on Windows Compared to MySQL
on Unix
***
MySQL for Windows has proven it
In article <[EMAIL PROTECTED]>,
Steve Lefevre <[EMAIL PROTECTED]> writes:
> For posterity, this is how I solved the problem:
> To create an abitrary for the ORDER BY clause, create a field like this:
> SELECT
> FIELD( field,
> "arbitrary sort string 2",
> "arbitrary sort string 3",
> "arb
30 matches
Mail list logo
