Re: A couple of questions

[Todd Wease <twease () sourcefire com>]

Hi funky,

"schema" is a reserved word in MySQL.  To show the contents of the table
try:

mysql> select * from `schema`;

note backticks not single quote, or

mysql> select * from <database_name>.schema;


Todd


funky wrote:
> Joel Esler escribió:
>   
> > On Nov 22, 2008, at 10:48 PM, funky wrote:
> >
> >     
> > > Hello guys,
> > >
> > > I got a couple of questions:
> > >
> > > -first: why can't I use mysql and -A parameter together?
> > > when I use -A fast then snort doesn't connect to mysql
> > >       
> > Command line overrides the snort.conf file.
> >
> >     
> > > -second: is this normal?
> > >       
> > And intentional.
> >
> >     
> > > mysql> select * from 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
> > >
> > > that table only has a couple of fields, an int and a datatime.
> > >
> > > I'm using OpenBSD 4.3 and Snort 2.8.0.1 from packages.
> > >       
> > What version of mysql?
> >     
>
> It's 5.0.51a
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> 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
>   


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
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