How concerned should I be about Collation?

2005-09-05 Thread Dave
onsistent. What I've done so far: I did a bit of research on what collation is by going to this web site: http://grace.evergreen.edu/mysqlDoc/manual_Charset.html But further searching via Google did not turn up any instructions for specific commands to make the changes I am looking

Merging two tables which contain passwords with different encryption methods

2005-09-05 Thread Dave
ssword fields and store them as plain text in the destination table, and then once all the user data is in, run a PHP command to run through and encrypt all the password fields with the new encryption. Is this the best approach? Any assistance is much appreciated. Thank you. Dave --

Re: Merging two tables which contain passwords with different encryption methods

2005-09-05 Thread Dave
eld to the other? Something where I, the administrator, can never see the plain text version of the password? Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Merging two tables which contain passwords with different encryption methods [SOLVED]

2005-09-06 Thread Dave
r your explanation. I can now make a plan to go forward with the merging of the user tables. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Copying data stored in different field formats from one table to another

2005-09-08 Thread Dave
her? Any assistance is much appreciated. Thank you. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying data stored in different field formats from one table to another

2005-09-12 Thread Dave
e erroneous sections of the statement in red. Am I using the wrong statement? How do I take a value from one field, such as the date, and make it into a different format for inserting into another field if the INSERT command won't accept those modifications? Dave -- MySQL General Mailing Li

Re: Copying data stored in different field formats from one table to another

2005-09-12 Thread Dave
and table, and the destination fields and table, and in all cases the collation is marked as being "utf8_general_ci". Where could this "latin1_swedish_ci" collation be coming from? Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying data stored in different field formats from one table to another

2005-09-12 Thread Dave
is the correct syntax for setting this kind of variable? Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying data stored in different field formats from one table to another

2005-09-12 Thread Dave
to me: Your SQL-query has been executed successfully (Query took 0.0002 sec) But, when I type: SHOW VARIABLES; ... it still shows: collation_connection latin1_swedish_ci Am I perhaps setting the variable in the wrong place? Globally and not locally or something to that effect? Dave -- MySQL Ge

"Operand should contain 1 column" error

2005-09-12 Thread Dave
query seems more straight forward than that, so I'm not sure if that advice applies. Any assistance is much appreciated. Thank you. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying data stored in different field formats from one table to another [PARTIALLY SOLVED]

2005-09-12 Thread Dave
scovered that to make the changes to the variables that I wanted to take hold and not be temporary, I had to use SET GLOBAL instead of just SET. Thank you everyone for your assistance. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: "Operand should contain 1 column" error [SOLVED]

2005-09-12 Thread Dave
Have you tried removing the brackets ( ) from around the fields in the SELECT part of the query? I did as you suggested and ran the query without brackets, and it worked perfectly. Thank you for the speedy and helpful advice! Dave -- MySQL General Mailing List For list archives: http

Re: "Operand should contain 1 column" error

2005-09-12 Thread Dave
INSERT takes a bunch of parameters which are specified within brackets. I thought SELECT worked the same way. The MySQL manual, while very helpful, did not, in this case, make clear to me that INSERT and SELECT behaved differently. Dave -- MySQL General Mailing List For list

Unclear on UPDATE versus INSERT, and a simple query that is not working

2005-09-15 Thread Dave
ot sure which I want to be using, and how. Any assistance is much appreciated. Thank you. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unclear on UPDATE versus INSERT, and a simple query that is not working

2005-09-15 Thread Dave
what the data was set to. But of course that's not the case. One specifies what to get, and then separately specifies what to set. Thank you for clearing that up. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Does the MySQL mailing list use MySQl to manage the mailing list?

2005-10-12 Thread Dave
What applications are used for management of this list? I like the way it is handled, and I have always been interested in having a mailing list manager that uses MySQL to keep track of members. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Does the MySQL mailing list use MySQl to manage the mailing list? [SOLVED]

2005-10-13 Thread Dave
. Thank you. That answer is very concise and helpful. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Index/Range Problem?

2008-06-09 Thread Dave
een '2008-05-01' and '2008-05-30'; +---+ | count(id) | +---+ | 85232 | +---+ 1 row in set (0.97 sec) Does anyone know what could be the cause of this or where to look next? Thanks Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Use of slave server for read only queries

2007-09-07 Thread dave
be a good use of the MySQL Proxy http://forge.mysql.com/wiki/MySQL_Proxy >. This doesn't look like it will work just yet http://forge.mysql.com/wiki/MySQL_Proxy_FAQ#In_load_balancing.2C_how_can_I_separate_reads_from_writes.3F Which is a real shame because I can't see that sqlrelay can

