CREATE TABLE ceos (name string unique, salary integer, politics string);

...

sqlite> select * from ceos;

name salary politics
---------- ---------- ----------
Jack Welch 1000000 Republican
Carly Fior 5000000 Republican
Erik Schmi 400000 Democrat
Lee Iacocc 3 Democrat
Kim Polese 600000 Republican

CREATE TABLE recorded_salary_changes (id integer primary key autoincrement, content text, time_of datetime, change_by string);

CREATE TRIGGER record_salary_changes update on ceos
begin
insert into recorded_salary_changes(id, content, time_of, changе_by) values(null, "name: " || old.name ||", old salary: " || old.salary || ", new salary: " || new.salary, datetime('now'), "Flunkie");
end;

sqlite> update ceos set salary=999 where name="Lee Iacoca";

Error: table main.recorded_salary_changes has no column named changе_by

What the problem?, i have column names change_by, is it bug???.

zackushka,

there is no mistakes in first column, they was just truncate.

zackushka,

help

White OwlCheck the spelling of field.
Beware that some Cyrillic symbols looks exactly like Latin ones.

If you hate Russian so much, you should learn English better.

Как умею, так и пишу на английском. Спасибо.
Модератор: желтая карточка: пишите на русском, так как вам это доступно