RE: Weeding out duplicates

At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding out duplicates: For the information of someone who may need it in the future. I used Jeffrey's idea for determining duplicates. Then I created a temporary table, and used insert...select to put the id's of the duplicates in t

RE: Weeding out duplicates

At 10:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding out duplicates: Lachlan, I want to identify the entries in the table where the email addresses are the same as another entry. Whatever else is in the record does not matter to me. However, a second requirement for the query is

Re: INDEX DESC

At 16:38 -0400 on 06/23/2004, Michael Stassen wrote about Re: INDEX DESC: > For example, I want to read ranges of values from my db in the opposite order of how they are currently being indexed without using an extra ORDER BY in my select. This ORDER BY forces an internal sort to put the result

Re: INDEX DESC

At 15:30 -0400 on 06/23/2004, Michael Stassen wrote about Re: INDEX DESC: The manual says "An index_col_name specification can end with ASC or DESC. These keywords are allowed for future extensions for specifying ascending or descending index va

Re: How do you deal with URL's?

At 22:38 -0300 on 06/21/2004, Sergio Salvi wrote about Re: How do you deal with URL's?: Separate data from how it's displayed. I mean, create a table called "states" with the fields "state_id", "state_name" and "state_url". Put the data in the according field: state_id state_name state_url 1 Alab

Re: How to monitor that slave is not working because of user rights?

At 09:10 -0500 on 06/17/2004, gerald_clark wrote about Re: How to monitor that slave is not working because of use: The master will be trying to serve binlogs to the old address, but the slave won't know this. You could monitor the IP address, and stop and start the slave when it changes, but h

RE: Full Text Index on Large Tables - Not Answered

