Re: Adding mysql to the subject line would improve clarity and ease of classification.

You can sort using the TO: field. Try filtering mail containing '@lists.mysql.com' in the recipient fields. At 17:52 Thursday 20/11/03, Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classi

Re: How to move database to new server

i think this can be done by dumping your database to a file and then fetch it to mysql cli i make a batch script to do this daily... i have not use replication, so i just copy the entire database (in windows version): c:\mysql\bin\mysqldump.exe -a -c -C -e --add-drop-table --add-locks -F -f -Q

MYSQL suddenly started crashing

Sorry, I forgot to include the version of mysql. I am running 4.0.16 from the binary archive(tar.gz) on the mysql.com download page. I did have the same problem on 4.0.15 and upgraded yesterday to 4.0.16. I was running 4.0.15 since it came out before this problem suddenly reared its ugly head yest

search engine

Hi All, say i would like to search for customer, entrying some text then i would like mysql to return all the customer which id and full name consist of the text ex: IDName John01John The Junior Abe01 Abe The Senior Jo01 Johns The Best if i enter the criteria 'john' i woul

Re: Update optimization?

UPDATE some_table SET some_field=IF(id = some_id,1,0) Have fun, Stephen - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 21, 2003 11:41 AM Subject: Update optimization? Hello guys, Let say: UPDATE some_table SET some_field=1 WHERE id = some_

RE: How to 'customize' GROUP BY?

