hi all.
Here is the suituation. i've installed mysql 4.1.12 on WinXP
plantform, it seems not to support Chinese by its default
configuration, say, Chinese can't be displayer propely. as far as i
know, what i need to do is modify the charset(server, connection,
client...)concerned, but i'm not so su
Hi Walt,
On Sat, 2005-10-08 at 13:19, Walt Weaver wrote:
> Well, forgive me for being a bit skeptical and cynical but this sounds like
> spin to me.
>
> As a 17-year Oracle DBA I have never seen Oracle do anything that can
> remotely be called benevolent. Larry Ellison buys companies, guts them,
[EMAIL PROTECTED] wrote:
Does this make better sense?
Yes, many thanks and regards,
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think it was your formula that I finally got to work as I needed.
Excuse the Lasso in here :
-sql=('SELECT b.zip, b.state,b.storename, b.address1, b.address2, b.city,
b.state, b.zip,
ROUND((3956 * (2 * ASIN(SQRT(
POWER(SIN(((a.lat-b.lat)*0.017453293)/2),2) +
COS(a
Rhino wrote:
- Original Message -
From: "Merlin" <[EMAIL PROTECTED]>
To:
Sent: Sunday, October 09, 2005 1:31 PM
Subject: deleting rows in 2 tables
Hi there,
I am wondering if there is a possiblity to delete rows in more than one
table with one query.
At the moment I am doing
- Original Message -
From: "Merlin" <[EMAIL PROTECTED]>
To:
Sent: Sunday, October 09, 2005 1:31 PM
Subject: deleting rows in 2 tables
> Hi there,
>
> I am wondering if there is a possiblity to delete rows in more than one
> table with one query.
>
> At the moment I am doing this:
>
> I
Hi there,
I am wondering if there is a possiblity to delete rows in more than one
table with one query.
At the moment I am doing this:
I do have at the moment 3 querys!:
# get table1_id
SELECT table1_id
from ...
WHERE ID = ...
# delete dependent entry
DELETE
FROM $DB.$T5
Hi,
I have the following tables: ( some in Microsoft Access and some in
Excel ) and I want to migrate the data into MySQL and develop an
interface in PHP for easy administration and control.
*1) Sales Representative Code
*sr_id INTEGER ( unique )
sr_user VARCHAR
sr_name VARCHAR
sr_email
Don't forget that you're not caclucating "driving distance", but
"great circle" distance, which is roughly a straight line over short
distances. If you radius is great than, say 50 miles, people might
complain that the actual driving distance is much greater than the
straight line distance you pro
I have never written a trigger in MySQL but I've done a number of them in
DB2 so, assuming the same principles apply to both:
I think the problem is that you are attempting to make the triggered
action - the UPDATE or INSERT - occur in the same table (or a join involving
the same table) as the one
thx worked great..
Nurullah Akkaya What lies behind us
and what
[EMAIL PROTECTED] lies before us are tiny matters
Registered Linux User #301438 compared to what lies within us.
WARNING all messages "If at first an idea is not
containing att
I am trying to use triggers for the first time with MySQL 5.0. I have read
the manual but I am not understanding why I would run into the following
problem.
I created the following triggers:
CREATE TRIGGER UpdPopCoord AFTER UPDATE ON locations FOR EACH ROW
UPDATE locations, zipcodes
SET locations
12 matches
Mail list logo