At 19:02 -0700 on 06/18/2004, Paul Chu wrote about Re: Full Text Index on Large Tables - Not Answered: Appreciate any help at all Thanks, Paul -Original Message- From: Paul Chu [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Full Text Index

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

At 13:37 -0400 on 06/19/2004, Michael Stassen wrote about Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a: Finally, just to cover all the bases, that really is 87 million inserts, not 8.7 million, right? I only ask because a MEDIUMINT column runs out a little past 8.3 million. It goe

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

At 17:16 -0700 on 06/18/2004, Kevin Brock wrote about AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one: We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT. After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY. You are wasting half your

Re: Query Help

At 12:22 +0100 on 06/11/2004, Andrew Dixon - MSO.net wrote about Query Help: Hi Everyone. I have the following a table with a varchar column that contains a comma delimited list of id's from another table that relates the item keywords in the other table. The table keywords contains keyword_id (int

Re: "not unique table/alias"

At 14:40 -0400 on 06/07/2004, Jack Tanner wrote about "not unique table/alias": I have two complex subqueries that I need to join. I suspect this problem is due to using aliases instead of table names, but I don't know how to work around it (temporary tables?). Please help. SELECT col FROM (subquer

Re: Advice on Database Schema Design

(and SELECT t2.y [from the t2.x selected row]) type situation where I am selecting the fields form the support tables based on the link (Foreign Key) field not actually merging/matching tables. ""Robert A. Rosenberg"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PRO

Re: OT: Errors from Extra Spaces in Spreadsheets

At 22:33 -0700 on 06/06/2004, David Blomstrom wrote about OT: Errors from Extra Spaces in Spreadsheets: I've been having a tough time importing comma-delimited files into my database tables. I just discovered that most of the errors are similar to this one: "060 " is not a valid integer value I c

RE: DELETE from more than one table

At 14:01 + on 06/07/2004, shaun thornburgh wrote about Re: DELETE from more than one table: Hi Paul, Thanks for the reply. I actually need to delete data from about 10 tables, is this possible? If the field in the tables is defined as a Foreign Key (with ON DELETE CASCADE), deleting the root

Advice on Database Schema Design

I am converting a form that was originally designed to be Email Submitted into a Submit-to-PHP-Page Form (which will then insert the data into a MySQL Database). I expect no problems in actually scanning the submission to extract the data but I have some questions on the design of the Tables t

Re: Exporting/Importing Databases

At 21:54 -0700 on 06/02/2004, David Blomstrom wrote about Re: Exporting/Importing Databases: --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: >Third, my practice database in

Re: Where do exported SQL files go?

At 22:17 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where do exported SQL files go?: --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: At 20:13 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where do exported SQL files go?: >(I'm using Mozilla

Re: Where do exported SQL files go?

At 20:13 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where do exported SQL files go?: (I'm using Mozilla Firefox, which downloads everything to the desktop, though I don't understand why it considers this a download when it's a database on my computer.) Might it be doing this due to PHPA

Re: Exporting/Importing Databases

At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: Third, my practice database includes half a dozen tables, but only one made it online, followed by this error message: Database USERNAME running on localhost Error SQL-query : CREATE TABLE `counties` ( `SCod

RE: Reloading Database with Foreign Keys

ob Thanks - that was it and it fixed my problem. -Original Message----- From: Robert A. Rosenberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:56 PM To: [EMAIL PROTECTED] Subject: Reloading Database with Foreign Keys I just tried to reload a mysqldump created dump to a new server and got

Reloading Database with Foreign Keys

I just tried to reload a mysqldump created dump to a new server and got rejected due to lack of referential integrity. I remember the existence of a command I can insert in the file that will turn off the checking of the Foreign Keys while the recreation is being done but I can not locate it in

Reloading Database with Foreign Keys

I just tried to reload a mysqldump created dump to a new server and got rejected due to lack of referential integrity. I remember the existence of a command I can insert in the file that will turn off the checking of the Foreign Keys while the recreation is being done but I can not locate it in

RE: Feature Request: UPDATE 'error codes' or mysql_affected_rows() to be more "accurate"

At 12:38 -0700 on 05/27/2004, Daevid Vincent wrote about Re: Feature Request: UPDATE 'error codes' or mysql_affected: REPLACE INTO won't work, as I need the previous record (hence the update). I store the first and last time I saw a node, amongst other info. REPLACE would delete that data. REPLAC

Re: need help with a complicated join

At 14:07 -0500 on 05/25/2004, <[EMAIL PROTECTED]> wrote about need help with a complicated join: I am trying to come up with a query that takes two tables, one with non-split-adjusted historical stock prices, and one with information on splits, for instance: CREATE TABLE quotes ( symbol

Re: DATETIME question

At 11:01 +0300 on 05/26/2004, Egor Egorov wrote about Re: DATETIME question: John Mistler <[EMAIL PROTECTED]> wrote: Given a column DATETIMEcolumn (-MM-DD HH:MM:SS), is there a SELECT statement that will: select all entries whose (TIME) of DATETIMEcolumn is BETWEEN 'HH:MM:SS' AND 'HH:MM:SS'

Re: Installing on OS X without installer

At 08:30 +1000 on 05/24/2004, Chris Curnow wrote about Installing on OS X without installer: Hi, I've just downloaded the latest version of MySQL (4.0.20) for OS X. They seem to have omitted the installer - there's no .dmg file to download. The manual only covers installing from the .dmg for OS X

Re: Running more than one level of MySQL

At 15:09 -0500 on 05/18/2004, Paul DuBois wrote about Re: Running more than one level of MySQL: At 15:46 -0400 5/18/04, Robert A. Rosenberg wrote: I have a site that is being hosted by an ISP which is running version 3.23.52. When I questioned why that downlevel version and not a 4.0 version

Running more than one level of MySQL

I have a site that is being hosted by an ISP which is running version 3.23.52. When I questioned why that downlevel version and not a 4.0 version (such as 4.0.18 or the just released 4.0.20), I was told "Unfortunately, when versions change on MySQL, they also drop features and change security s

Re: check for certain characters

At 23:51 -0400 on 05/11/2004, Michael Stassen wrote about Re: check for certain characters: Then you could add NOT to Paul's query: SELECT * FROM your table WHERE sequence NOT REGEXP '^[atcg]+$'; or, equivalently, SELECT * FROM your table WHERE sequence REGEXP '[^atcg]'; I suspect the lat

Re: Blocking Selects with LOCK TABLES

At 12:40 -0400 on 05/10/2004, Lou Olsten wrote about Blocking Selects with LOCK TABLES: According to the docs (http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html) : If a thread obtains a READ lock on a table, that thread (and all other threads) can only read from the table. If a thread obtains

Re: This thing called MOD

At 18:27 +0200 on 05/09/2004, Thomas Nyman wrote about This thing called MOD: Hi All I'm a bit perplexed..perhaps its a language thing,,but the MYSQL reference manual says that MOD ..Returns the remainder of N divided by M... and gives an example SELECT MOD(234,10) --> 4 Th

Re: triggers (or too-many-crappy-questions)

At 12:22 -0700 on 04/30/2004, Eric wrote about Re: triggers (or too-many-crappy-questions): Hi, Can we have list for people who just like to give newbies shit? How about [EMAIL PROTECTED] How much have you guys paid for your support hmm? This is a free mailing list and I don't really see why

Re: varchar < 4 = char < 4? Why?

At 13:34 -0400 on 04/18/2004, Stormblade wrote about varchar < 4 = char < 4? Why?: This has been puzzling me. At first I thought it was something that Navicat was doing but I also tried in EMS MySQL and it does the same. If I set the type of a field to varchar and set the length to anything less

Query about MySQL and Access Permissions to MySQL Database FILES

I am talking a PHP+MySQL course at my local community college and since this is the first time the course is being offered there are some teething problems with the curriculum. I am posting this query at the request of the instructor. We are using a Linux Server and each Student has their own s