Creating a View

I am having a terrible time trying to create a view. Here is the sql
string:

$sql = "CREATE VIEW v AS SELECT * FROM t1;";

Here is the error:

You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'VIEW v
AS SELECT * FROM t1' at line 1

So simple, yet so vexing. Any thoughts? Thanks,

-- whit nelson

Whit wrote:
> I am having a terrible time trying to create a view.

Try this: "SELECT VERSION();"

If it says you are using a version prior to 5.0, then views are not
supported. Views are a new feature in 5.0.

Regards,
Bill K.