Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Problem creating table DB [SOLVED]
Problem creating table DB [SOLVED] [message #823497] Sun, 18 March 2012 11:51
daniele pauciu is currently offline daniele pauciuFriend
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:
  


Current Time: Sun Nov 23 04:59:44 GMT 2014

Powered by FUDForum. Page generated in 0.01588 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software