Search code examples
sqlauto-increment

SQL not accepting AUTO_INCREMENT


New programming learner here. I am trying to create a table for blood donors, and have the id be automatically incremented upon registering new donors, but sql gives an error around auto_increment as the screenshot shows. [Screenshot of the error]

enter image description here


Solution

  • From the screenshot, I am assuming it is a SQLite database. SQLite uses the keyword "AUTOINCREMENT", not "AUTO_INCREMENT".