Error 1046 - No database selected

[ShamaJamms]

I ran the following code in my Windows terminal, and got the error: Error 1046 - No database selected:

CREATE TABLE `database` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

Google didn't answer my question.
Thanks.

 

[elsenorjose]

At the command prompt, you must first select a database:

mysql> use DATABASE
Datbase changed
mysql> CREATE TABLE `database` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

Try that using your database name, of course.

 

[sleipnir214]

You must first specify the database you will be using. Generally, something like "use databasename;" is appropriate.



Want the best answers? Ask the best questions! TANSTAAFL!