Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.4-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +---------------------+ | Database | +---------------------+ | information_schema | | academia | | atoms | | boxes | | cake | | library_development | | molecules | | mysql | | test | +---------------------+ 9 rows in set (0.11 sec) mysql> create database books; Query OK, 1 row affected (0.02 sec) mysql> connect books; Connection id: 2 Current database: books mysql> CREATE TABLE sc_books ( -> book_id INT NOT NULL AUTO_INCREMENT, -> book_name VARCHAR(64) NOT NULL, -> book_description TEXT NOT NULL, -> book_image VARCHAR(60) NOT NULL, -> book_date DATETIME NOT NULL, -> PRIMARY KEY(book_id) -> ); Query OK, 0 rows affected (0.33 sec) mysql> select * from books; ERROR 1146 (42S02): Table 'books.books' doesn't exist mysql> select * from sc_books; Empty set (0.00 sec) mysql> desc sc_books; +------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+----------------+ | book_id | int(11) | NO | PRI | NULL | auto_increment | | book_name | varchar(64) | NO | | | | | book_description | text | NO | | | | | book_image | varchar(60) | NO | | | | | book_date | datetime | NO | | | | +------------------+-------------+------+-----+---------+----------------+ 5 rows in set (0.08 sec) mysql>