Creating mysql table with java

Question

I am trying to create a table using java for mysql. The code is below.

  Statement stmt2 = con.createStatement();

  String sql = "CREATE TABLE " + libcard +
               "(Title INTEGER, " +
               " Director VARCHAR(255), " + 
               " dateBorrowed DATE, " + 
               " dueDate DATE)"; 

  stmt.executeUpdate(sql);

but there is always error. :: Exception message is given below :_

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '23232.0(Title INTEGER, Director VARCHAR(255), dateBorrowed DATE, dueDate DATE' at line 1

@juergend: I'm guessing (hoping) it's a typo rather than a table name... — Birb
– Birb, Commented Sep 28, 2013 at 13:17
The error message is probably copied from the output. That is no typo IMO. — juergen d
– juergen d, Commented Sep 28, 2013 at 13:18
@eggyal: I'm not saying it's invalid or wrong, I'm saying it's meaningless. — Birb
– Birb, Commented Sep 28, 2013 at 13:21
@lzmaki if you don't know the domain, no way of saying it is meaningless. It could be a table holding data of object number 23232.0. — Bart Friederichs
– Bart Friederichs, Commented Sep 28, 2013 at 13:25

Bart Friederichs · Accepted Answer · 2013-09-28 13:22:31Z

2

Check the documentation on how to come up with valid table names. In your case 23232.0, you should surround it with backticks:

String sql = "CREATE TABLE `" + libcard + "`" +
           " (Title INTEGER, " +
           " Director VARCHAR(255), " + 
           " dateBorrowed DATE, " + 
           " dueDate DATE)";

answered Sep 28, 2013 at 13:22

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nambi · Accepted Answer · 2013-09-28 13:19:04Z

try this code

try{

      Class.forName("com.mysql.jdbc.Driver");


      System.out.println("Connecting to a selected database...");
      conn = DriverManager.getConnection(DB_URL, USER, PASS);
      System.out.println("Connected database successfully...");


      System.out.println("Creating table in given database...");
      stmt = conn.createStatement();

      String sql = "CREATE TABLE " + libcard +
               "(Title INT(2), " +
               " Director VARCHAR(255), " + 
               " dateBorrowed DATE, " + 
               " dueDate DATE)"; 

      stmt.executeUpdate(sql);
      System.out.println("Created table in given database...");
   }catch(SQLException se){

      se.printStackTrace();
   }catch(Exception e){

      e.printStackTrace();
   }

Collectives™ on Stack Overflow

Creating mysql table with java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related