Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JavaDb creating table error

 
Ranch Hand
Posts: 510
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Now i have inserting data to table

http://1.bp.blogspot.com/_bpkZ2BsqXug/S217oetgpFI/AAAAAAAAAF8/bpl8RBPqwXw/s1600-h/db.bmp

http://2.bp.blogspot.com/_bpkZ2BsqXug/S219cnKYOiI/AAAAAAAAAGE/hKaAN_rq1LE/s1600-h/db2.GIF

what is this error?
 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Now i have inserting data to table



No, you are "nserting" ....
 
What are you doing in my house? Get 'em tiny ad!
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic