Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)

Deva, hmm... this is mysterious. This might also be an OS bug. If you have the .err log from other crashes, please send it to [EMAIL PROTECTED] Best regards, Heikki Tuuri Vice President, server technology Oracle Corp. - Original Message - From: Devananda [EMAIL PROTECTED]

Triggers

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

Re: selecting from 2 tables

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

Re: Triggers

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

Re: Distance between Zip codes

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

databse design and table join problems

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

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 do have at the moment 3 querys!: # get table1_id SELECT table1_id from ... WHERE ID = ... # delete dependent entry DELETE FROM $DB.$T5

Re: deleting rows in 2 tables

- Original Message - From: Merlin [EMAIL PROTECTED] To: mysql@lists.mysql.com 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

Re: deleting rows in 2 tables

Rhino wrote: - Original Message - From: Merlin [EMAIL PROTECTED] To: mysql@lists.mysql.com 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

Re: Distance between Zip codes

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) +

Re: Duplicate column error when creating view on 5.0.13

[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]

Re: users are always the last to know :-)

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,

Charset issue

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