FreeHostia Forums
https://forum.freehostia.com/

Unable to create a table in phpMyAdmin
https://forum.freehostia.com/viewtopic.php?f=7&t=8870
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.

Thank you,
R.C.

Author:  Josh.Waller [ Wed Feb 27, 2008 7:14 am ]
Post subject: 

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
http://www.phpbb.com/