Re: Deleting redundant rows

2004-12-13 Thread Ivan Cachicatari
Hello, You can try delete/filter the redundant rows with this code: (this is an option :D) create table yourtable ( id int not null auto_increment, city varchar(20), cc varchar(2), primary key(id) ); insert into yourtable values (0,'AAA','AA'); ... insert into yourtable values (0,'DDD'

Re: Create Trigger...

2004-12-13 Thread Ivan Cachicatari
w should I do to make > MySQL 4.1 to do the same thing as "create trigger"? > Thank you! It depends which your trigger does. If your trigger statements, you can add the necessary sql statements to simulate this. > Regards, > Alexander Chai Ivan Cachicatari http://www.lati