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 |
+---------------------------------------------------------------------+
