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
- 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
25 matches
Mail list logo