mysql> CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12), fax
TINYINT (10) UNSIGNED, state CHAR(2), description VARCHAR(80), sic
VARCHAR(7));
Query OK, 0 rows affected (0.09 sec)
mysql> SHOW TABLES;
Empty set (0.00 sec)
mysql> DESCRIBE faxblast
-> ;
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| Field | Type | Null | Key | Default | Extra |
Privileges |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| company | varchar(100) | YES | | NULL | |
select,insert,update,references |
| phone | varchar(12) | YES | | NULL | |
select,insert,update,references |
| fax | tinyint(10) unsigned | YES | | NULL | |
select,insert,update,references |
| state | char(2) | YES | | NULL | |
select,insert,update,references |
| description | varchar(80) | YES | | NULL | |
select,insert,update,references |
| sic | varchar(7) | YES | | NULL | |
select,insert,update,references |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
6 rows in set (0.01 sec)
mysql> use mysql
Database changed
mysql> use pcdocrx
Database changed
mysql> DESCRIBE faxblast;
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| Field | Type | Null | Key | Default | Extra |
Privileges |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
| company | varchar(100) | YES | | NULL | |
select,insert,update,references |
| phone | varchar(12) | YES | | NULL | |
select,insert,update,references |
| fax | tinyint(10) unsigned | YES | | NULL | |
select,insert,update,references |
| state | char(2) | YES | | NULL | |
select,insert,update,references |
| description | varchar(80) | YES | | NULL | |
select,insert,update,references |
| sic | varchar(7) | YES | | NULL | |
select,insert,update,references |
+-------------+----------------------+------+-----+---------+-------+-------
--------------------------+
6 rows in set (0.00 sec)
mysql> SHOW TABLES;
Empty set (0.00 sec)
Someone please explain to my why this is happening?
In fact, could someone explain this too?;
# mysql -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 66 to server version: 3.23.28-gamma
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
+----------+
7 rows in set (0.00 sec)
mysql> SHOW TABLES;
ERROR 1046: No Database Selected
mysql> use mysql
Database changed
mysql> SHOW TABLES;
Empty set (0.00 sec)
mysql> quit
Bye
[root@localhost /tmp]# ls /usr/local/var/
total 20k
4.0k drwx------ 2 root root 4.0k Dec 2 20:20
PC_Doctor_RX.orig/
4.0k drwx------ 2 root root 4.0k Dec 2 11:02 mysql/
4.0k -rw-r--r-- 1 root root 5 Nov 29 16:26 mysqld.pid
4.0k drwx------ 2 root root 4.0k Dec 2 20:29 pcdocrx/
4.0k drwx------ 2 root root 4.0k Nov 30 12:01 ulog/
Vern H. Gill
State Director
Director of Marketing
Conejo Valley Jaycees
http://www.conejovalleyjaycees.org
---------------------------------------------------------------------
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
