· 3 years ago · Sep 22, 2022, 01:20 AM
1bash$ sqlite3 mydb.sqlite3
2sqlite> .schema
3CREATE TABLE IF NOT EXISTS "history-fedora" (
4 `RowID` INTEGER NOT NULL UNIQUE,
5 `Username` TEXT DEFAULT 'viking',
6 `Hostname` INTEGER DEFAULT 'slime',
7 `Line` INTEGER DEFAULT 1,
8 `Command` TEXT,
9 PRIMARY KEY(`RowID`)
10);
11sqlite3> .quit
12bash$ cat bong.sql
13INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command') VALUES ("1", 'viking', 'slime',1,"mc" );
14INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command') VALUES ("2", 'viking', 'slime',2,"locate -i fsx.exe" );
15INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command') VALUES ("3", 'viking', 'slime',3,"du -hs .PlayOnLinux" );
16INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command') VALUES ("4", 'viking', 'slime',4,"cd .PlayOnLinux/wineprefix/" );
17INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command') VALUES ("5", 'viking', 'slime',5,"du -hs" );
18bash$ sqlite3 mydb.sqlite3 ".read bong.sql"
19Parse error near line 1: near "(": syntax error
20 INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command
21 error here ---^
22Parse error near line 2: near "(": syntax error
23 INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command
24 error here ---^
25Parse error near line 3: near "(": syntax error
26 INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command
27 error here ---^
28Parse error near line 4: near "(": syntax error
29 INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command
30 error here ---^
31Parse error near line 5: near "(": syntax error
32 INSERT INTO 'history-fedora' AS ('RowID','Username','Hostname','Line','Command
33 error here ---^
34