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,
arbitrary sort
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
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 experience any problems
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
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
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
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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
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 INNER JOIN
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
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
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
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
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 merge or
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 Lacey [EMAIL
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 date_time is the last
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]; mysql@lists.mysql.com
Sent: Monday, February 13, 2006 10:00 PM
Subject: Re: selecting min, max
Hi,
From: Rhino [EMAIL
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 passwords.
I
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:
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]
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
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 unix
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
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
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.
--
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 PRIMARY
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
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,
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 following values from
30 matches
Mail list logo
