Jan 30, 2004 #1 chantey Instructor Joined Jan 28, 2004 Messages 11 Location GB I need to know how to create a table/view using an already existing table. Is it possible to use something like: CREATE VIEW newTable AS SELECT * FROM oldTable WHERE field1 = 1; Which will then allow me to use SELECT * FROM newTable; Any ideas?
I need to know how to create a table/view using an already existing table. Is it possible to use something like: CREATE VIEW newTable AS SELECT * FROM oldTable WHERE field1 = 1; Which will then allow me to use SELECT * FROM newTable; Any ideas?
Jan 30, 2004 #2 sleipnir214 Programmer Joined May 6, 2002 Messages 15,350 Location US MySQL does not support views. http://www.mysql.com/doc/en/ANSI_diff_Views.html Want the best answers? Ask the best questions: http://www.catb.org/~esr/faqs/smart-questions.htmlTANSTAAFL!! Upvote 0 Downvote
MySQL does not support views. http://www.mysql.com/doc/en/ANSI_diff_Views.html Want the best answers? Ask the best questions: http://www.catb.org/~esr/faqs/smart-questions.htmlTANSTAAFL!!
Jan 30, 2004 #3 vanekl Programmer Joined Nov 25, 2003 Messages 69 Location US If you just change 'CREATE VIEW...' to 'CREATE TABLE...' your statement will work. Upvote 0 Downvote