title: How to create an MySQL Database using NetBeans?
body: <p>I want to check whether this database, "genericDatabase" is available among MySQL databases using NetBeans, and if not, I want to create this given database, with the tables using NetBeans(With the use of JDBC).</p>
  
  <pre><code>create database genericDatabase;
  use genericDatabase;
  
  create table data(
  dataID VARCHAR(5) NOT NULL,
  dataName VARCHAR(20) NOT NULL,
  CONSTRAINT PRIMARY KEY (dataID)
  )ENGINE=INNODB;
  
  create table information(
  informationID VARCHAR(4) NOT NULL,
  informationName VARCHAR(20) NOT NULL,
  CONSTRAINT PRIMARY KEY (informationID)
  )ENGINE=INNODB;
  </code></pre>
  
  <p><strong>I made an controller class with the SQL above, but it doesn't work. How to do this properly? I need to know how to identify a SQL database using NetBeans and how to create the database and insert tables if the database isn't available?</strong></p>