|Unable to create a table in phpMyAdmin
|Page 1 of 1|
|Author:||Ziorpc [ Wed Feb 27, 2008 4:03 am ]|
|Post subject:||Unable to create a table in phpMyAdmin|
I created a database called roccle_guestbkdb in the MySQL Databases section of the Free Hostia Control Panel. The database name then appeared correctly under the "Database Name / Database Username" heading below.
However, after logging into phpMyAdmin, I am unable to create a table using an SQL query. I get the error message "#1046 - No database selected".
Below is the SQL query I was using:
CREATE TABLE `comments` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 60 ) NOT NULL ,
`email` VARCHAR( 60 ) NOT NULL ,
`website` VARCHAR( 60 ) NOT NULL ,
`message` VARCHAR( 300 ) NOT NULL ,
`date` VARCHAR( 10 ) NOT NULL ,
INDEX ( `id` )
) ENGINE = MYISAM ;
I'd appreciate your help with this matter.
|Author:||Josh.Waller [ Wed Feb 27, 2008 7:14 am ]|
Click the table you want, go to SQL and paste i the query. Make sre that you click the database first.
|Page 1 of 1||All times are UTC|
|Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group