• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JavaDb creating table error

 
Samanthi perera
Ranch Hand
Posts: 510
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this is my first tsble


i have created this tasble on JavaDb

when i am going to creat the next table it gives error
this is the next table script



here is the eror


screenshot is here

http://4.bp.blogspot.com/_bpkZ2BsqXug/S21OLQkrVUI/AAAAAAAAAF0/i2rOxn4pHJA/s1600-h/db.gif
 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

see http://www.w3schools.com/SQl/sql_foreignkey.asp

just add a "," after
DEPT_ID" INTEGER



1. CREATE TABLE "Student" (
2. "ID" INTEGER not null primary key,
3. "NAME" VARCHAR(30),
4. "DEPT_ID" INTEGER,
5. FOREIGN KEY (DEPT_ID) REFERENCES DEPARTMENT(DEPT_ID)
6. );
 
Samanthi perera
Ranch Hand
Posts: 510
 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Now i have inserting data to table


No, you are "nserting" ....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic