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]