Mysql.com has lots of really good documentation on their syntax, including examples. Join an official mysql forum or mailing list. You'll probably have much better luck there than here. Only a small percentage of FreeRadius users use mysql aswell so your milage here will vary.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Hernan > Sent: Thursday, August 29, 2002 11:01 AM > To: [EMAIL PROTECTED] > Subject: mysql scheme > > > Hello people,i am working on a mysql database scheme, i using > freeradius for accounting purposes and having some problems to create > the right fields in the table radacct to record the > h323-remote-address(vsa 23) atribute > i am creating the table with the file db.mysql.sql from freeradius. > i only added the line h323-remote-address(60) NOT NULL default '' to > capture the vsa 23 and i am getting the following errors: > > > ./mysql -uUSER -pPASSWORD radius < db_mysql.sql ERROR 1064 at > line 15: > You have an error in your SQL syntax near '-remote-address > varchar(60) > NOT NULL default '', PRIMARY KEY (RadAcctId), ' at line 26 > > I know this could be a mysql-sintax related problem but it would be > usefull to have any > help from someone who already has a working mysql scheme (VOIP/vsa 23) > > Thanks in advance > Hernan > > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
