InnoDB vs myISAM disk space usage

2002-11-27 Thread tommaso . nolli
Hello all, I'm using mySQL for many databases, now I want to test innoDB so I have created another DB (on the same machine) and I have populated it with the same data of the first DB (via: insert into table_name select * from db1.table_name); I have this tables: tableA:   80.000 recs tableB,

Re: Java Example for connection

2001-04-23 Thread Tommaso Nolli
Hi, I use this code to connect to a mySQL 3.23.36: Connection cnn = null; try { Class.forName(org.gjt.mm.mysql.Driver); cnn = DriverManager.getConnection(jdbc:mysql://server/database, user, password); cnn.setAutoCommit(false); //