List:General Discussion« Previous MessageNext Message »
From:Darrell Shifflett Date:May 1 1999 6:40am
Subject:Warning?
View as plain text  
What is the *Warning 1* meaning on this entry?

mysql> update table_name set approved = "Yes" where keyword = "MySQL";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1

This works fine, but why a Warning? (curious)

mysql  Ver 9.32 Distrib 3.22.21, for pc-linux-gnu (i686)
RedHat Linux 5.2

Connection id:          90
Current database:       mydb
Current user:           root@localhost
Server version          3.22.21
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 10 days 16 hours 57 min 47 sec

Threads: 2  Questions: 62968  Slow queries: 0  Opens: 223  Flush tables: 1
Open tables: 26
--------------

                                           \\|//
                            ___________ooO_(o"o)_OoO__________
Darrell Shifflett          |                (_)               |
Self Proposed              |   Sometimes the simplest things  |
Linux Freak & PERL Lover   |    in life are often the best    |
                           |                  - Diethyl       |
bluez@stripped         |___________oooO_____Oooo__________|
http://www.BLUEZnet.com                (  )/    ( ,)
                                        \_)     (_/






On Tue, 27 Apr 1999, Fred Read wrote:

> Poul Christiansen wrote:
> > 
> > Is is possible to use a select statement or something to 
> > find out if a specifik field exists in a table?
> 
> It's in the manual;
> 
>     Show columns from table like 'string';
> 
> You may also want to look at;
> 
>     Alter table 
> and
>     Create table
> 
> Read the manual, the manual is your friend...
> -- 
> 
> If it ain't opinionated, it ain't Rich Teer.
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread2485@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 
> 

Thread
Detect if field existPoul Christiansen27 Apr
  • Re: Detect if field existFred Read27 Apr
    • Warning?Darrell Shifflett1 May
      • Warning?Jani Tolonen2 May