I have a table trails in sqlite3 database (that is dealing with bike trails whose schema is:
CREATE TABLE trails (ID integer primary key, name text, city text, state char(2), length integer, ascent integer, difficulty char(2), description text);
And then I try and insert a value into it:
INSERT INTO trails (name, city, state, length, ascent, difficulty, description) VALUES (‘Blue'Sky’,‘Fort Collins’,‘CO’, 6, 300, ‘bg’, ‘cool trail’);
I thought that the data type text would take any kind of string given (even those with strings, such as a paragraph). What is going wrong?
Aucun commentaire:
Enregistrer un commentaire