mysql> elect count(*) from event;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'elect count(*) from event' at line 1
mysql> select * from sensor;
+-----+----------+------------+----------+-----------+-------------+------------+---------------------+--------+------+------------+
| sid | hostname | agent_type | net_name | interface | description | bpf_filter | updated             | active | ip   | public_key |
+-----+----------+------------+----------+-----------+-------------+------------+---------------------+--------+------+------------+
|   1 | ciscoE1  | sancp      | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 20:43:17 | Y      | NULL | NULL       | 
|   2 | ciscoE1  | pads       | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 21:02:47 | Y      | NULL | NULL       | 
|   3 | ciscoE1  | pcap       | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 21:02:48 | Y      | NULL | NULL       | 
|   4 | ciscoE1  | snort      | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 21:02:48 | Y      | NULL | NULL       | 
+-----+----------+------------+----------+-----------+-------------+------------+---------------------+--------+------+------------+
4 rows in set (0.00 sec)

mysql> >select count(*) from sancp;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>select count(*) from sancp' at line 1
mysql> select count(*) from sancp;
+----------+
| count(*) |
+----------+
|    35732 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from event;
+----------+
| count(*) |
+----------+
|      280 | 
+----------+
1 row in set (0.00 sec)

mysql>