» Quick Links
You can make money on these forums
We Share profits with you
Google
Google Adsense
Google Adwords
YPN
Yahoo
MSN Search
Web Directories
Web Hosting
Web Hosting Offers
Hosting News
Suggestions
Link Building
Domain Names
PHP Forums
MySQL Forums
» More Links
OSP News
Reseller Hosting
Shared Hosting
Dedicated Servers
Google Adsense
Search Engine Marketing
Link Development
Affiliate Marketing


» Advertising
Multiple DC PR Check

Free SEO Tools


Go Back   Webmaster Forums > Website Developement / Programming > MySQL Forums

MySQL Forums Share Your Ideas and Tips about MYSQL. Ask questions about MYSQL. Table Design and Much More...

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2007, 03:26 AM
Elle Elle is offline
Junior Member
 
Join Date: Aug 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Elle is on a distinguished road
Default exceution error!!!!

Hi all of you,
Getting an error, on creating a new view. I just installed MySQL Administrator version 1.2.2 beta. Server information: MySQL 5.0.24a-community-nt via TC/IP. From View tab, I selected create view. Entering the view name in the create view window. The following sql code is created:
CREATE OR REPLACE VIEW `mydatabase`.`test` AS SELECT
I get Error while executing SQL
CREATE OR REPLACE VIEW `mydatabase`.`test` AS SELECT
MySQL Error Number 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" at line 1
Can someone please help me to fix this problem?
Thank you in advance. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Revenue Sharing Ads ( ?):
  #2  
Old 01-06-2007, 07:18 AM
Kodi Kodi is offline
Senior Member
 
Join Date: Jul 2006
Posts: 116
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16
Kodi is on a distinguished road
Default

Since, SELECT is not a complete query. Specify the tables and columns you are selecting. The GUI creates part of the view definition itself, and you need to fill in the rest. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 1064 (42000).... imaan MySQL Forums 1 12-19-2006 03:18 AM
Error in select statement speedy PHP Programming and Tips 1 08-19-2006 09:32 AM
myisamchk error Antoine MySQL Forums 1 08-18-2006 05:28 AM
mysql error: error 28.... Jaida MySQL Forums 1 08-16-2006 05:34 AM
ASP Error Codes - Description dam Introductions 1 12-07-2005 09:09 AM


All times are GMT. The time now is 02:36 AM.