Mysql> \P less
PAGER set to less
Mysql> show tables;
You can see other cool flags by typing 'help;' at the mysql prompt.
On Mon, 4 Oct 2004 14:58:29 -0700, OMalley, Brent
<[EMAIL PROTECTED]> wrote:
> I am a beginner, so forgive me.
>
> From mysql if I type:
>
> Mysql>show tables;
>
> The resu
At 4:00 7/27/04, Paul DuBois wrote:
>
>At 16:22 -0500 7/26/04, Ghate, Shishir wrote:
>>I looked at the SHOW COLUMNS statement and they have what I want,
>>but I need to condition off them. For example, I don't want to
>>execute an ALTER TABLE command to add a column if that column is
>>already
On Thu, 23 Sep 2004 17:20:17 -0700, Kyle Kirkland <[EMAIL PROTECTED]> wrote:
>
> Any chance 'IF EXISTS' being added to the 'ALTER TABLE' statements?
> It sure would be nice to execute something like:
>
> ALTER TABLE tmp ADD INDEX joy ( to, the, world
