warnings

[Terry Richards]

mysql 4.1.9-standard
how do i find exactly what the warnings are when i only get
Query OK, 1 row affected, 1 warning (0.00 sec)

:-)^2

[Bill Karwin]

Terry Richards wrote:

how do i find exactly what the warnings are when i only get
Query OK, 1 row affected, 1 warning (0.00 sec)

http://dev.mysql.com/doc/mysql/en/show-warnings.html

Regards,
Bill K.

[Terry Richards]

Bill Karwin wrote:

Terry Richards wrote:

how do i find exactly what the warnings are when i only get
Query OK, 1 row affected, 1 warning (0.00 sec)

http://dev.mysql.com/doc/mysql/en/show-warnings.html

Regards,
Bill K.

been there done that...show warnings:

Query OK, 1 row affected, 4 warnings (0.00 sec)

Query OK, 1 row affected (0.00 sec)

mysql> show warnings;
Empty set (0.01 sec)

where are these warnings stored or how do i get them to go to terminal
is there a way to monitor warnings as the crop up such as
tail -f /var/log/messages ??? i am using macosx 10.2.8 so
/var/log/messages isn't there but is there any other such thing?
:-)^2

[Terry Richards]

Terry Richards wrote:

Bill Karwin wrote:

Terry Richards wrote:

how do i find exactly what the warnings are when i only get
Query OK, 1 row affected, 1 warning (0.00 sec)

http://dev.mysql.com/doc/mysql/en/show-warnings.html

Regards,
Bill K.

been there done that...show warnings:

Query OK, 1 row affected, 4 warnings (0.00 sec)

Query OK, 1 row affected (0.00 sec)

mysql> show warnings;
Empty set (0.01 sec)

where are these warnings stored or how do i get them to go to terminal
is there a way to monitor warnings as the crop up such as
tail -f /var/log/messages ??? i am using macosx 10.2.8 so
/var/log/messages isn't there but is there any other such thing?

shear genius,i inserted the show warnings; in between my script and got:

+---------+------+------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------+
| Warning | 1265 | Data truncated for column 'call_time' at row 1 |
+---------+------+------------------------------------------------+
1 row in set (0.00 sec)

:-) ^2