I make such a SQLite query:

INSERT INTO events ( id, Date_Fixing, Date_Generation, Source, Event_Type, Event, Alert, Original_Event_Text ) VALUES ( NULL, 'пт авг. 12 19:26:53 2016', 'пт авг. 12 19:26:53 2016', '1', '4', 'Событие НСД: РМО01. Перебор пароля пользователя: v_ivanov', '1', '<85>login[5077]: TOO MANY LOGIN TRIES (3) on '/dev/tty1' FOR 'v_ivanov' ' );

Displays the following error: Error: near line 1: near "'FOR'": syntax error

How can you somehow perform this request with the characters ''?

  • and tried to use "" or \ '? - pavel

1 answer 1

Duplicate quotes.

 INSERT INTO events ( id, Date_Fixing, Date_Generation, Source, Event_Type, Event, Alert, Original_Event_Text ) VALUES ( NULL, 'пт авг. 12 19:26:53 2016', 'пт авг. 12 19:26:53 2016', '1', '4', 'Событие НСД: РМО01. Перебор пароля пользователя: v_ivanov', '1', '<85>login[5077]: TOO MANY LOGIN TRIES (3) on ''/dev/tty1'' FOR ''v_ivanov'' ' );

For single quotes in a row