RE: unknown data base

[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 writes:

 mysqlselect* from phpbook;
 No data base selected

Hmm.. unless you typed that in rather than copied  pasted,
there's something really odd going on. Anyway, it looks like
you're trying to select stuff from the table phpbook, but
you haven't selected a database yet. Maybe you're intending
to do a SHOW TABLES?

 Unknown database

Just a hunch: Have you actually CREATEd the database? That is,
have you done a CREATE DATABASE phpbook? Note that it's
legal to grant permissions on databases that haven't been
created yet.

//C

--
 Carl Troein - Cmrdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Import from Access to MySql

[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 the
MySQL server. You may find some problems as the module doesn't set some
values in tables to NOT NULL and MySQL will expect them to be defined as NOT
NULL.
Enda

-Original Message-
From: Gabriel [mailto:[EMAIL PROTECTED]]
Sent: 21 August 2001 13:43
To: [EMAIL PROTECTED]
Subject: Import from Access to MySql


Anyone can tell me how can i import an access db to mysql.

Thanks in advance,

Gabriel.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php