Re: a newserver would be better than this mailing list , 1 moretime

.. David Wolf p.s. PLEASE can you put a [mysql] tag on the list??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

DBase to MySQL

I am attempting to create a link from a dbase (.dbf) database to a mysql database. Here's the description: dbase file is a file that gets updated on a daily basis. Changes to this file can be a change in a record or the addition of a record. no record is 'deleted'. Updated/new records include

Query help

I need to replace some data with data from a backup. Here's the scenerio... I have 2 databases. a and abak a and abak are the same (but, ones a few hours old with the right data ;) ) a and abak have a table, posts and a field 'attach'. I'd like to take the data from abak.posts.attach and place

Re: MySQLGUI hangs on certain commands

Yes.. It is the windows version of MySQLGUI that I am using. Windows 2000 SP2 David - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, November 03, 2001 4:14 AM Subject: Re: MySQLGUI hangs on certain command

Strange results from query

I'm using the following query SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice FROM archive a, archive b WHERE a.status='s' AND a.addrdsp IS NOT NULL AND a.addrdsp = b.addrdsp AND a.solddate < b.solddate AND date_add(a.solddate, interval 1 year) > b.solddate ORDER BY a.add

Re: Optimizing query (2nd attempt)

4 | log.topicId | 1 || +++---+-+-+-+--- --++ 4 rows in set (0.00 sec) It's just simply not using the index on users.. Did I miss something? David - Original Message - From: "Bill Adams" <[EMAI

Re: Optimizing query (2nd attempt)

Not quite fixed.. When I run the query without limiting by time, it still fails to use the userid key. i.e. if I only select where users.username="testuser", I'd expect that users.username to return the users.id=2, and to search using the indexed log.userid=2 David

Re: Optimizing query (2nd attempt)

- From: "Tore Van Grembergen" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 8:57 AM Subject: Re: Optimizing query (2nd attempt) > maybe you heva to declare a compound index with userid and userna

Re: Optimizing query (2nd attempt)

How do you do a compound index to index between two tables? David - Original Message - From: "Tore Van Grembergen" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 8:57 AM Subject: Re: Op

Re: Optimizing query (2nd attempt)

Yes.. There is an index on users.username :) David - Original Message - From: "Tore Van Grembergen" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 8:46 AM Subject: Re: Optimizing query

Optimizing query (2nd attempt)

I have a query as follows: SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid, LEFT(from_unixtime(log.logtime),19) AS time, log.ip FROM log LEFT JOIN users ON log.userid = users.

MySQLGUI hangs on certain commands

I've been trying to play with MySQLGUI lately (running the win32 version of the GUI, Linux version of the server). I can connect fine. Run queries fine. But, when I try to do any grants on a database or edit a table, the client connects to the server as many times as it can (before the server runs

Optimizing queries

I have a query as follows: SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid, LEFT(from_unixtime(log.logtime),19) AS time, log.ip FROM log LEFT JOIN users ON log.userid = users.

Re: MySQL for Dummies (newbies)?

I actually find the command line databases way easier to use than graphical ones. You have more direct control over them, and they are leaner/faster than GUI based ones. However, there are GUI based admin tools that you can get from the MySQL website so you can feel more 'at home'. I was a *real*

Re: Query help...

Thanks!! Worked like a dream! I'm not quite sure why it knew to pull only ip's that are in there more than once though? David - Original Message - From: "Steve Meyers" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; "Steve Meyers

Re: Query help...

7;t give what I want :( David - Original Message - From: "Steve Meyers" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 2:38 PM Subject: RE: Query help... I think you're looking fo

Re: Query help...

David - Original Message - From: "David Hugh-Jones" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 6:19 PM Subject: Re: Query help... > > Try > SELECT lastip,use

Query help...

he wrong way.. But, I can't quite get a clue. Can anyone help me out here? Thanks! David Wolf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th