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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Sun, 18 March 2012 11:51

daniele pauciu

Messages: 1
Registered: March 2012

Junior Member

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 17:33]

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 19:15:34 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter