Re: Create Trigger...

2004-12-13 Thread Ivan Cachicatari
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.latindevelopers.com -- MySQL General Mailing List For list archives: http

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