|
|
Posted by JDS on 09/28/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/
Navigation:
[Reply to this message]
|