Unlike MySQL and other SQL dialects, apache derby doesn’t support the AUTO_INCREMENT keyword. To create an auto incremented filed in derby, you can use The value of id is now incremented automagically on every insert. You don’t have to specify it manually in the insert command For instruction on how to create auto incremented fields in other SQL dialects, have… Read more »
It shouldn’t happen, but it does: I forgot my MySQL root password. Resetting is rather simple. Stop the running mysqld instance and restart it in safe mode: You can now log in as root without a password: Don’t forget restart the mysql server and clear ~/.mysql_history afterwards!