A
Size: a a a
A
DE
IZ
A
A
IZ
A
IZ
CREATE TABLE IF NOT EXISTS measurments (
Idmeasurment INT(3) NOT NULL AUTO_INCREMENT PRIMARY KEY,
Datas DATE NOT NULL,
Times TIME NOT NULL,
StationNumb INT(3),
P1 DECIMAL(4,4) NOT NULL,
P2 INT(3) NOT NULL,
P3 INT(3) NOT NULL,
P4 DECIMAL(7,7) NOT NULL,
P5 float null,
UNIQUE UN_measurments (Datas,Times,StationNumb),
INDEX StationNumb_idx (StationNumb ASC)
)
ENGINE = InnoDB;
insert into measurments ( Datas, Times, StationNumb, P1, P2, P3, P4 )
values ( now(), now(), 1, 0.9999, 999, 999, 0.9999999 ),
( now(), now(), 2, 0.1111, 1, 1, 0.0000001 );
UPDATE measurments SET P5 = (3*P1) + (10*P2) + (sin(P4));
SZ
SZ
IZ
SZ
SZ
IZ
IZ
IZ
K