|
Posted by Wolfgang on 09/03/06 04:19
Hello.
Perhaps it's only the the ";" within the command at the end ?
....SELECT * FROM t1;"; <- the one in front of the "
The error in syntax message doesn't have this one.
Hope helps,
Wolfgang
"Whit" <whitnelson@gmail.com> schrieb im Newsbeitrag
news:1157238723.312572.36260@i3g2000cwc.googlegroups.com...
> 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
>
Navigation:
[Reply to this message]
|