That won't do what it looks like he wants. GROUP BY can't do that :( I wish it could. This issue recently came up for me, and I initially was using Temporary table, but then had to switch to a 'pregrouped' table so I could retrieve data properly. -Original Message- From: Peter Sap [mailt

Re: UPDATE optimization?

Hi, You can combine those 2 UPDATEs like this: UPDATE some_table SET some_field=IF(id=some_id, 1, 0); Or, the standard SQL syntax: UPDATE some_table SET some_field=CASE id WHEN some_id THEN 1 ELSE 0 END; Hope that helps. Matt - Original Message - From: <[EMAIL PROTECTED]> Sent

Re: Transaction newbie question

Hi Mike, 1. It has already been rolled back, so do a start transaction again. 2. - 3. It depends, 3 to 5 times would be reasonable. Before resubmitting the transaction wait some time (let's say half a second) to let the conflicting transaction finish. When you keep getting deadlocks, try switchin

Update optimization?

Hello guys, Let say: UPDATE some_table SET some_field=1 WHERE id = some_id and UPDATE some_table SET some_field=0 WHERE id <> some_id what I can do to merge these queries? The first thing that came up in my mind was something like that: UPDATE some_table SET some_field=1 WHERE id = some_id; SET

UPDATE optimization?

Hello guys, Let say: UPDATE some_table SET some_field=1 WHERE id = some_id and UPDATE some_table SET some_field=0 WHERE id <> some_id what I can do to merge these queries? The first thing that came up in my mind was something like that: UPDATE some_table SET some_field=1 WHERE id = some_id; SET

Re: How to 'customize' GROUP BY?

Hi Yves, You can use a having clause to work with groups: select grp, max(id) as maxid from tbl group by grp having maxid = max(id) Regards, Peter Sap - Original Message - From: "Yves Goergen" <[EMAIL PROTECTED]> To: "List: MySQL" <[EMAIL PROTECTED]> Sent: Thursday, November 20, 2003 1

Re: Adding mysql to the subject line would improve clarity and ease of classification.

Be it addressed or not in the link, there is a difference between self-configuration and system-configuration. Best Bao William Fong wrote: Wasn't this addressed already? http://lists.mysql.com/faq.php#subjectprefix -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/e

Re: Adding mysql to the subject line would improve clarity and ease of classification.

Wasn't this addressed already? http://lists.mysql.com/faq.php#subjectprefix -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "BAO RuiXian" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Thursday, November 20,

Re: Transaction newbie question

OK, I don't seem to be getting a response. Let me try to simplify: I'm running a PHP application with MySQL. I'm in a transaction involving only BDB tables. Actually the whole database has nothing but BDB tables. I attempt a query which fails with error number 1213. The full text message is s

Re: Adding mysql to the subject line would improve clarity and ease of classification.

At 10:52 -0500 11/20/03, Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! That's what mail filters are for. Here's how to set one up: http://lists.mysql.com/faq.php#su

Re: Adding mysql to the subject line would improve clarity and ease of classification.

Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -Original Message- From: adburne [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 2:47 PM To: [EM

Re: myisamchk Error 22 WinServer 2003 Large table

Hello, Further searching for this problem reveals that it was reported as a bug: http://bugs.mysql.com/bug.php?id=779 but for Version 3. Does this mean that the fix was not implemented in Version 4? What is the workaround for this? Do I have to load the table while creating the indices? Thi

Re: Adding mysql to the subject line would improve clarity and ease of classification.

I second the idea. Bao Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

Re: installing 3.23.57 with InnoDB

Fernando, maybe you are using a compiler which does not understand the inline defs in InnoDB. You can try CFLAGS="-DUNIV_MUST_NOT_INLINE" ./configure --with-innodb make If the CFLAGS do not propagate to the /innobase subdir in the source tree, try to do a separate call CFLAGS="-DUNIV_MUST_NOT

How to 'customize' GROUP BY?

Hi again... yet another question to this list that maybe someone can easily answer me... When I do a GROUP BY on a column of my query, I'll get one random row from the entire group. But how can I tell MySQL to, i.e., give me the row with the highest value of another column or so? I mean something

suddenly started crashing

Since yesterday I have noticed that mysql keeps crashing on me. At first I thought it was related to RAM, so I replaced the RAM. Problem persists, so now I am perplexed. HELP!! I am running a dual XEON 2.6ghz with 2GB ram. Linux 2.4.18-6mdkenterprise #1 SMP Fri Mar 15 02:28:20 CET 2002 i686 unkno

MySQL 4.015/4.016 doesn't store special chars, converts to '?'

Hi, does anyone know how to solve the problem with MySQL 4.015/4.016 (on Win and Linux) that converts special characters like n-dash (if you hold down ALT and press 0150 on num keys) or typographic quotes (ALT+0132, ALT+0147) to question marks? Example: INSERT INTO test SET column = '\„Hello ther

Re: Errors with MySQL

Hi Rob, My guess would be you did not see this in the Fine Manual http://www.mysql.com/doc/en/Post-installation.html or this http://www.mysql.com/doc/en/Starting_server.html Hope this helps, Ken - Original Message - From: "Rob Snow" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thur

Turn off read only in tables

I am trying to learn PHP using the tutorial for DWMX on macromedia.com. I was doing pretty good until it came time to edit a record. When I tried the page, it said the 'album' table was read only. I had copied the database files from my computer to the server so I went back and checked all the p

Query Timeout Setting?

Is there anyway to tell MySQL to abort queries that take over X seconds, or something similar? - John -- --- John May : President Point In Space Internet Solutions [EMAIL

devcom , gcc g++ win32

Hello how compiling file: mysql/sql/udf_example.cpp in devcom or mingw32 ? - error in struct UDF_ARGS and UDF_INIT; this file compilations in VC6 non error regard Rafal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

RE: Mysql server time setting.

On 19-Nov-2003 Jeff McKeon wrote: > I'm running mysql on a redhat system starting it from a script in > /etc/init.d/ as is the default with the rpm install. I can't seem to > set the timezone environmental variable to change nomatter what I put in > the /etc/my.cnf file. > > Can anyone help me w

Re: batch files usage

At 23:12 -0500 11/19/03, r.schacht wrote: Hi, I'm new to MySQL. I want to try to create a new database, but I type in the same commands all the time. What I want to be able to do is type the commands into text files, then run them from inside MySQL. This way if I want to change something I can jus

Re: strange difference between a != b and (a < b OR a > b)

Hi, >From the MySQL Manual: MySQL normally uses the index that finds the least number of rows. An index is used for columns that you compare with the following operators: =, >, >=, <, <=, BETWEEN, and a LIKE with a non-wildcard prefix like 'something%'. http://www.mysql.com/doc/en/MySQL_indexes.

need location and how to configure logs for 4.0.15-nt-log

Hey I've been looking for the log files on a mysql version 4.0.15 install on a windows 2000 box. I've looked in the config file and there is somethign for called log-bin. How do i turn on and configure logging? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-

installing 3.23.57 with InnoDB

I want to install mysql.3.23.57 (open source) in Linux, and i need to use innoDB tables i do the configure; > ./configure --with-innodb and when i do the make, i get a lot of errors in ha_innobase.cc one of them is: . . . ha_innobase.o(.text 0x554): In function `innobase_commit_low(trx_stru

RE: Cannot find an index that will be used for SELECT

Arnaud - Thanks very much for a suggestion! Unfortunately, when I do that (I'm not much of a JOIN expert ) I end up selecting ALL the rows in the table. - Ed -Original Message- From: Arnaud [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 3:19 AM To: Ed McNierney; my

Re: Why does -1 show up as 18446744073709551613?

That would be it! Not sure how I missed that. Thank you! Mark >>> Mikael Fridh <[EMAIL PROTECTED]> 11/20/03 11:44AM >>> This is in the "Upgrading from 3.23" manual: http://www.mysql.com/doc/en/Upgrading-from-3.23.html "Note: when you use subtraction between integer values where one is of t

RE: Strange behavior on insert

As far as I know, DELETE's make gaps in the table (you could remove these by optimizing). If you INSERT into a table with gaps, your INSERTed row will try to fill the gaps created by that. Maybe it works backwards in filling the gaps? -Original Message- From: Jeff McKeon [mailto:[EMAIL PRO

Re: Why does -1 show up as 18446744073709551613?

This is in the "Upgrading from 3.23" manual: http://www.mysql.com/doc/en/Upgrading-from-3.23.html "Note: when you use subtraction between integer values where one is of type UNSIGNED, the result will be unsigned. In other words, before upgrading to MySQL 4.0, you should check your application f

RE: Strange behavior on insert

I understand how to use the "Order By" clause on a select, I'm trying to better understand why does this happen on the insert. Jeff > -Original Message- > From: Dan Wilterding [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 20, 2003 11:39 AM > To: [EMAIL PROTECTED] > Subject: Re: St

Re: Adding mysql to the subject line would improve clarity and ease of classification.

On Thursday 20 November 2003 16.52, Hassan Farha wrote: > It would be great if we could put 'mysql' in the subject of our questions. > I receive mail from many different places and it would help classification. > > Thanks! All of these headers (and more) are in mails on the mailinglist: Mailing-L

strange difference between a != b and (a < b OR a > b)

>Description: a simple select on a large table does not use an indexed column when the WHERE clause uses a != b The same query using as WHERE a < b OR a > b (which of course does the same) *does* use an index. >How-To-Repeat: mysql < 1; *** actually same query, index on numbe

Re: Strange behavior on insert

On 20 Nov 2003 at 11:12, Jeff McKeon wrote: > However when I go to the database and do a "select * from tablename;" > the records are in the table in the reverse order!! > > Even the auto increment is in reverse order... > If you wish to retrieve the data in a particular order you must use "or

Strange behavior on insert

I have a PHP page that takes data from a form and inserts it into a table: Show columns: +++--+-+-+-- --+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---

Why does -1 show up as 18446744073709551613?

I've been running this query for quite some time that basically says: SELECT (A + B + C) - (X + Y + Z) AS Variance FROM . Up until now, this has been working correctly and showing up as anything from -100 to +100. Now all of a sudden, it's showing up as 18446744073709551613 instead of -1,

How to move database to new server

Hi I have a mysql database with 20 tables containing data whch i need to transfer to a new hosting server (i access this server via webmin.) What's the easiest way to move a database from one server to the other?. Can you export full databases from mysql (this would be the easiest), or do i ne

Adding mysql to the subject line would improve clarity and ease of classification.

It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -Original Message- From: adburne [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 2:47 PM To: [EMAIL PROTECTED]

temporary table always created on disk

Hi all. I alreaedy posted about this, but I get more and more confused ! My temporary tables are ALWAYS created as temporary disk tables ! Here is the query : SELECT commerces.enseigne FROM cellules INNER JOIN commerces ON (cellules.indexCelluleCommerce=commerces.indexCelluleCommerce) WHERE cellu

RE: load data in file

Are you placing the file in the same directory as the MySQL data files? Are the databases and the location you placed the text file on the same physical drive? -Original Message- From: Hans Kind [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 7:22 AM To: [EMAIL PROTECTED] Subje

Re: [SOLVED]Re: LEFT JOIN problem

* Martijn Tonies > * me > > Huh? What would be invalid about it? > > That moving parts of the WHERE clause to the JOIN clause returns > a different result set. But as I said: I don't have the full story ... oh > wait, I found the first message in my mailbox somewhere. > > I guess "OUTER" is opti

Re: [SOLVED]Re: LEFT JOIN problem

> > * Martijn Tonies > > > * Rory McKinley > > > > Thanks Roger > > > > > > > > That fixed the problem.I was under the impression that I only had > to > > > > put the linked columns n the ON and everything else in the > WHERElive > > > > an learn I guess. > > > > > > Ehm, I'm not completel

Re: load data in file

LOAD DATA LOCAL INFILE But it must be enabled on both the server and client. See the docs. Hans Kind wrote: Hi, We have a 2 server setup. 1 server runs the web server with a PHP application, the second server is the mysql database server. The php application needs to connect to the mysql server

Re: [SOLVED]Re: LEFT JOIN problem

> * Martijn Tonies > > * Rory McKinley > > > Thanks Roger > > > > > > That fixed the problem.I was under the impression that I only had to > > > put the linked columns n the ON and everything else in the WHERElive > > > an learn I guess. > > > > Ehm, I'm not completely sure, but isn't th

Re: [SOLVED]Re: LEFT JOIN problem

* Martijn Tonies > * Rory McKinley > > Thanks Roger > > > > That fixed the problem.I was under the impression that I only had to > > put the linked columns n the ON and everything else in the WHERElive > > an learn I guess. > > Ehm, I'm not completely sure, but isn't this invalid behaviour?

load data in file

Hi, We have a 2 server setup. 1 server runs the web server with a PHP application, the second server is the mysql database server. The php application needs to connect to the mysql server, to import data from a text file. For this we use Load Data Infile. While everything else in the applicati

Re: SQL [Q] how to migrate 4.0 -> 4.1

Добрый день. > > Thank you. But what is about binary fields? > > When I start mysqld-4.0.. field in table are char(x) binary. > > But when I start mysql-4.1.0 in the same table the same field is not > > binary. > > Is this bug? > > Nope. From the v4.1 BINARY means that no collation is applicable t

Re: [SOLVED]Re: LEFT JOIN problem

> Thanks Roger > > That fixed the problem.I was under the impression that I only had to put > the linked columns n the ON and everything else in the WHERElive an > learn I guess. Ehm, I'm not completely sure, but isn't this invalid behaviour? Can you post the DDL and INSERT INTO data for

[SOLVED]Re: LEFT JOIN problem

Thanks Roger That fixed the problem.I was under the impression that I only had to put the linked columns n the ON and everything else in the WHERElive an learn I guess. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who

Re: LEFT JOIN problem

* Rory McKinley [...] > SELECT a.line_number, a.category_value, IFNULL(b.parameter_trigger, 0) > FROM DB1.Table 1 AS a LEFT JOIN DB2.Table 2 AS b ON > a.category_name = b.parameter_value > WHERE a.line_type = 13 AND b.parameter_ID = 13 > > The only problem is that the query only returns the first t

Re: deleting files related to mysql

"M.D. DeWar" <[EMAIL PROTECTED]> wrote: > Hello, > in my /var/db/mysql there is a whole lot of files that have > spiderman-bin.001 all the way to 038 > Can I safely delete these files ? These are binary log files. If you don't need them, you can delete them and start server without --log-bin opti

LEFT JOIN problem

Hi List I am currently running a query that reads records from one table (Table 1) links these records to an id value in another table (Table 2) and returns the result. The tables are as follows, with sample data: Table 1in DB 1: line_number | category_name | category_value | line_type 1

Re: deleting files related to mysql

These are the InnoDB data and log files. They are there because probably you have the InnoDB feature switched on. You can delete them (all of them) safely, if you do not use InnoDB tables, but if you don't swicth off the InnoDB feature (in my.cnf for example), the system will recreate them after

deleting files related to mysql

Hello, in my /var/db/mysql there is a whole lot of files that have spiderman-bin.001 all the way to 038 Can I safely delete these files ? I also have these 25088 Sep 12 23:41 ib_arch_log_00 5242880 Nov 19 16:18 ib_logfile0 5242880 Sep 12 23:41 ib_logfile1 10485760 Nov 19 16:16 ibdat

Re: [SQL]how to delete record where I reference to other table

"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote: > Has look alot around , and tried a lot without success > > how to do this : > Delete from pproductMix PM where PM.mixID in (select ID from pmix > where mixno=72000) > > I would like a solution with and without subqueries > DELETE FROM pproductMi

Re: Easy (?) SELECT questions

[EMAIL PROTECTED] wrote: >> Mark Wilson <[EMAIL PROTECTED]> wrote: >>> Two related questions. >>> 1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get >>> a list >>> of all UNIQUE values for that field (many entries from the same day), >>> i.e., all >>> days with entries. >>> **

Re: SSL connection

Hai Daniel See this link http://www.mysql.com/doc/en/Secure_requirements.html . Hope it wil help you. Create mysql.pem and start dameon with # ./mysqld_safe --user=mysql --ssl-key=/tmp/mysql.pem --ssl-cert=/tmp/mysql.pe m --ssl-ca=/tmp/mysql.pem and connect mysql with the following option #

[SQL]how to delete record where I reference to other table

Hi Has look alot around , and tried a lot without success how to do this : Delete from pproductMix PM where PM.mixID in (select ID from pmix where mixno=72000) I would like a solution with and without subqueries thanks Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL Gen

SSL connection

Hi all, I would like to know how to set up the ssl parameters in the my.cnf file. Where can I find a complete example for this, or where is the detailed description of it in the MySQL documentation? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: Can I get Winows 4.0.15 binary..

http://downloads.mysql.com/archives.php?p=mysql-4.0&v=4.0.15 On Thursday 20 November 2003 12.15, Karam Chand wrote: > One of the my client is using the above version and he > is getting an error with my app so I would like to > test my app against this version.. > > Can I get a link to 4.0.15 > >

Re: Can I get Winows 4.0.15 binary..

Karam Chand <[EMAIL PROTECTED]> wrote: > One of the my client is using the above version and he > is getting an error with my app so I would like to > test my app against this version.. > > Can I get a link to 4.0.15 You can find this version at: http://downloads.mysql.com/archives.php?p=

Re: using temporary / using filesort and disk tables

> Probably cause your table ends up being bigger than: > SHOW VARIABLES LIKE 'tmp_table%'; I don't think so. As I stated before (sorry I didn't include my first post), I have : tmp_table_size = 512M max_heap_table_size=512M >From my calculation, I would have ~2000 rows in the result of my query,

Using spatial extensions

Hi is there an easy way (through e.g. VCL components) to use the spatial features which will be offerd by MySQL 4.1 from Delphi? Rainer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can I get Winows 4.0.15 binary..

One of the my client is using the above version and he is getting an error with my app so I would like to test my app against this version.. Can I get a link to 4.0.15 Karam __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL

Re: using temporary / using filesort and disk tables

Hi All! I think I am getting close to the solution. In fact, mysql creates tmp tables beacause I "GROUP BY" a query that joins tables. According to the manual, group bys on joins always creates a temporary table. Now the question is, why is this table a temporary disk table??? Thanks in advance.

restore table error: wrong number of deleted records

Hi! Has anybody run into this? We backed up a MyISAM Table using "BACKUP TABLE" while other processes created a larger load of INSERTs, DELETEs, UPDATEs, and SELECTs against this table. BACKUP TABLE returned with "OK". We generated several backups of the same table at different times. Upon restori

Re: Optimizing Custom Full Text Index

Why You don't use another schema: Table A: (content table...currently nearly 40,000 rows and 62 MB) id UNSIGNED INT PRIMARY status VARCHAR 10 INDEXED category VARCHAR 20 INDEXED content LONGTEXT wordstemmed LONGTEXT (fulltext index) + other fields You have to fill wordstemmed field with cont

Errors with MySQL

Dear MySQL Firstly, let me say, I am very new to this. Secondly, I have been reading Larry Ullman's book PHP and MySQL to get started. I have installed PHP fine, and it is working well. I have followed the instructions for MySQL and it has installed a folder in my: usr/local/ folder called mysq

Errors with MySQL

Dear MySQL Firstly, let me say, I am very new to this. Secondly, I have been reading Larry Ullman's book PHP and MySQL to get started. I have installed PHP fine, and it is working well. I have followed the instructions for MySQL and it has installed a folder in my: usr/local/ folder called mysq

Re: SHOWing temporary tables

"H?ctor Villafuerte D." <[EMAIL PROTECTED]> wrote: > Hi all, > How can I see the temporary tables in a database? You can't. > Is there something like SHOW TEMPORARY TABLES? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http:

MySQL 4.0.16 on SCO OpenServer 5.0.6

Hi, I'm trying to install (compile, since there are no binaries for this system) MySQL on an SCO OPenServer 5.0.6 system. Prior to compiling MySQL, I installed the following packages for SCO : FSU Pthreads (ver 3.9) GNU Development Tools (ver 5.0.7Kj) Netscape Communicator (ver 4.7.0e) OSS63

Re: Cannot find an index that will be used for SELECT

Hi Ed, May you could join the table to itself, using a join criteria of index and position : SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R1 ON (R1.index=R2.index AND R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=R3.index AND R3.X>=Left) LEFT JOIN etc etc... Does that help? Arnaud -- MySQL Ge

Re: using temporary / using filesort and disk tables

Hi Matt, thanks for answezring! > A disk-based temp table is used if you're SELECTing a column [that can > be] longer than 255 characters (BLOB/TEXT to MySQL). This is because the > in memory HEAP tables don't currently support variable length rows. > Using something like LEFT(text_col, 255), if f

Re: archive data

Copy database directory in another location (ex. /db/data). This path must contains your databases directories... /db --- /data --- /mysql --- data file... --- data file... --- data file... --- data file... --- /test --- /YourDB1 ---

Re: is it possible?

Eugene R. Miller wrote: This is kind of a silly question is there an easy way to ... SELECT Status, rating, COUNT(*) FROM song GROUP BY pldupldqd, rating ORDER BY Status, rating DESC This gives me all the information I need ... What I would like to do is something... like SELECT rating, count(