List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:May 1 1999 7:55pm
Subject:Warning?
View as plain text  
Darrell Shifflett writes:

 > 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

Dear Darrell,

Please provide more information about the table you
are updating. 

mysql> show fields from table_name;
mysql> select * from table_name where keyword = "MySQL";
mysql> update table_name set approved = "Yes" where keyword = "MySQL";
mysql> select * from table_name where keyword = "MySQL";)

If the field 'approved' is for example a varchar(2) field,
you'll get a warning about a truncated data. (Yes -> Ye)

Regards,

- Jani

 > 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.
 > > 
 > > 
 > 
 > 
 > ---------------------------------------------------------------------
 > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
 > posting. To request this thread, e-mail mysql-thread2726@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.

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___       ==  mysql@stripped         |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped      |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+
Thread
Detect if field existPoul Christiansen27 Apr
  • Re: Detect if field existFred Read27 Apr
    • Warning?Darrell Shifflett1 May
      • Warning?Jani Tolonen2 May