"create view .." doesn't work for mysql

G

gundamz

Well-Known Member
Mar 27, 2002
245
0
316
Hi all,

any ideas why this mysql command doesn't work on phpmyadmin on cpanel server.

CREATE VIEW TEST AS SELECT * FROM COURSE
Click to expand...
it give this error:

#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 TEST AS SELECT * FROM COURSE\' at line 1
Click to expand...
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
N Can't create database users on (almost) fresh WHM installation Databases 2
E User cannot access new databases created through their account Databases 2
M can not create view Databases 1
Z Grant Create View and/or DB Not Showing in CP Databases 1
H How to grant create view to user? Databases 1
Similar threads
Can't create database users on (almost) fresh WHM installation
User cannot access new databases created through their account
can not create view
Grant Create View and/or DB Not Showing in CP
How to grant create view to user?
Top Bottom