question

Where do you run the verify programs from? Are they ran from the command prompt? Do I copy the keys? Thanks - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger

Re: Off Topic: Search in this list not are functioning

On Fri, Jun 04, 2004 at 10:33:27AM -0300, Renato Cramer wrote: > I tried search numerous times and not get: either return all messages or > neither. > > Is one known problem? The search box in the sidebar was simply not going to the right place. This has been fixed. Thanks for the report. Jim W

Re: Trouble with Query

I think you want to try 'having mo.date IS NULL' after the order by. Daren wrote: I'm query for a list of offers from a table, but am trying to do a Left Join on the table that keeps track of which members have completed which offers (so that the query will not return offers that the member has alr

Re: Backing Up a Database

On Fri, 4 Jun 2004 18:16 , Lou Olsten <[EMAIL PROTECTED]> sent: >For the time I've been testing, I've used the procedures outlined in the help to take >my backups, which entails doing a FLUSH TABLES WITH READ LOCK in my MySQL monitor, then going to a shell prompt and executing the mysqldump u

RE: vpopmail installed on MySQL Client

Hello List: I had posted this message on vpopmail list but no one can help. I am posting this message on MySQL hoping that someone on this list is using vpopmail & MySQL!!! Please consider me a newbie in the area of LINUX, MySQL, vpopmail, etc. I have setup two servers as follows: (1) A master

Backing Up a Database

For the time I've been testing, I've used the procedures outlined in the help to take my backups, which entails doing a FLUSH TABLES WITH READ LOCK in my MySQL monitor, then going to a shell prompt and executing the mysqldump utility, then issuing the UNLOCK TABLES from my MySQL monitor. Now I'

Trouble with Query

I'm query for a list of offers from a table, but am trying to do a Left Join on the table that keeps track of which members have completed which offers (so that the query will not return offers that the member has already completed). Query: select distinct(ol.id) as id, mo.date from offers_listin

Humor: Take a break and watch something stupid ;-)

Ok, you need a break from programming. Take a look at one programmer has come up with. http://www.lebonze.co.uk/stuff/move.htm Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advice on Database Scheme

--- Jochem van Dieten <[EMAIL PROTECTED]> wrote: > David Blomstrom wrote: > > --- Jochem van Dieten <[EMAIL PROTECTED]> > wrote: > > > > "So how are you going to put Russia in both Asia > and > > Europe? How are you going to put Turkey in both > Asia > > and Europe? Egypt in Africa and Asia?" > >

Re: Replicator thread dying

On Fri, Jun 04, 2004 at 08:03:03PM +0300, Egor Egorov wrote: > Balazs Rauznitz <[EMAIL PROTECTED]> wrote: > > > > It's happened to me four times the past few weeks that in a very > > lightly used QA environment replication is dying. The symptoms are that > > Exec_master_log_pos gets stuck somewh

4.1.2 myisamchk chokes on a fulltext

Hi. I'm having this problem on 4.1.2, when I run myisamchk -o on my table I get a bunch of these lines: Duplicate key 3 for record at 56134200 against new record at 244828223 then it segfaults. key 3 is a fulltext. I tried the same thing on the same data with 4.0.14 and it worked fine, I als

Re: Speed differences between joins and subqueries?

Daniel Ek wrote: Hi all, I am wondering if anyone have any knowledge if there is speed difference between joins (inner | outer | left | right) and subqueries. Would I actually gain preformance using subqueries (new since 4.1) against using the "old" joins? Would be interesting to hear comments

Re: Replicator thread dying

Balazs Rauznitz <[EMAIL PROTECTED]> wrote: > > It's happened to me four times the past few weeks that in a very > lightly used QA environment replication is dying. The symptoms are that > Exec_master_log_pos gets stuck somewhere, while Read_Master_Log_Pos > gets incremented as the master has ne

RE: average in Group By

If buyrate and quantity are per row fields then SELECT symbol, ((sum(buyrate*quantity))/sum(quantity)) as average from portfolio group by symbol; Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Shan

Re: average in Group By

On Fri, Jun 04, 2004 at 09:25:58AM -0700, Shantanu Oak wrote: > I am trying to find average price of the shares in the > portfolio table. > I thought something like this should work... > SELECT symbol, ((sum(buyrate*quantity))/quantity) as > average > from portfolio group by symbol; > > It does w

