I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
Hi everybody,
I have a very strange table problem - a table was created in one of our
databases, but I can't seem to drop
PROTECTED]
Sent: Friday, December 15, 2006 10:43 AM
To: Ruan
Cc: mysql@lists.mysql.com
Subject: Re: Strange table problem
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
Hi everybody
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
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
