List:General Discussion« Previous MessageNext Message »
From:Jay J Date:November 24 1999 7:09am
Subject:Re: New to mysql
View as plain text  
----- Original Message -----
From: Bruce Ordway <ordway@stripped>
To: <mysql@stripped>
Sent: Wednesday, November 24, 1999 12:01 AM
Subject: New to mysql

> 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

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)


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

New to mysqlBruce Ordway24 Nov
  • Re: New to mysqlJay J24 Nov