Ysgrifennodd Scott Haneda:
I have been looking at stock photo sites lately, started wondering how they
are doing their keyword searched. Given a potential for millions of images,
each with x keywords, I have come up with two approaches...
snip /
Is this the sort of thing you're looking
Ysgrifennodd Jason Pruim:
Okay, so I have been gooling all over trying to figure this out. I'm
sure it's easy enough to do, but I can't seem to find it.
All I want to do is figure out the difference between 2 fields. IE:
Field 1= 20
Field 2 =10
Difference between Field 1 2 is: 10
Any ideas?
Ysgrifennodd Onur:
Hi Peter,
Please check phpMyAdmin Configuration file ( for Port addr ) .
Thanx
Onur
Hi Onur,
You didn't mention the file name; and as I mentioned I'm a useless
sysadmin. However, I poked about a bit and came up with this (below).
I hope it's what you wanted:
Ysgrifennodd Peter Bradley:
Ysgrifennodd Onur:
Hi Peter,
Please check phpMyAdmin Configuration file ( for Port addr ) .
Thanx
Onur
Hi Onur,
You didn't mention the file name; and as I mentioned I'm a useless
sysadmin. However, I poked about a bit and came up with this
(below). I hope
I haven't been into phpMyAdmin for a while, but when I tried today I got
the error:
|#2002 - The server is not responding (or the local MySQL server's
socket is not correctly configured)
This error message didn't seem to tie in with anything on the MySQL
site, which gives:
|
Error: |2002|
Ysgrifennodd Tomás Abad Fernández:
I dont know why thease don't work at MySql 3.21 , anyone can help me to make
this compatible with mysql3?
$query = SELECT * FROM facturas WHERE pedido IN (SELECT orders_id FROM
orders WHERE user_id='.$user.') ORDER BY factura_id;
Thanks for all.
If I
Bruce,
Try:
SELECT DISTINCT NAME
FROM DOG
WHERE STATUS != 3
Should do the trick.
You obviously don't want the STATUS field. If you include it, you'll
get more than one line per name. Similarly for ID. If you want to
include the STATUS or ID fields, then you obviously want more than one
Ysgrifennodd goose:
However how do I tell it to select JUST the first 2 entries for each
channel??
Does this help:
http://dev.mysql.com/doc/refman/5.0/en/select.html
Look (on the page) for the LIMIT clause. Not sure if it's what you want.
Peter
--
MySQL General Mailing List
For list
Ysgrifennodd Philip Mather:
http://fabforce.net/dbdesigner4/ ...is pretty funky and meets the
requirements.
Phil
But had, the last time I looked, been discontinued in favour of MySQL
Workbench.
Have you (the OP, that is) tried to sort out why MySQL Workbench isn't
playing? I have it on my
Ysgrifennodd Tim McIntyre:
Thanks for the responses guys however I was running out the door
yesterday and I oversimplified my problem. Sorry about that, let me
try again.
Here is my status_histories table with some data:
id order_id code
type
Ysgrifennodd Tim McIntyre:
I tried that Peter and for some reason it's still selecting the oldest
date not the newest??? Seems odd? Also I'd really like to just select
id because I'll be using this in a subselect.
Thanks!
Tim
SELECT s1.order_id
FROM status_histories s1
WHERE s1.type =
Ysgrifennodd Tim McIntyre:
Next pint is on me Peter;-) The following turned out to be exactly
what I needed:
SELECT s1.id
FROM status_histories s1
WHERE s1.type = 'StatusHistoryOrder'
AND s1.code = 1
AND s1.created_at = (SELECT MAX(s2.created_at)
FROM
Ysgrifennodd bruce:
hi...
i'm looking at what is probably a basic question.
i have a tbl with
-id
-action
-status
-date
ie:
id action statusdate
1 0 1
1 1 2
1 2 3
-
Ysgrifennodd bruce:
hi peter.
thanks, the solution you gave me is close...!!
snip
what i really want to get is:
+--+
| universityID |
+--+
|2 |
|3 |
+--+
which would be the unique 'id's.
i've tried to do a 'limit' and group, but
Ysgrifennodd ViSolve DB Team:
Hi Renish,
If you want to capture the entries which are entered more than once.
Here's the answer for it.
mysql select * from a;
++
| b |
++
| pen|
| pencil |
| rubber |
| pen|
| paper |
| paper |
++
6 rows in set (0.00
You'll probably need to create a database first (to host the table).
This can be done most easily from the GUI MySQL Administrator tool, or
from phpMyAdmin if you have it, or from a mysql command line:
http://dev.mysql.com/doc/refman/5.0/en/create-database.html
To create a table use the
Hi,
I've installed MySQL 5.0.24a-standard on my AMD 64, SuSE 10.0 box, using
the binary distribution from the MySQL downloads site. I've also
installed the GUI tools from the same location, using the SuSE 10.x rpm
packages. The intention is to use MySQL with PHP5 and Apache. Both
these
Russbucket wrote:
I just check my install of mysql (version mysql-4.1.13-3.8 on SUSE 10.0) and
the socket is in /var/lib/mysql and the mysqld log is in /var/lib/mysql.
This is the mysql version that came with my 10.0 DVD. Did you use YAST to
install? I don't know if these locations changed with
to occur?
I'm really at the last of my tethers with this one so any help or
suggestions
will be gratefully received.
Many thanks in advance!!
Bradley Kite
Software Developer/Data Management Specialist
alchemetrics - smarter data, faster
Tel: 0118 902 9043 (direct line)
Email: [EMAIL PROTECTED
I am trying to connect from my windows box at home using mysql.exe to a
MySQL server at work on a Gentoo box.
My command line is:
mysql -h host.domain.com -u root -p
(of course the host.domain.com is replaced with my server's FQDM)
The output is:
ERROR 2003: Can't connect to MySQL server
(Forgive me if this is a cross post.)
The following setup is on MySQL 4.0.16 on Debian LINUX.
It appears as if my replication master is not logging changes to any
databases. My my.cnf is as follows:
[code]
server-id = 154
log-bin = /var/log/mysql/mysql-bin.log
- Original Message -
I would use MySQL CC (command center, I think...)... I seem to remember
someone mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on
windows xp (it's on my laptop...)
/originalmessage
I second that.
Victoria,
I just had this problem solved for me by the list. It was permissions
on the mysql/data directory. See the topic Running mysql (complete
newbie).
HTH
Peter
On Thu, 2003-07-31 at 08:50, Victoria Reznichenko wrote:
Vidhya CS [EMAIL PROTECTED] wrote:
I am this error while running
Hi guys and gals,
I'm a complete newbie to mysql, so please bear with me.
Today I downloaded mysql4.0 binary distribution and installed it on my
SuSE Linux 8.1 box. I've unzipped it and put it in:
/usr/local/mysql-standard-4.0.14-pc-linux-i686
and I've created a symbolic link to give me
. Mike
- Original Message -
From: Peter Bradley [EMAIL PROTECTED]
To: msql general mailing list [EMAIL PROTECTED]
Sent: July 30, 2003 12:50 AM
Subject: Running mysql (complete newbie)
Hi guys and gals,
I'm a complete newbie to mysql, so please bear with me.
Today I
;host=localhost with user: '' password:
'')
You might want to check the permissions on the /var/lib/mysql directory as
well. Mike
- Original Message -
From: Peter Bradley [EMAIL PROTECTED]
To: O'K Web Design [EMAIL PROTECTED]
Sent: July 30, 2003 1:03 AM
Subject: Re
Peter Bradley [EMAIL PROTECTED] wrote:
Hi guys and gals,
I'm a complete newbie to mysql, so please bear with me.
Today I downloaded mysql4.0 binary distribution and installed it on my
SuSE Linux 8.1 box. I've unzipped it and put it in:
/usr/local/mysql-standard-4.0.14-pc-linux-i686
data
chgrp -R mysql data
in the mysql directory. Obviously you need to have a mysql user, and
this lets that user, and only that user write to the data directory, or
even enter it for that matter (besides root of course).
HTH!
-Nick
On Wed, 2003-07-30 at 01:19, Peter Bradley wrote:
Hi
and later executions it would not accept this password. Any help would
be appreciated.
Thank you,
--
William Bradley
http://www.catholicmissionleaflets.org
-
Before posting, please check:
http://www.mysql.com/manual.php
0.0 0.4 1672 pts/1 S 23:24 0:00 grep mysql
If anyone can help put order into my disorder over all this, it will be truly
appreciated.
Thank you,
Bill.
--
William Bradley
http://www.catholicmissionleaflets.org
-
Before
When I import data from the text file I exported out of Access it works
correctly except that MySql seems to append and/or prepend some sort of
mystery character to the fields it imports. So, I can get the data into the
database, but I can't get it out (since the SQL statement can't match the
Message-
From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com]
Sent: Wednesday, November 06, 2002 12:34 PM
To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: RE: Problem importing data from Access
This is incorrect.
!google new line character linux windows
;arctic.ro]
Sent: Wednesday, November 06, 2002 1:02 PM
To: Schroeder, Bradley (Contractor); 'Black, Kelly W [PCS]';
[EMAIL PROTECTED]
Subject: Re: Problem importing data from Access
Hi,
You must use a HEX editor to see this characters which are not printable.I
use DOS NAVIGATOR...it's free and you
From suggestions I received on this mySQL list I installed phpMyAdmin
from the Mandrake 8.2 CDrom, which is the system I am running.So I am
presuming that there are a number of members on the list using
phpMyAdmin.
When I use the following command in a browser, phpMyAdmin starts up and
then
Thank you for all the replies to my MySQL question above. They have been most
helpful.
Bill.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
At the moment I have Mysql installed and understand command line entry
of data, or entry via a text file. Either way, it is difficult,
especially if you have been used to data entry screens. Is there a
utility somewhere that would allow me to do this? Failing that, is it
possible to write a html
OS: Win2K
MySQL: 3.23.51
What: CREATE TABLE
Problem:Column specification not honoring NOT NULL specifier.
CREATE TABLE PFPBaseRequest
(
# Uniquely identify this record
id INTEGER NOT NULL AUTO_INCREMENT,
trx_type
Your patience please :) I am an absolute newbie. When I setup Mysql
I made some mistakes and now I can't seem to get out of them.
When I login as root and type mysql on the command line as root, I get
the following:
[william@localhost william]$ su
Password:
[root@localhost william]# mysql
permissions within the
dbase directory and the permissions for all files is mysql:mysql.
Any suggestions or tips (maybe I'm just being stupid here) would be greatly
appreciated. Thanks very much.
Bradley Brown
-
Before posting
Thanks very much.
Bradley
Gurhan Ozen wrote:
Hi Bradley,
Use perror program to see what the error code means..
# perror 28
Error code 28: No space left on device
Seems like you ran out of space..
Gurhan
-Original Message-
From: Bradley Brown [mailto:[EMAIL PROTECTED
directory of the ihtml system. Nothing, however, seems to work.
If anyone can help me figure this out I would greatly appreciate it.
If you need more info or example dsn's let me know.
Thanks all,
Bradley Brown
-
Before
Hello all,
I'm attempting to migrate a postgresql dbase to a mysql dbase and
was wondering if anyone had any general tips or suggestions... maybe a
tool or script or link that may be of some help.
I greatly appreciate any info anyone may have. Thanks
Bradley
schema from one dbase to another as I'm doing
now with a portgresql dbase that supports a timestamp with time zone type.
I would also be interested in any info anyone can provide on this subject. Thank you
very much.
Bradley
Rob wrote:
I'm curious about how MySQL deals with time zones.
Our
Everytime I try to setup an odbc connection from a windows 2000 to a sun
unix box which is the sql server host is get the following error:
...Host '%-.64s' is nto allowed to connect to this MYSQL server.
Any ideas???
_
Join the
Howdy,
I'm trying to write a select statement that produces a SUB COUNT of column
PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd
like to do this in one statment with GROUP by LOCATION_T.ADDRESS,
LOCATION_T.CITY without altering the outer select. This sort of thing is
Sorry, for some reason, the select statement was cut off. Here is the
complete statement (below):
Thanks,
Brad
I'm trying to write a select statement that produces a SUB COUNT of column
PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd
like to do this in one statment
I have been using MySQL for approximately 6 months now on Solaris 2.6/2.7
and have never had a problem installing from source and compiling, but have
never been successful in installing a binary distribution.
In particular, after untarring the files using (GNUtar), after changing
permissions,
i get this error when starting MySQL
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
/var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql.
Brad.
_
Get Your
Hello everyone.
I have hit a snag trying to compile mysql 3.23.38. After running
this configure command:
CFLAGS=-O3 -mpentiumpro CXX=gcc CXXFLAGS=-O3 -mpentiumpro
-felide-constructors -fno-exceptions -fno-rtti ./configure
--with-berkeley-db --with-libwrap --with-named-z-lib
49 matches
Mail list logo