Posted by JDS on 10/14/58 11:36

On Sun, 01 Jan 2006 15:48:19 -0500, S.Williams wrote:

> and it came up w/another error.. to no suprise.. it said Error 1046 (3D000):
> No database selected. so here is an idea of where i'm at and what i'm trying
> to do. but i think it is because of the PHP.. i dunno. help!


Your errors have nothing to do with PHP.

My question to you is, do you need to learn *SQL* or do you need to learn
*Web Development using SQL and a web-oriented sever language*?

If you only need to learn SQL, then ditch the PHP and Apache stuff -- they
really have nothing to do with SQL, a database interaction language.


To go back to your errors...

1) you created a database:
"create database guestbook;"

And it said "OK"

NOW you need to *USE* the database before you continue:

use guestbook;

THEN you can type the "create table" and other database manipulation
commands.

Also, don't ignore errors!! They are there for a reason!!

Hmmm... I just looked at your post again and you said you did type "use
guestbook". So not sure what the problem is, except it is likely that you
had a typo. Also, MySQL command-line client is CasE SenSiTIve!! Check
your caps lock key.

And finally, try this command:

show databases;

It should show something like this:

mysql> show databases;
+-------------------------+
| Database |
+-------------------------+
| guestbook |
+-------------------------+
1 row in set (0.06 sec)


later...

--
JDS | jeffrey@example.invalid
| http://www.newtnotes.com
DJMBS | http://newtnotes.com/doctor-jeff-master-brainsurgeon/

[Back to original message]