Corrupt full text index

2004-03-04 Thread dave
>Description: When updating a table with a fulltext index, the fulltext index becomes corrupted. The Error "ERROR 1034 at line 76: Incorrect key file for table: 'test'; try to repair it" is dislpayed. The error is not produced when there is no fulltext index. >How-To-Repeat: Downl

is mysql compatible with C++???

2003-07-17 Thread dave
Hi, is mysql compatible with c++ in linux? I cant seem to get it working any sample c++ script would do. thanks in advance. dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

C API AND MYSQL

2003-07-31 Thread dave
anyone have a good sample script of connecting mysql from C API? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow imports on Solaris 8

2003-02-11 Thread dave
be looking? Thanks Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To uns

Re: stuck

2003-02-11 Thread dave
Um - you would only ./configure if you have downloaded the source tarball - you have the linux binary so you need to follow the instructions for binary installation. DC \"J. A. Tovey\" <[EMAIL PROTECTED]> wrote: > > hi, > > i am having no end of problems with installing > mysql (any 3.23.* ver

About database design

2003-03-28 Thread dave
Where can a newbie go to learn how design and build a database quick. Thanks David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Languages

2002-03-11 Thread Dave
Does MySQL support the below languages? I can find info about character sets but I can't find info to tell me what languages map to those character sets. > Korean > Chinese ( Simplified and Traditional ) > Japanese > Canadian French > Latin Spanish > Por

Uploading Korean Data - More detail

2002-04-15 Thread Dave
abase. Can anybody shed any light on how I can do this? When I upload the file it saves as garbage. Regards Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

INSERT INTO ..... SELECT

2002-04-30 Thread Dave
one rows gets inserted. If I take out the ASPVariable and only have values from TableB in the SELECT it works fine. Will MySQL not allow me to mix variables with table values with this INSERT? Cheers Dave -- INSERT INTO TableA (ColumnA, ColumnB, ColumnC) SELECT

Re: INSERT INTO ..... SELECT

2002-05-01 Thread Dave
This was resolved by adding an auto-increment column. MySQL does not seem capable of coping with the situation below. - Original Message - From: "Dave" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 5:36 PM Subject: INSERT INTO .

Exporting Data from web page

2002-05-07 Thread Dave
. Can't find any info online, in lists or in my MYSQL book. Regards Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this t

NOW()

2002-05-13 Thread Dave
Not sure this is a MySQL problem or an ASP issue so apologies if it's OT. Code in ASP Page : Dim intWeekID objRSWeekID.open "SELECT WeekID FROM WeekControl " & _ " WHERE WeekStart < NOW() AND WeekEnd > NOW()", objConn intWeekID = objRSWeekID("WeekID") This fails to bring back a v

Re: NOW()

2002-05-13 Thread Dave
Big apologies. The path to my connection file was wrong, so I was looking at the wrong database. *shuffles to the corner in embarrassment. - Original Message - From: "Dave" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 12:02 PM Subject: N

SQL Help Needed

2002-05-23 Thread Dave
I have 2 tables Users (UserID) History (UserID, WeekID, Points) When a User record is created a record is inserted into History with the current WeekID, so for example data could be : Users History -- - 1 - 10 - 1 - 20 - 1 - 30 - 2 - 40

Re: SQL Help Needed

2002-05-23 Thread Dave
only exist for WeekID = 2, other for 1 and 2 and so on. Cheers Dave - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Dave" <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 6:21 PM Subject: RE: SQL

Growing memory usage/processes

2002-07-03 Thread Dave
always? I don't really like seeing this runaway with all my memory. On the other hand, CPU load is incredibly low. Inserting about 1.5 million records never hit more than about 30% load. The machine is a dual P3 1000Mhz with 1GB of RAM. Any ideas? Thanks!

Re: Growing memory usage/processes

2002-07-03 Thread Dave
Thanks for the confirmation Dan, I will look a little closer but I could have sworn when I shutdown MySQL about 300MB of memory got freed. I had a suspicion the case was one process and ps/top could not distinguish...I just needed to hear confirmation of it I guess. -Dave > In the l

Support for multiple data directories under a single server

2001-07-27 Thread dave
r multiple locations. Any ideas? Thanks! Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL P

Re: Error From Web Site

2001-09-18 Thread Dave
How do I reset the auto-increment, I have a very large value in my table, how can I reset it or make it use a number that isnt already used. The value is so large now that it wont increment. Thanks in advance Dave - Before

