Eclipse Community Forums: DTP » Problem creating table DB [SOLVED]

Home » Eclipse Projects » DTP » Problem creating table DB [SOLVED]

Problem creating table DB [SOLVED] [message #823497]

Sun, 18 March 2012 07:51

Eclipse User

Hello! I've created a mysql database called "example". Then I've created a new sql file called "database.sql".
Now I''m having problems with creating tables.

I've written this code in database.sql editor:

CREATE TABLE picture (
`id` int(10) NOT NULL auto_increment,
`image` blob,
PRIMARY KEY (`id`)
);

But when I execute this code the error is:

CREATE TABLE picture (
`id` int(10) NOT NULL auto_increment,
`image` blob,
PRIMARY KEY (`id`)
);

No database selected

even if I've selected the database!

I've also tried to create a new SCHEMA, and then a table. It's works but then I cant see the table in my database.

Someone can help me?? Thanks!

[SOLVED!]

[Updated on: Sun, 18 March 2012 13:33] by Moderator

Previous Topic:	java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver
Next Topic:	Manually expand Data Source Explorer nodes

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 06 13:08:34 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter