RE: unknown data base

2001-12-11 Thread Enda Campbell
Try doing this mysql> use databasename mysql> select * from tablename; You haven't selected any database from which to retrieve info. -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 10:26 To: [EMAIL PROTECTED] Subject: Re: unknown data base josep

RE: Import from Access to MySql

2001-08-21 Thread Enda Campbell
access has a module called exportaccesstomysql which will convert the access DB to 2 text files. One contains a series of SQL statements to create the various tables in MySQL and also add entries which are in the access DB. If you have a win-32 version of nysql you can use this to create the DB on