Posted by Jerry Stuckle on 09/03/06 00:23

Whit wrote:
> 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
>

This isn't a PHP question. Try a mysql newsgroup - such as
comp.databases.mysql.

And ensure your version of MySQL supports views.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: What editor is the most common in PHP developer?
• Prev in forum: Re: do professional PHP programmers use error checking in their code?
• Thread view: Re: Creating a view

[Reply to this message]