RSS

Search Engine

Saturday, September 11, 2010

Maintaining data in a table

Create a table with the following coding.

   
CREATE TABLE MYKILLERAPP.MyTabelle (
ID INTEGER NOT NULL,
MyKey INTEGER NOT NULL,
Content VARCHAR(20) NOT NULL,
PRIMARY KEY (ID)
);

Put in some data via SQL

   
insert into MYKILLERAPP.MyTabelle values (1,1,'Hallo');

Refresh your database and select your new table, right click on your table and select Data->Edit. Now you can edit the data.

Also note that Eclipse Data Tools Platform allows you to upload / download the data and also to see a sample of the content.

0 comments:

Post a Comment