Bug #59172 values of a row diff values of another row in a table
Submitted: 26 Dec 2010 9:01 Modified: 26 Dec 2010 11:16
Reporter: Quốc Hiếu Trần Email Updates:
Status: Not a Bug Impact on me:
Category:Connector / J Documentation Severity:S5 (Performance)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: values of a row diff values of another row in a table

[26 Dec 2010 9:01] Quốc Hiếu Trần
EX: I have a table with 3 columns
Starttime is TimeStamp type
Stoptime is  TimeStamp type
Calltime is  TIME type

Starttime            | Stoptime             | Calltime

2010-26-12 15:00:00  | 2010-26-12 15:02:25  |
2010-26-12 15:03:00  | 2010-26-12 15:07:00  |
2010-26-12 15:09:00  | 2010-26-12 15:15:07  |

Who can help me a syntax: insert values at Calltime colums by Stoptime - Starttime.

How to repeat:
Email: jerrybk108@gmail.com
[26 Dec 2010 11:16] Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.