mysqld: immediate Segmentation fault

2001-04-19 Thread dave
>Description: I can use the binary distributions of MySQL without any problems. I'm currently using the binary distribution I got from Slackware, and it works fine. (That's the version reported by mysqlbug.) Unfortunately, binary distributions don't contain all the files necessary (such as sha

mysql.server uses fully-qualified hostname, but mysqld doesn't

2001-05-02 Thread dave
try to use safe_mysqld and ignore mysql.server :( >Submitter-Id: >Originator:Dave Kitabjian >Organization: >MySQL support: none >Synopsis: >Severity: non-critical >Priority: >Category: mysql >Class: sw-bug >Release: mysql-3.22.

tty beeps uncontrollably when hitting after mysqld

2001-05-02 Thread dave
the daemon isn't backgrounding properly. >How-To-Repeat: >Fix: Unknown. I'm hoping it doesn't present problems when I put it into my startup script. >Submitter-Id: >Originator:Dave Kitabjian >Organization: >MySQL support: none

mysqld - immediate segfault

2001-05-07 Thread dave
>Description: I've been using the Slackware mysql package, but I want to use ODBC, and MyODBC won't compile because "my_dir.h" is missing. In order to get all the headers, shared libraries, and thread support I need, I apparently have to compile MySQL from source, but I'm can't get that to work.

MySQL and c++ API

2001-05-14 Thread dave
the API MySQL++-1.7.8-1.i386.rpm but it won't install. Using the command: rpm -iv --test mysql++-1.7.8-1.i386.rmp returns: "error: failed dependencies: MySQL-server is needed by mysql++-1.7.8-1". I can't figure out what it's looking for

MySQL Connection Handle & IPC

2001-01-30 Thread Dave
...is this reasonable and can it be done?? Any ideas are appreciated... -Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: help please, help please

2006-09-01 Thread Dave Heath
I am not able to install Mysql on my 2003 server at home. error 1045!! I get an accesd denied for user [EMAIL PROTECTED] I need the full error, but have some questions: 1. Are you sure that you set a root password? 2. Are you using the command line client or some other administrative tool?

Re: Mysql pushing data to client

2006-09-28 Thread Dave G
Thanks for pointing that out, I'll go with James solution. David Godsey > David Godsey wrote: > > I am looking for a way to write a client program that will wake up when > > there is new data in the database, much like replication. > > > > So instead of my client pulling the database on some f

mysql and MH_DYLIB error message

2005-08-08 Thread Dave Viner
cause they are generated by a big set of automake macros. thanks dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQLquery: delimiter // - #1064 error

2005-11-29 Thread Dave Kennedy
Windows XP phpMyAdmin 2.7.0-rc1 MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED] The DELIMITER statement works in the command line, but not in phpmyadmin (see error below) mysql> DELIMITER // mysql> use mysql // Database changed mysql> PHPmyadmin === DELIMITER

Best way to search all columns for any occurance of criteria

2005-12-16 Thread Dave Ariens
tName varchar(30) email varchar(75) campus varchar(75) year varchar(4) When the user enters search criteria I want all records where there is an identical match within any portion of the field. i.e. Searching for 'ave' returns all firstName's (dave), lastName's (Shaverson),

MySQL 64bit static build?

2006-01-04 Thread Dave Juntgen
) I am looking at compiling MySQL myself for an Intel Xeon EM64T box using pgcc, any insight on compiler options to get the best performance? Thank you all for you help! Regards, --Dave David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax: 260.459.6271

C API - mysql_fetch_fields()

2006-01-12 Thread Dave Weingart
hasn't been an issue in any other programs and my suspicion is that I'm clobbering memory somewhere else (but if it's as simple as me needing to allocate space for the returned pointer, then I'd like to know!) Thanks. -- Dave Weingart, Sr. Programmer/Analyst"

Signal 11 crashes on MySQL V5

2006-03-08 Thread Dave Pullin
y the same application. It seems unlikely to be a hardware problem because its on 3 machines at once. It looks like a MySQL V5 problem but I can't pin it down to anything specific enough to report a bug. Anyone had similar experiences with MySQL V5? Dave -- MySQL General Mailing List For list

RE: Aggregate functions in ORDER BY