average in Group By

Hi, I am trying to find average price of the shares in the portfolio table. I thought something like this should work... SELECT symbol, ((sum(buyrate*quantity))/quantity) as average from portfolio group by symbol; It does work, but wrong results. What is the correct query? Shantanu Oak

Re: Force the use of an index

"Jeff McKeon" <[EMAIL PROTECTED]> wrote on 04/06/2004 16:52:48: > Is there a way to force the use of a specific index when issuing a > select querie? Yes. From the Fine Manual "As of MySQL 3.23.12, you can give hints about which index MySQL should use when retrieving information from a table. B

RE: Advice on Database Scheme

Hi, Can I ask what you used to render that .gif ? Looks like phpMyAdmin but I have never seen that feature in phpMyAdmin.. Thanks, Andrew -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday 04 June 2004 16:19 To: David Blomstrom Cc: [EMAIL PROTECTED] Subj

Re: update SQL

At 11:28 -0400 6/4/04, Bob Lockie wrote: Rows matched=1 but rows changed=0. :-( What is wrong with my query? mysql> update records, audit_log, audit_log_records -> set records.name=audit_log_records.name, -> records.type=audit_log_records.type, -> records.content=audit_log_records.co

Force the use of an index

Is there a way to force the use of a specific index when issuing a select querie? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update SQL

On 06/04/04 11:28 Bob Lockie spoke: Rows matched=1 but rows changed=0. :-( What is wrong with my query? mysql> update records, audit_log, audit_log_records -> set records.name=audit_log_records.name, -> records.type=audit_log_records.type, -> records.content=audit_log_records.content

Replicator thread dying

It's happened to me four times the past few weeks that in a very lightly used QA environment replication is dying. The symptoms are that Exec_master_log_pos gets stuck somewhere, while Read_Master_Log_Pos gets incremented as the master has new updates. There is always a max-mysqld process that

Re: Run MySQL with ANSI mode

Friday, June 04, 2004, 1:24:35 PM, you wrote: ym> Hi Victoria, ym> Am running mysql Ver 11.18 Distrib 3.23.54, for ym> redhat-linux-gnu (i386) ym> Yes. In the documentation it asked us to specify ym> option --ansi.I try to type this at the shell: ym> $ mysql --ansi ym> But not working. Beca

update SQL

Rows matched=1 but rows changed=0. :-( What is wrong with my query? mysql> update records, audit_log, audit_log_records -> set records.name=audit_log_records.name, -> records.type=audit_log_records.type, -> records.content=audit_log_records.content, -> records.ttl=audit_log_reco

Re: Checking for FK constraints only after the transaction commited ????

Leandro Melo wrote: So, is there a way to only check for the FKs constraint at the end of the transaction, and not at the rigth moment of the insert Not in MySQL. Other databases have functionality named deferred constraints, where constraint checking is deferred to transaction commit, but My

Regd Updating my Database schemas

the problem that i am likely to face is the following. We have a database in our developement server . we keep making changes to the db very often like adding few feilds , deleting etc ... now whenever i make the change in the developement server . i just do the changes in the productions serv

Re: Advice on Database Scheme

David Blomstrom wrote: I put a screenshot of my database organization online at http://www.geoworld.org/database.gif It features four tables, focusing on Continents, Nations, States and Counties. Notice that Continents and Nations share a "CCode" (continent codes) column So how are you going to pu

Off Topic: Search in this list not are functioning

Hi, I tried search numerous times and not get: either return all messages or neither. Is one known problem? Regards, Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Self-Join Query

Perhaps I got my syntax wrong. IF() has been available since 3.23 as far as I know. I find it more readable than case if I'm only doing a single test, but either accomplishes what you need. Here is the documentation for CASE and IF http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html On

Re: Checking for FK constraints only after the transaction commited ????

On Fri, 4 Jun 2004 09:39:44 -0300 (ART) Leandro Melo <[EMAIL PROTECTED]> wrote: > Hi, > i`m using mysql in a j2ee application with JBoss. > For best design practices i cannot add the > foreign-keys to the tables in the same "insert" as i > add the table data. Basically, i`ll add it a few > millise

Checking for FK constraints only after the transaction commited ????

Hi, i`m using mysql in a j2ee application with JBoss. For best design practices i cannot add the foreign-keys to the tables in the same "insert" as i add the table data. Basically, i`ll add it a few milliseconds latter (in the same transaction), but anyway it`s not in the same "insert". Then, i ha

MySQL not finidng openssl/opensslv.h

I'm configuring mysql-4.0.20 source and I have openssl (OpenSSL 0.9.7d 17 Mar 2004) installed in /usr/local/ssl (default) Below is the output from a make after configuring as follows: ./configure --prefix=/usr/local/mysql --with-openssl I also tried --with-openssl --with-openssl-includes=/usr/lo

Re: Sub query on mySQL 4.0.18

Oooo...Oo. thank you very much for you information. I better migrate my database to postgres. I'll use MySQL back after MySQL 4.1 stable version released on SuSE Distro. --- Jigal van Hemert <[EMAIL PROTECTED]> wrote: > > I don#t understand why subquery on my MySQL > 4.0.18-Mas > > does not v

Advice on Database Scheme

I put a screenshot of my database organization online at http://www.geoworld.org/database.gif It features four tables, focusing on Continents, Nations, States and Counties. Notice that Continents and Nations share a "CCode" (continent codes) column, Nations and States share a NCode (nation codes)

RE: Three quick questions about using MySQL

See answers in the message below. Marc. -Message d'origine- De : Ben Clewett [mailto:[EMAIL PROTECTED] Envoyé : vendredi 4 juin 2004 10:37 À : [EMAIL PROTECTED] Objet : Three quick questions about using MySQL Three quick questions, I hope you can help me. Using InnoDB on version 4.0.18

Re: importing data

This is just my experience. But if you are doing this sort of work, it may well pay to construct your own import program. There are many ways of doing this, like parsing an email message, or using a XML/SOAP server. This will probably pay on the long run, as you can introduce filters, data che

Re: Run MySQL with ANSI mode

yau meileng <[EMAIL PROTECTED]> wrote: > I try to run MySQL with ansi mode but failed. This was > what I did: > > mysql> SET GLOBAL sql_mode='ansi'; > ERROR 1064: You have an error in your SQL syntax near > 'sql_mode='ansi'' at line 1 What version do you use? The above syntax is supported since 4

Three quick questions about using MySQL

Three quick questions, I hope you can help me. Using InnoDB on version 4.0.18 Firstly. It's possible to get information on a table. Which includes the number of rows. This returns instantly. However, if I do a SELECT COUNT(*) on the same table, this can take a number of minutes to return. (about

importing data

Hello.. Im a new sql user so if this is a common prob Please be kind Im trying to set up mysql 4.0.13 With a database that contains 60k records… The client wants to import 6 records a week With near 4mill records in a database… My problem is I don’t want to give ssh access to The machine…

Run MySQL with ANSI mode

I try to run MySQL with ansi mode but failed. This was what I did: mysql> SET GLOBAL sql_mode='ansi'; ERROR 1064: You have an error in your SQL syntax near 'sql_mode='ansi'' at line 1 Why I can't manage to change to ansi mode? Thanks: meileng

Writing MySQL setup files for ECperf

Has anyone try to setup ECperf benchmark using MySQL? Am having problem on the mysql setup files for ECperf. Anyone can provide information on this? Thank you: meileng __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. ht

Re: What does this sql query mean?

Great David, many thanks. I just solve another problem with the code. Thank you very much for the information. Now the iip is not an alias of items, the past programmer type it wrong. I was able to get all of the errors out too. Thanks -- - Louie Miranda http://www.axishift.com - Original

Re: Subscription

"Tom Murdock" <[EMAIL PROTECTED]> wrote: > Good evening, > > I would like to subscribe to MySQL mailing list. > Thank you. > If you want to subscribe to MySQL mailing list, visit http://lists.mysql.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email i

Re: What does this sql query mean?

Louie, The inner-join is just joining the two tables, shopcart and items. I think iip is an alias for items, but the alias would normally come after the name of the tiems table. Another way to write the query is (assuming iip is an alias for items), SELECT * FROM shopcart, items iip WHERE shopca

What does this sql query mean?

Hi, Im just a new comer on mysql and i was in the middle of debugging some codes that aint mine. I was stuck here. I could not figure what does this select do? Its complicated.. Can anyone help me out? select * from shopcart inner join items on shopcart.itemId = iip.itemId where shopcart.cookie