Re: view alerts in base

[David Kingsly <davidkingsly () verizon net>]

Thanks.  Here is what I get:
mysql> select * from `schema`;
+------+---------------------+
| vseq | ctime               |
+------+---------------------+
|  107 | 2009-04-01 06:03:14 | 
+------+---------------------+
1 row in set (0.00 sec)


On Tue, 2009-04-21 at 21:48 -0500, Paul Schmehl wrote:
> --On April 21, 2009 8:40:03 PM -0500 David Kingsly 
> <davidkingsly () verizon net> wrote:
>
> > I can not do the query.  I see the table, but it does not work...
> > mysql> show tables;
>
> You misread his instructions.  It's not 'schema' (single quotes).  It's 
> `shema` (backticks);
>
> mysql> describe schema;
> 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 'schema' at line 1
> mysql> describe `schema`;
> +-------+------------------+------+-----+---------+-------+
> | Field | Type             | Null | Key | Default | Extra |
> +-------+------------------+------+-----+---------+-------+
> | vseq  | int(10) unsigned | NO   | PRI | NULL    |       |
> | ctime | datetime         | NO   |     | NULL    |       |
> +-------+------------------+------+-----+---------+-------+
> 2 rows in set (0.00 sec)
>
> Paul Schmehl, If it isn't already
> obvious, my opinions are my own
> and not those of my employer.
> ******************************************
> WARNING: Check the headers before replying


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users