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>