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'
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