View Single Post
  #2 (permalink)  
Old 2007-05-20, 06:56 PM
Ed Poor Ed Poor is offline
Junior Member
 
Join Date: May 2007
Posts: 3
Ed Poor is on a distinguished road
Default Error message when trying to create a view

Error

SQL query:
CREATE VIEW v AS SELECT *
FROM `person`
WHERE ID >5
MySQL said:
#1064 - 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 `person` WHERE ID > 5' at line 1
Reply With Quote