Hi, why do I get this message:
Quote:
Error code 0, SQL state 22001: Data truncation: Out of range value for column 'experience' at row 1
Line 1, column 1
|
...when I do:
Code:
INSERT INTO competenceprofiles (id, name, experience, person_id, competence_id)
VALUES (1, 'Administration', 3.5, 2, 1);
...on this table:
Code:
CREATE TABLE competenceprofiles (
id INTEGER PRIMARY KEY,
name VARCHAR(255),
experience NUMERIC(2,2),
person_id INTEGER REFERENCES people,
competence_id INTEGER REFERENCES competences
);
I'm using MySQL 5.1.11.
I'd appreciate any help.
/Kris
dBforums
>
Data truncation?
02-07-10, 20:07
Linear Mode
