| 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/ |
|