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: > mysql>select* 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