2006-03-08 Thread Dave Pullin
n the results, make your select a subselect. select a,b,c from ( select a,b,c, COUNT(pets.pet_id) as count from etc order by count ) as subtable Dave -Original Message- From: Yasir Assam [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 9:10 PM To: mysql@lists.mysql.com Su

RE: Signal 11 crashes on MySQL V5

2006-03-09 Thread Dave Pullin
ansactions. For me, MySQL 5 on 2.4 seems to be less unstable than on 2.6, although I'm getting TomCat hangs on 2.4, but that's another story and may be hiding MySQL instability. Dave -Original Message- From: Ady Wicaksono [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 20

RE: Aggregate functions in ORDER BY

2006-03-09 Thread Dave Pullin
lto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 11:10 PM To: Dave Pullin Cc: mysql@lists.mysql.com Subject: Re: Aggregate functions in ORDER BY Many thanks for that Dave. Do you know whether it's possible for MySQL to return fully qualified column names by default? For ex

Indiana Time Zone Issues

2006-03-28 Thread Dave Juntgen
, --Dave David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax:   260.459.6271     -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Thread Memory Usage

2006-04-04 Thread Dave Juntgen
Hello all, I am looking for a way to view the max values that have been used by all threads or a signal thread for read_buffer, read_rnd_buffer, sort_buffer, and net_buffer. I want to know these values so that I can turn them appropriately. Regards, --Dave David W. Juntgen Medical

newbie config help needed

2009-01-31 Thread Dave Stevens
Will read directions if necessary.... Dave * Your server must have the following MySQL grant privileges (for tables): SELECT, INSERT, UPDATE, DELETE, DROP, ALTER, CREATE * Your MySQL server must not be running in Strict mode. -- Canada must refuse to be entangled in any more wars foug

MySQL Bin Log Position C API

2009-11-13 Thread Dave Juntgen
using S servers: Q->S if S:binpos > M:binpos then Q->S // Slave has executed master bin pos and can be queried. Else Q->M // fallback fi Thanks! --Dave David W. Juntgen Medical Informatics Engineering Inc. 6302 Constitution Drive Fort Wayne, IN 46804 Phone: 260.459.6270

RE: Are Ubuntu 64-bit /var/lib/mysql/ibdata (etc) compatible with 32-bit ??

2010-10-15 Thread Dave Sparks
> We have a PSE05 "Master" and PSE06 "Slave" (PRODUCTION servers) both > are > Ubuntu 32-bit. > We have a third slave PSE07 which is Ubuntu 64-bit. This is our 'live > backup' so to speak. We take mysqld down daily on there and tarball the > /var/lib/mysql and /var/log/mysql as snapshots (since mys

Recovering INNODB table

2011-03-11 Thread CLOSE Dave
dropping the entire data base and recreating? If I did that, would the mysqldump of the remaining tables allow me to restore most content? -- Dave Close -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

query mystery: union de-optimizes component queries

2011-08-26 Thread Dave Dyer
Why would using UNION cause the subqueries to be de-optimized? explain (SELECT count(gamename) as gname ,variation from zertz_gamerecord where (gmtdate > date_sub(current_timestamp(),interval 90 day)) and (player1='13213' or player2='13213' ) group by variation limit 3) shows using index on

a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
This is a cautionary tale - adding indexes is not always helpful or harmless. I recently added an index to the "players" table to optimize a common query, and as a consequence this other query flipped from innocuous to something that takes infinite time. select p1.player_name,g.score1,g.tim

Re: Re: a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
> > >Can you post the EXPLAIN EXTENDED output for your before and after queries? >also, have you recently run an ANALYZE TABLE on the tables? // before mysql> explain extended select p1.player_name,g.score1,g.time1,g.color1,p2.player_name,g.score2,g.time2,g.color2,g.gamename,gmtdate -> f

a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
BTW, the query on the database with the added index doesn't take forever, it takes a mere 51 minutes (vs. instantaneous). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
BTW, the query on the database with the added index doesn't take forever, it takes a mere 51 minutes (vs. instantaneous). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

a lesson in query writing and (maybe) a bug report

2011-08-27 Thread Dave Dyer
The "innocuous change" was to add an index for "is_robot" which is true for 6 out of 20,000 records and null for the rest. My complaint/question/observation is not how to optimize the query that went awry, but to be alarmed that a venerable and perfectly serviceable query, written years ago and

Re: utility of an index

2011-08-30 Thread Dave Dyer
At 12:43 AM 8/30/2011, mysql-plain-digest-h...@lists.mysql.com wrote: >Not useful to add an index for that. I also wonder why the value is null >(meaning: unknown, not certain) for almost all records. It depends on if you want the forest or the trees. A frequently executed query asks for just t

running a duplicate database

2011-09-09 Thread Dave Dyer
Is there a halfway house between a single database and a full master-slave setup? I have a database with one "piggish" table, and I'd like to direct queries that search the pig to a duplicate database, where it won't affect all the routine traffic. I could definitely do this by setting up a

RE: need list of country ISO code to demonyms

2012-10-03 Thread Dave Stevens
Quoting Daevid Vincent : HA! No $hit! Well isn't that clever. I didn't know that you can highlight a table like that, and paste it into Excel. That darn Microsoft -- they think of everything! :) Hell, don't give them ideas! They'll be trying to patent cut and paste... D

loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
x27;),('About','main-column','some text ... ... more text ...'); /*!4 ALTER TABLE `text_for_pages` ENABLE KEYS */; The value created in the database is just 'some text ... ' Cheers, Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
Thanks for the reply, and I apologize because I expect I've broken threading. The list isn't mailing the posts to me, so I've nothing to reply to. I've had to cut and paste from the web archive... >>>> 2014/01/06 12:18 +, Dave Howorth >>>> >>

Seeking assistance with recurring MySQL crash during nightly dumps

2007-11-14 Thread Dave Hunt
our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. You may contact me via reply e-mail or at my phone: 801-733-5333, where I am available 8:00 a.m. - 11:00 p.m. daily. Thank you, Dav

MYSQL db no-no: deleted root permissions (smile)

2008-02-10 Thread Dave Sampson
Hey folks, As with many lessons in linux world it takes a big oop for a big lesson. system: gentoo OS webmin/virtualmin frontend I was trying to apply permissions to usetrs so they can only access certain DB's. This involved removing the associated user permissions from the permissions list and

Re: Index/Range Problem?

2008-06-10 Thread Dave Raven
Hi, Thanks for the help; that makes sense I think you guys are right. Is it worth tuning such a thing? It seems to me like it would be much faster to use the index? Thanks again Dave > Dave schrieb: >> Hi all, >> I've been trying to optimize some of our queries against

SQL select basics

2008-10-17 Thread dave aptiva
error "# - Invalid use of group function " I also tried SELECT ID_number, count( CU_number ) AS CC FROM MyTable GROUP BY ID_number WHERE CC = max( CC ); But this also causes an error, anyone able to offer some pointers am I able to use sub queries ? Thanks Dave.

SQL select basics

2008-10-17 Thread dave aptiva
error "# - Invalid use of group function " I also tried SELECT ID_number, count( CU_number ) AS CC FROM MyTable GROUP BY ID_number WHERE CC = max( CC ); But this also causes an error, anyone able to offer some pointers ? Thanks Dave.

Strange result from multiple JOIN

2007-05-25 Thread Dave Dyer
I'm trying to construct a join, but the effect I want seems to be impossible to achieve. In this schema, the "uid" field is unique in the "players" table, but not in the "ranking" table (one player per uid, multiple rankings per player) I want to select player names and rankings for a particila

Re: Strange result from multiple JOIN

2007-05-28 Thread Dave Dyer
Thanks, it turns out you are exactly right. I rewrote the query to keep the "on" immediately following the "left join" and it now works as I wish. I'll have to read up on "cross join", but if there is a mysql bug here, it is that the parser that what I wrote as "left join" was turned into a cro

Re: Strange result from multiple JOIN

2007-05-29 Thread Dave Dyer
I'll defer to you. At 01:00 PM 5/28/2007, Baron Schwartz wrote: >Dave Dyer wrote: >>Thanks, it turns out you are exactly right. I rewrote >>the query to keep the "on" immediately following the "left join" >>and it now works as I wish. >>I

jdbc with a UDF

2007-06-05 Thread Dave G
ll be appreciated. I searched on google and only found where another person had the same problem, but no solution. Dave G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: jdbc with a UDF

2007-06-05 Thread Dave G
t; > - michael > > > On 6/5/07, Dave G <[EMAIL PROTECTED]> wrote: >> I'm getting what appears to be a java reference back from values I >> return >> from a UDF. The values appear find using php, and in the mysql client. >> The result looks something lik

optimization help

2007-06-27 Thread Dave G
I have a table in my database (currently) that grows to be huge (and I need to keep the data). I'm in a redesign phase and I'm trying to do it right. So here are the relevant details: The table has several keys involved: mysql> desc data__ProcessedDataFrames; ++-

Re: optimization help

2007-06-27 Thread Dave G
D payload_time > 11808.74704 AND payload_time < 1180564096.24967; What I'm concerned about is with how much data I will eventually have, even scanning over the KEYS will take a long time. Thanks Dave G. BTW: heres the giant query that I use. SELECT E.product_id,

Re: optimization help

2007-06-27 Thread Dave G
I do, but I don't see any way around that with the data I have. Dave G. > Good Afternoon David > > sounds as if you have a number of non-unique indices (even possibly FTS!) > slowing down queries..this should help you concentrate on the slower > indices > mysql> >

Revised optimization question

2007-06-28 Thread Dave G
I asked a question yesterday that was quite onerous, so I have been working out some of the details today, and would like to re-post my question under a different light. I have a table called data__ProcessedDataFrames that can grow to be gigantic, and I need to speed up the query for pulling the d

Group wise maximum

2007-06-28 Thread Dave G
ta | mediumblob | YES | | NULL| | ++--+--+-+-++ 6 rows in set (0.00 sec) mysql> This table can get quite large so I'm trying not to query on it twice to get the MAX(payload_time) < ptime. Obviously what I have is not the group-wise maximum I was hoping for. Dave G. -- MySQL Ge

Dynamic ORing

2007-07-10 Thread Dave G
Hello all, I'm trying to do some processing on the front end to optimize my query on the backend. I would like to generate a list of id's for this query like so: SELECT REPLACE('3,4,5,6,7,8,9',',',' OR element_id=') INTO @tmp; Then use it like: mysql> select @tmp; +

Re: Dynamic ORing

2007-07-10 Thread Dave G
Thank you Baron, I'll give that a shot, and thanks for the IN() list tip ... much appreciated. Dave > Hi Dave, > > Dave G wrote: >> Hello all, >> >> I'm trying to do some processing on the front end to optimize my query >> on >> the backend.

Re: Dynamic ORing

2007-07-10 Thread Dave G
Prepared Statements with the IN function worked beautifully. Performance is slightly degraded, but I get the functionality I want and can live with the slight performance hit. Thanks again. Dave > Hi Dave, > > Dave G wrote: >> Hello all, >> >> I'm trying to do

Sum() unequal number of rows

2005-03-06 Thread Dave Kennedy
SELECT sum(col1) AS total1 FROM t1 GROUP by col1 SELECT col1, sum(col2) AS total2 FROM t2 GROUP by col2 Table t1 contains 4 rows to sum for each value in col1 Table t2 contains 8 rows to sum for each value in col2 If one select statement is used, the result has 8 rows and total2 is corre

Oracle to MySQl conversion

2005-03-19 Thread Dave Goodrich
CLOB to BLOB. Just don't want to duplicate the effort. Thanks, DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Binary install instructions wrong?

2003-12-17 Thread Dave Best
Hey all, I don't like the default locations that mysql tries to install into.. I like putting stuff in user accounts, with a version directory. Easier to maintain, yada yada. Anyways, as per the instructions you have to change a path in ./bin/mysqlaccess I did this but when I run the script

Re: Binary install instructions wrong?

2003-12-18 Thread Dave Best
and those who don't." - Original Message - From: "Dave Best" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 17, 2003 11:57 PM Subject: Binary install instructions wrong? > Hey all, > > I don't like the default locations that mys

Newbie Question - can I collapse these two queries into one line?

2003-12-29 Thread Dave G
t how to do that, I'm at a loss as to how to describe where my thinking is going wrong. Any help would be much appreciated. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Newbie Question - can I collapse these two queries into one line? [SOLVED]

2003-12-30 Thread Dave G
m expecting. > That's because you were being inefficient. :) Thanks for taking the time to respond! My script is working now! -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Storing mysql dates as an integer

2004-01-07 Thread Dave G
for this purpose? Any tips would be greatly appreciated. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Storing mysql dates as an integer

2004-01-07 Thread Dave G
the format you describe. I want to know if there's any problem storing a UNIX timestamp purely as an integer in my MySQL database. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Storing mysql dates as an integer [SOLVED]

2004-01-08 Thread Dave G
#x27;m only using it for events and people signing up for those events, so all the dates should be clustered around the present time. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

[BUG] SHOW INDEX bug for fulltext indexes in MySQl 4.0.17

2004-01-23 Thread Dave Rolsky
FULLTEXT | | +---++--+--+-+---+-+--++--++-+ Sub_part should be NULL for both of these columns. The same thing happens for a single column fulltext index. -dave /*=== House Absolute Consulting www.houseabso

  1   2   3   4   5   >