Join to find Duplicates

I need to find records in a table that may be duplicate records. The table stores basic information about the Users. I want to do a match on the FName and LName fields. The query I have looks like this SELECT u1.UserID, u1.FName, u1.LName, u1.Email, COUNT(u1.Email) AS `Count` FROM user u

Re: Replication - urgent

Running this statement on the master should do it: DROP TABLE table1, table2...; That will remove the tables. Baron Ratheesh K J wrote: Hello all, I cannot afford to stop my slave server. I have list of tables of the master that are being replicated on the slave. Now I want to remove a cou

Replication - urgent

Hello all, I cannot afford to stop my slave server. I have list of tables of the master that are being replicated on the slave. Now I want to remove a couple of tables from this list without affecting the master and slave. How is this possible? Thanks & regards, Ratheesh

Re: how ti put several records of one mysql table in one row of html table?

Yup! That's THE ONE! Thanks Rajesh. -afan Rajesh Mehrotra wrote: > Hi, > > I think "GROUP_CONCAT" will do it. > > -Raj. > > > > -Original Message- > From: afan pasalic [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 16, 2007 11:49 AM > To: mysql@lists.mysql.com > Subject: how ti pu

RE: ORDER BY but disregard stop words

[snip] Is there any way to use ORDER BY in such a way as to have it ignore words such as "the", "a", "an", and the like? [/snip] I haven't tested this but you might be able to do it with a little REGEX and a HAVING clause; SELECT REGEX(words) AS undesirable FROM table HAVING stuff <> undesirable

RE: how ti put several records of one mysql table in one row of html table?

Hi, I think "GROUP_CONCAT" will do it. -Raj. -Original Message- From: afan pasalic [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 11:49 AM To: mysql@lists.mysql.com Subject: how ti put several records of one mysql table in one row of html table? hi, I have "standard" organ

ORDER BY but disregard stop words

Is there any way to use ORDER BY in such a way as to have it ignore words such as "the", "a", "an", and the like? brian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how ti put several records of one mysql table in one row of html table?

hi, I have "standard" organizations table with org_id, name, address, city,... columns. CREATE TABLE `organization` ( `organization_id` int(8) unsigned NOT NULL default '0', `address_id` int(8) unsigned default NULL, `full_name` varchar(255) default NULL, `phone` varchar(255) NOT NULL def

The value of NULL in Uniqued Columns

This is more of a philosophical issue than anything, but it has jumped up to bite us so I thought I'd make others aware; Since NULL has no value they can be entered multiply times into unique columns. Some will say that NULL is a value and therefore should be unique in this case (only one NULL a

Re: Deadlocks with High Concurrency SELECT FOR UPDATE

Hi William, William Newton wrote: Hello List, I have this table that has a single row in it: CREATE TABLE `quicktable` ( `x` int(11) NOT NULL auto_increment, `quick_id` int(11) NOT NULL default '0', PRIMARY KEY (`x`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 select * from