Re: Create Tables In MySQL

2003-12-31 Thread Martijn Tonies
Hi Caroline, > Hi, I have several simple questions regarding creating > tables in the MySQL. > > 1. For a variable of Java primitive int type, I should > use INT or INTEGER? Do I have to specify the length of > the field? > CREATE TABLE message_thread( thread_id INT or INTEGER > NOT NULL AUTO_INC

Re: Create Tables in MySQL Database from Access

2002-02-18 Thread Patrick Latour
Hello, Yes there is a simple solution I already used: Do not use CurrentDb() Instead, create a new Database Object, using your Mysql DSN and use this Object. Any transaction, including CREATE TABLE, will then be performed on the server. It is the same thing that Access do in the background, whe