TAIL
Given:
CREATE TABLE log_entries (
id int primary key auto_increment,
ts datetime not null,
log varchar(255) not null
);
The SQL:
.tail ts, log from log_entries every 30;
Will:
* Find the column 'id', which is the only primary key and is auto_increment
* Find the current auto_increment value of id as last_seen_max_value
* Loop:
- sleep 30 seconds
- select ts, log from log_entries where id > last_seen_max_value
- update last_seen_max_value
Other recognized forms:
.tail * from log_entries every 30;
.tail log_entries every 30;
.tail log from log_entries where log like '%ERROR%' every 30;