Re: SELECT DISTINCT question

Sheryl, I'm trying to determine which author has the highest royalty percent FOR EACH PROGRAM, not overall. I'm displaying a list of programs and authors, and when there is more than one author, I want to show the principal author (i.e., the one earning the highest royalty percent). Ok, so your

Re: SELECT DISTINCT question

Sheryl, Sorry I don't time to fully address your question but I will try to give you some feedback. The DISTINCT functionality will give you exact that, every distinct instance of the columns you SELECTED. SELECT DISTINCT a.Author FROM author a Will give you each and every author but only

Re: SELECT DISTINCT question

Sheryl, See my comments below... (1) What is the rule that SELECT DISTINCT uses when deciding which of multiple instances to return? Does it return the first one? How it selects the distinct items is outside my area of knowledge. I would not assume it is the first one or the last one, or anywhere

Re: MySQL DB structure for scrolling list

At 04:58 PM 2/17/03 +0100, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include

Re: need help with GROUP BY

Jaime, You should be using the DISTINCT function. SELECT DISTINCT account, id, FROM etc. This should give you one instant of 'account' in your SELECT output. At 09:24 AM 2/5/03 +, Jaime Teng wrote: I have a MySQL table:

Re: need help with GROUP BY

Jaime, You should be using the DISTINCT function. SELECT DISTINCT account, id, FROM etc. This should give you one instant of 'account' in your SELECT output. At 09:24 AM 2/5/03 +, Jaime Teng wrote: I have a MySQL table:

Re: Is this possible?

I believe a sub-select with the DISTINCT command would do it. You would have to look up the syntax. Also, it seems that some people seem to be having a problem with sub-selects but I don't have any direct experience to convey. At 01:12 PM 1/23/03 -0600, Doug Coning wrote: Is this possible in

Re: Entering Japanese characters into mySQL

Darren, This sounds like a character set mis-match. I am wondering what character set the user is using and which OS. If the user is using Netscape to enter their data, then I am assuming they are using an OS that supports the hira/kata/kanji character sets. What do they have their OS set to,

Fwd: Re: Copying MySql database to others

-0800 To: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED], [EMAIL PROTECTED] From: Frank Peavy [EMAIL PROTECTED] Subject: Re: Copying MySql database to others Thanks everyone for your input. Stefan, From, within phpMyAdmin? snip 1. In the left frame, choose the database you want to backup

Re: Copying MySql database to others

Stefan, Let's say, you exported database my_database, and you saved the export file as c:\mysql\my_database_export.sql on your QA machine. You can import it with this command (assuming that database my_database exists on your QA machine, but has no tables in it): c:\mysql\bin mysql -uusername

Re: Copying MySql database to others

Thanks everyone for your input. Stefan, From, within phpMyAdmin? snip 1. In the left frame, choose the database you want to backup / copy. 2. Click the EXPORT tab in the right frame. 3. Choose the tables in the database you want to backup. 4. Choose Structure and data. 5. Check Enclose table

Re: Copying MySql database to others

I need to copy a MySql Production database to QA. What is the best method of doing this? Do I need to write SQL queries or is there another quicker method? From the command line? From, within phpMyAdmin? - Before posting,

Re: Copying MySql database to others

Thanks everyone for your input. Stefan, From, within phpMyAdmin? snip 1. In the left frame, choose the database you want to backup / copy. 2. Click the EXPORT tab in the right frame. 3. Choose the tables in the database you want to backup. 4. Choose Structure and data. 5. Check Enclose table

Multiple SQL files

I have multiple SQL files that create different tables. Is there a way for me to create a single SQL file that will call these other files? Since I am using phpMyAdmin, I am assuming that call this file from phpMyAdmin?! -

Re: user's updates trace

Natale, It looks like you are looking for some kind of audit trail.. It would show all the changes to the table data, right? Sorry, I don't have an answer, but I am looking for some thing similar. If I find something that falls into this category, I will try to post. What I have seen in some

Multiple SQL files

I have multiple SQL files that create different tables. Is there a way for me to create a single SQL file that will call these other files? Since I am using phpMyAdmin, I am assuming that call this file from phpMyAdmin?! -

Re: Multiple SQL files

to be pretty easy) I think that you'd have to set up an external file to create multiple databases and do your bidding with the data. . . Cheers! -warren Filter: mysql, query, queries, bigint - Original Message - From: Frank Peavy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL

Batch Queries

Anyone know how to run batch queries in phpMyAdmin? How is it done? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Search Engine (text search) like functionality...need to build

Hello All, I have a need to build some user functionality (text search) that is similar to the search functions available in most search engines. I would like to have users input a search string and find the appropriate records in MySql, for example: database software development linux Part

Re: join help: i am lost

David, I am unsure if I followed your example completely, but maybe this might help. Not knowing your complete database structure, I am unsure if my comments will be entirely valid but here goes. I think you could achieve your goal if you think of your groups as containing one or many clients.

Re: join help: i am lost

David, Just some thoughts.. See my comments below... A scheduling, or a booking, eventually has to have a class type (private or one of many groups -- so I suppose I could simply make a group class type 'private' and that type has only one slot), an instructor, a place, a time slot, and the

Re: join help: i am lost

Even so, that still doesn't answer the question of how to have data of different magnitude in the same table. If I have one class with one person and another with two people, how would I have a single record for each which lists the client(s)? Easy, Your scheduling query results, as I said:

Re: Pattern Match on 3.23

perform pattern match on text field. The only draw back is the speed (especially if you are using %pattern% to do the search) when you tables are getting huge, since there is no index to help. Qunfeng --- Frank Peavy [EMAIL PROTECTED] wrote: I would like to use pattern matching as a substitute

Re: Pattern Match on 3.23

are searching for 3-char-term. You should be able to make such Switch through your interface. Qunfeng --- Frank Peavy [EMAIL PROTECTED] wrote: Qunfeng, Thanks for the feedback, I surely appreciate it. I asked the pattern match question, because I am using a hosting service that hosts MySQL 3.23. Since

Re: Pattern Match on 3.23

with about 2.6 millions records and going (it also joins with other smaller tables). Hope this helps. Qunfeng --- Frank Peavy [EMAIL PROTECTED] wrote: Qunfeng, ..millions of records.. seems like a lot... Would you be kind enough to provide me with your hardware configuration? Thanks. At 07:57

Re: simple (I thought) delete question

I guess I am a bit confused at the response below... Please see: http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html Why can't the foreign key logic be used in version 3.23?.. At 09:45 AM 1/1/03 +1100, Greg Matthews wrote: Didn't fully read your question. Need the extra bit in the

Pattern Match on 3.23

I would like to use pattern matching as a substitute to fulltext search on MySQL 3.23. Is this a good alternative? Are there any limits, like not being able to perform a pattern match on a 'text' field, etc., that I need to be aware of? Thanks.

RE: Fulltext search of words 3 chars in 3.23

-Original Message- From: JamesD [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 10:48 PM To: Frank Peavy; [EMAIL PROTECTED] Subject: RE: Fulltext search of words 3 chars in 3.23 You need to use the REGEXP capability instead of Like in a where clause select 'field(s)' from 'table

Fulltext search of words 3 chars in 3.23

Does anyone have a method of performing fulltext searches on words less than 3 characters on MySql 3.23? I am dealing with a web hosting company so a re-compile is out of the question. Anyone have any good suggestions? I need to perform searches on acronyms like php. Thanks.