Re: New to mysql

[Jay J]

----- Original Message -----
From: Bruce Ordway <ordway@stripped>
To: <mysql@stripped>
Sent: Wednesday, November 24, 1999 12:01 AM
Subject: New to mysql


[snip]
> Now at the mysql>
> create table test (name char(10)) \g
>
> This response is generated:
> Query OK, ) rows affected (0.00 sec)
>
> Next I try,
> mysql> show tables
> Nothing, I'm just returned to the mysql> prompt
[snip]

Hi Bruce,

Are you sure it didn't return you to the > prompt, rather than mysql> ?

It's expecting a semi-colon or \g at the end of the statement, or 'go' 'ego'
on the next line.

Try these:

mysql> show tables;
+----------------+
| Tables in test |
+----------------+
| foo            |
+----------------+
1 rows in set (0.01 sec)

OR:

mysql> show tables
    -> ego
*************************** 1. row ***************************
Tables in test: foo
1 rows in set (0.01 sec)

As new as you may be, you've done well to avoid some of other FAQ's .. (i.e.
'access denied ...', can't install, etc)

-Jay J