It is currently Fri Mar 29, 2024 8:36 am


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Unable to create a table in phpMyAdmin
PostPosted: Wed Feb 27, 2008 4:03 am 
Newbie
Newbie

Joined: Thu Nov 15, 2007 10:21 pm
Posts: 4
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.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Feb 27, 2008 7:14 am 
Moderator
Moderator

Joined: Tue Feb 27, 2007 12:18 am
Posts: 521
Click the table you want, go to SQL and paste i the query. Make sre that you click the database first.

_________________
http://www.mjmclocks.co.uk


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ]  Moderators: Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Hosting | Domains | Servers | Extras | Order | Support | Contacts | FreeHostia © 2011