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:
Mysqlshow tables;
The result scrolls
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 there.
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 ) IF EXISTS;
Make that 'IF NOT EXISTS'. Sorry