NxxW0yi0

1DROP TABLE IF EXISTS coordinate;
2CREATE TABLE coordinate
3(
4   id                    int(10) NOT NULL auto_increment,
5   longitude             double(8,4) NOT NULL,
6   latitude              double(8,4) NOT NULL,
7   measurementId         int(10) default NULL,
8   PRIMARY KEY (id),
9   FOREIGN KEY (measurementId) 
10        REFERENCES measurement (id)
11        ON DELETE CASCADE
12); 
13     
14public class Coordinate
15{
16    public Coordinate()
17    {
18
19    }
20
21    public int ID { get; set; }
22
23    public double Latitude { get; set; }
24
25    public double Longitude { get; set; }
26
27    public int MeasurementId { get; set; }
28
29    ...
30} 
31     
32sql = "UPDATE coordinate SET longitude = '" + coordinate.Longitude + "," + " latitude = " + coordinate.Latitude + "," + " measurementId = " + coordinate.MeasurementId + "' WHERE id = " + id.ToString(); 
33     
34sql = "UPDATE coordinate SET longitude = '55,6, latitude = 70,33, measurementId = 2 WHERE id = 2' 
35     
36{
37 "Message": "An error has occurred.",
38 "ExceptionMessage": "Data truncated for column 'longitude' at row 1",
39 "ExceptionType": "MySql.Data.MySqlClient.MySqlException",
40 ...
41} 
42     
43sql = "UPDATE coordinate SET longitude = " + coordinate.Longitude + "," + " latitude = " + coordinate.Latitude + "," + " measurementId = " + coordinate.MeasurementId + " WHERE id = " + id.ToString(); 
44     
45sql = "UPDATE coordinate SET longitude 55,6 latitude = 70,33, measurementId = 2 WHERE id = 2" 
46     
47{
48 "Message": "An error has occurred.",
49 "ExceptionMessage": "You have an error in your SQL syntax; check the manual 
50 that corresponds to your MySQL server version for the right syntax to use 
51 near '6, latitude = 70,33, measurementId = 2 WHERE id = 2' at line 1",
52}