Search code examples
javamysqlsqljdbcjavadb

can JavaDB use SQL statements?

I need to make a project in java where I am going to create a database, but my problem is, I don't know what to pick, I have knowledge about SQL(Select * from ) so on and so forth, but the thing is what's the difference between Java DB and MySql?, what should I pick for my project? I am going to create a payroll using Java.

Solution

  • U can find some explanation by searching JavaDB vs MySQL

    Derby or MySQL or...?

    for selecting and etc , read the documentation

    select.executeQuery("SELECT id, val FROM users");

    As u see there is slight different in statements , but you already have mysql and know sql statements, MySQL is more complex than javadb and been around for longer period with wider community , which is good when u need help and resources