Re: Transplanting table structure changes

Hello Jerry, > I've added about a dozen new columns to two tables in my development > environment, and now I need to roll it out to our production environment. > Can anyone suggest an easy way to do this? I want to avoid typos, as much as > I can. > > > > I made the original changes with PHPMyAdmi

Re: Picking the better query (join vs subselect)

Out of curiosity, is it generally faster to do a sub query or do it in code for something like this. Schema of Settings table, where the PK is (ApplicationId, SettingId): ApplicationId, SettingId, SettingValue Select SettingValue from Settings where SettingId = 10 and ApplicationId IN (select App

Re: Transplanting table structure changes

Sutput the table definitions and cut and paste the new columns into a ALTER TABLE table_name ADD column_name column-definition statement. --- On Wed, 6/8/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote: > From: Jerry Schwartz <[EMAIL PROTECTED]> > Subject: Transplanting table structure changes > T

Re: Picking the better query (join vs subselect)

On Wed, Aug 6, 2008 at 5:18 AM, Morten Primdahl <[EMAIL PROTECTED]> wrote: > I've tried to find out if joins are preferred over subselects, but am not > able to come to a definite conclusion. I read that correlated subselects are > bad, and I should go for the join, but I know the id of the record

Data files from 4.1.13 with 5.0.x

Hi, Would data files from 4.1.13 work with 5.0.x or will I have to use an SQL dump? Thanks. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Transplanting table structure changes

I've added about a dozen new columns to two tables in my development environment, and now I need to roll it out to our production environment. Can anyone suggest an easy way to do this? I want to avoid typos, as much as I can. I made the original changes with PHPMyAdmin, so I don't have any ori

Re: removing duplicate entries

I just did a test case here select * from amc_25; +--+ | id | +--+ |2 | | 14 | |1 | |2 | +--+ 4 rows in set (0.01 sec) select id from amc_25 group by id having count(id) >1 and id!=min(id); Empty set (0.00 sec) It does not give me any rows. R u sure the rows retu

Picking the better query (join vs subselect)

Hi guys, I have 2 tables "cars" and "parts" where car has many parts. I need a query to return some fields from the cars table as well as a field from multiple parts records. I've come to the following approaches, and would like to understand which is the better, and why, or if there's a

RE: removing duplicate entries

When I try the first suggestion (i) then I get all the 1682 duplicate rows. The thing is that I need to keep the originals which are the ones with the lowest ACCOUNTACTION.ID value. The second suggestion (ii) gives me 563 rows that are the duplicates with the lowest ACCOUNTACTION.ID which are th

Re: Install Microsoft.Jet

You need the mdac components. free download from MS. Sivasakthi wrote: Hi all, I have tried to import the excel to db , but i get the following error, The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. how can i install the Microsoft.Jet? System Info: OS Name Microsoft(R

Re: removing duplicate entries

I doubt the belwo sql will give you duplcates select ACCOUNTACTION.ID from ACCOUNTACTION where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%' group by ACCOUNTACTION.ACCOUNT_ID having (count(ACCOUNTACTION.ACCOUNT_ID) > 1 and ACCOUNTACTION.ID!=

removing duplicate entries

I have the following two tables ACCOUNTACTION +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | ID| bigint(20) | NO | PRI