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.

No comments:

Post a Comment

How to Free Up Storage Space on Your Android Phone (Without Deleting Photos)

Running out of space on your Android phone is one of the most common (and most annoying) problems out there - especially once you start gett...