Re: String cuts in column data

[Jon Stephens]

Just wanted to confirm for you that Peter's code is *very definitely* legal SQL in MySQL. If you run it by copying and pasting it into the mysql client (as I just did), you get the following output:

+-----------+--------------+-----------------+------------------------------------------------------------------------+
| @calldate | @contactname | @servicerepname | @comment                                                               |
+-----------+--------------+-----------------+------------------------------------------------------------------------+
| NULL      | venki palama | sudhakar mare   | Please send a picture showing the overlay harness and connections made |
+-----------+--------------+-----------------+------------------------------------------------------------------------+
1 row in set (0.00 sec)

All you need to do at this point is to insert the values into your properly-structured table.

So please do not claim he that did not provide a solution to your problem when in fact he did *just that* and it is obvious that you did not even attempt to make use of it.

cheers,

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle