RE: What is the error in this sql query
I believe the ENUM-length is faulty! It should be somthing like this: have_vote ENUM(yes, no), Check the manual: http://www.mysql.com/doc/E/N/ENUM.html \d -Original Message- From: Syed sumair [mailto:[EMAIL PROTECTED]] Sent: den 1 juni 2001 01:11 To: MySQL List Subject: What is the error in this sql query What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID), INDEX(page_ID) ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Drop Database
Hi! Yes, it is a database. I recieve these errors, regardless if I use the semi-colon: Query: DROP DATABASE #Muffin Returns: ERROR 1064: You have an error in your SQL syntax near '' Query: DROP DATABASE '#Muffin' Returns: ERROR 1064: You have an error in your SQL syntax near ''#Muffin'' I assume the # character is the bandit I can also mention it's mysql-version 3.23.23-beta Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: den 25 januari 2001 11:45 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Drop Database David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Drop Database
Yes! This worked! I shut down mysqld, renamed the folder and then I could use a regular DROP query to get rid of the database! Thank you for the help, and all answers! Regards David -Original Message- From: Kent Hoover [mailto:[EMAIL PROTECTED]] Sent: den 25 januari 2001 14:55 To: [EMAIL PROTECTED] Subject: RE: Drop Database Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php