Records Present in `part_new` Table and not in `part_old` Table

[imranlink]

Hi,

I have two tables in MYSQL. Below are there structure.

CREATE TABLE part_new (
id int(11) NOT NULL auto_increment,
part varchar(20) default NULL,
UNIQUE KEY part (part),
PRIMARY KEY (id),
) TYPE=MyISAM

CREATE TABLE part_old (
id int(11) NOT NULL auto_increment,
part varchar(20) default NULL,
UNIQUE KEY part (part),
PRIMARY KEY (id),
) TYPE=MyISAM

Both tables are filled with some same and some different data. I want to write a SQL query which only shows me all "part" from table part_new those are not present in TABLE part_old.

For example

TABLE part_new

ID Part
1 A001
2 A002
3 A005
4 A006

TABLE part_old

ID Part
1 A001
2 A002
3 A003

According to above data i want to write a such SQL query that return me

Result (Records Present in part_new Table and not in part_old Table)

3 A005
4 A006

Sincerely,

Imran Khalid ( Web Developer)
Phone: +92 437 / 602955
Mobile: +92 300 / 6230287
Email: [e-mail]
...........................................................

[laserlight]

Is this a permanent arrangement?

If it is, then you should take a look at database normalisation.