How to select a database (basic)

[gaugeboson]

How do I select a particular database at the SQL command prompt?

 

I am trying to run this:

ALTER TABLE messages ADD FOREIGN KEY(topic_id)

REFERENCES topics (id) ON DELETE CASCADE;

 

What command do I type in to select a database? Say the database is called "X".

[fenway]

USE X;

[gaugeboson]

Well I selected the table just fine.  But After I ran the query it gave me this error:

 

ERROR 1005 (HY000): Can't create table './forum/#sql-149c_a.frm' (errno: 150)

 

[fenway]

That usually means that your data types aren't identical.