Posted by Whit on 09/02/06 23:12

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

• Next in forum: Re: do professional PHP programmers use error checking in their code?
• Prev in forum: Re: PHP Database Class Instantiation
• Thread view: Creating a view

[Reply to this message]