Create autoincrement key in Java DB using NetBeans IDE

by

This may help you:

CREATE TABLE "custinf"

(    
   "CUST_ID" INT not null primary key
        GENERATED ALWAYS AS IDENTITY
        (START WITH 1, INCREMENT BY 1),   
   "FNAME" VARCHAR(50),     
   "LNAME" VARCHAR(50),
   "ADDR" VARCHAR(100),
   "SUBURB" VARCHAR(20),
   "PCODE" INTEGER,  
   "PHONE" INTEGER,
   "MOB" INTEGER,    
   "EMAIL" VARCHAR(100),
   "COMM" VARCHAR(450)    
);

That’s how i got mine to work… to ages to get the frigging thing to actually understand me but that’s the nature of code 😀

BTW!- There is a way to do it in the ide interface
goto the services window,
expand your connection,
expand your projects name,
expand tables,
right click indexes and select add index… the rest of the process speaks for itself really…

More Related Contents:

  1. How to clear the cache in NetBeans
  2. How to create a Jar file in Netbeans
  3. How to change file encoding in NetBeans?
  4. error: option -Xbootclasspath/p: not allowed with target 12 (Netbeans 11.0)
  5. Search and Replace Entire Project (Netbeans)
  6. How to change default encoding in NetBeans 8.0 [duplicate]
  7. JDK was not found on the computer for NetBeans 6.5
  8. NetBeans PHP code completion for own code
  9. How to use SASS with Netbeans 8.0.1
  10. How to set a java compiler in Netbeans
  11. Why can’t I find Java desktop application in Netbeans 7.1
  12. NetBeans – where to find the IDE log?
  13. developing a learning system using neuro network [closed]
  14. How to print print the first and last numbers from the list do while loop
  15. How to create id with AUTO_INCREMENT on Oracle?
  16. How to correctly get image from ‘Resources’ folder in NetBeans
  17. java.lang.RuntimeException: Uncompilable source code – what can cause this?
  18. @WebServlet fails in Netbeans 11.0 with java.lang.RuntimeException: com.example.NewServlet.(NewServlet.java:1)
  19. Netbeans – Error: Could not find or load main class
  20. Netbeans how to set command line arguments in Java
  21. Adding jRadioButton into jTable
  22. How to insert data to MySQL with auto-incremented column(field)?
  23. Adding external JAR to Maven project in NetBeans
  24. serial in postgres is being increased even though I added on conflict do nothing
  25. The specified DSN contains an architecture mismatch Error
  26. When running the program in netBeans the font looks extremely weird
  27. How do I add a auto_increment primary key in SQL Server database?
  28. Netbean Java Swing, JPanel/Jlabel Cant cover whole Frame
  29. Does a breakpoint halt all threads?
  30. How can I get jQuery code completion in NetBeans?

Leave a Comment