LOL - Now I feel silly. Thanks that worked.
R -----Original Message----- From: mos [mailto:[EMAIL PROTECTED] Sent: Friday, December 15, 2006 5:37 PM To: mysql@lists.mysql.com Cc: mysql@lists.mysql.com Subject: RE: Strange table problem At 03:44 AM 12/15/2006, Ruan wrote: >Hi, > >The dump revealed this: > >--------------------------------------------------------------------+ >| View | Create View > >| test | CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY >DEFINER VIEW `test` AS select `beta_users`.`user_id` AS `user_id`,`beta_user >s`.`user_type` AS `user_type`,`beta_users`.`group_id` AS >`group_id`,`beta_users` >.`user_permissions` AS `user_permissions`,`beta_users`.`user_perm_from` AS >`user >_perm_from`,`beta_users`.`user_ip` AS `user_ip`,`beta_users`.`user_regdate` >AS ` > > >Carries on for quite a bit longer... If it is a view, how would one go about >removing it? Thanks for your help and quick response. Is there a reason why you can't use Drop View....?? http://dev.mysql.com/doc/refman/5.1/en/drop-view.html Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]