Hello,
I am working on Database not for a long time. From SQLITE Tutorial exam
table :*
->> Why is it possible to change data not defined in the constraint :
Exemple : enter TEXT if the column is INTERGER ??
enter 25 caracters if column is declared VARCHAR(15) ??
I thought i will get an error return
See exemple below :
sqlite> pragma table_info('exam');
0|ekey|INTEGER|0||1
1|fn|VARCHAR(15)|0||0
2|ln|VARCHAR(30)|0||0
3|exam|INTEGER|0||0
4|score|DOUBLE|0||0
5|timeEnter|DATE|0||0
sqlite> select * from exam;
1|Bob|Anderson|1|75.0|2009-02-24 09:41:04
2|Bob|Anderson|2|82.0|2009-02-24 10:11:45
sqlite> UPDATE main.'exam' SET fn='Bob12345678901234567890' WHERE ekey =
'1';
sqlite> UPDATE main.'exam' SET exam='NN' WHERE ekey = '1';
sqlite> select * from exam;
1|Bob12345678901234567890|Anderson|NN|75.0|2009-02-24 09:41:04
2|Bob|Anderson|2|82.0|2009-02-24 10:11:45
sqlite>
Sincères salutations
Maxime REPKA
Tel : 02.31.34.75.65
MailTo:[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
