List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 17 2000 11:48pm
Subject:RE: MOTD for databases
View as plain text  
At 4:37 PM -0700 10-17-2000, Daevid Vincent wrote:
>maybe a dumb idea, but could you 'alias' the "mysql" (client) in the shell,
>such that it cat's out a motd file before loading the mysql-client...
>
>something like:
>
>alias mysql "cat /etc/my.motd; /usr/local/bin/mysql"
>
>if you get my meaning. Then just put that alias in /etc/csh.login or
>/etc/bashrc or whatever the shell loads when they login automatically.

That won't help because what he wants is an action that takes place
for particular statements that you issue while you're in mysql, not
before it executes.

>
>
>>  -----Original Message-----
>>  From: Mike Piluso [mailto:mikesp@stripped]
>>  Sent: Tuesday, October 17, 2000 9:54 AM
>>  To: Paul DuBois
>>  Cc: mysql@stripped
>>  Subject: Re: MOTD for databases
>>
>>
>>  Yes, that is what I am trying to do. I dont think its worth the trouble to
>>  go and modify the server software. The reason I want to do this
>>  is display a
>>  message to root users not to delete any records from that table (or
>>  database). It is managed via http programs that use status codes.
>>  Long story
>>  ...
>>
>>  If anyone has any ideas, let me know.
>>
>>  Thanks.
>>
>>  ----- Original Message -----
>>  From: "Paul DuBois" <paul@stripped>
>>  To: "Mike Piluso" <mikesp@stripped>; <mysql@stripped>
>>  Sent: Monday, October 16, 2000 3:48 PM
>>  Subject: Re: MOTD for databases
>>
>>
>>  > At 3:29 PM -0400 10-16-2000, Mike Piluso wrote:
>>  > >Does anyone know if its possible to display a message after
>>  one connects
>>  to
>>  > >OR switches databases?
>>  > >
>>  > >example ...
>>  > >
>>  > >mysql> use virtual
>>  > >Database Changed
>>  > >
>>  > ><Message here>
>>  > >
>>  > >mysql>
>>  > >
>>  > >The purpose would be to notify clients what the table is, and some
>>  > >informational notes.
>>  >
>>  > No, you can't do this.  Not without modifying the server and/or the
>>  > client, at least.  Are you thinking of something analogous to the way
>>  > that some FTP servers display the README file (if there is one) after
>>  > you issue a cd command?
>>  >
>>  > --
>>  > Paul DuBois, paul@stripped
>>  >
>>  > --
>>  > ---------------------------------------------------------------------
>>  > Please check "http://www.mysql.com/documentation/manual.php" before
>>  > posting. To request this thread, e-mail
>>  mysql-thread53410@stripped
>>  >
>>  > To unsubscribe, send a message to:
>>  >     <mysql-unsubscribe-mikesp=bestweb.net@stripped>
>>  >
>>  > If you have a broken mail client that cannot send a message to
>>  > the above address (Microsoft Outlook), you can use:
>>  >     http://lists.mysql.com/php/unsubscribe.php
>>  >
>>  >
>>
>>
>>  --
>>  ---------------------------------------------------------------------
>>  Please check "http://www.mysql.com/documentation/manual.php" before
>>  posting. To request this thread, e-mail mysql-thread53500@stripped
>>
>>  To unsubscribe, send a message to:
>>      <mysql-unsubscribe-daevid=thematrix.com@stripped>
>>
>>  If you have a broken mail client that cannot send a message to
>>  the above address (Microsoft Outlook), you can use:
>>      http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php" before
>posting. To request this thread, e-mail mysql-thread53550@stripped
>
>To unsubscribe, send a message to:
>     <mysql-unsubscribe-paul=snake.net@stripped>
>
>If you have a broken mail client that cannot send a message to
>the above address (Microsoft Outlook), you can use:
>     http://lists.mysql.com/php/unsubscribe.php


-- 
Paul DuBois, paul@stripped
Thread
MOTD for databasesMike Piluso16 Oct
  • Re: MOTD for databasesPaul DuBois16 Oct
  • Re: MOTD for databasesMike Piluso17 Oct
    • RE: MOTD for databasesDaevid Vincent18 Oct
      • RE: MOTD for databasesPaul DuBois18 Oct