RE: underscore character?

[David Shelley]

The underscore is a valid character.
Maybe it's the FLOAT(1) that's causing a problem.

-----Original Message-----
From: Chris Webster [mailto:chris@stripped]
Sent: Tuesday, June 10, 2003 9:09 PM
To: mysql@stripped
Subject: underscore character?


I'm getting an error with "create table", appears that field names 
cannot have the underscore character.  Is this correct?  It would be 
quite fatal for us, as we need some sort of delimeter character, so we 
can group variables by instrument.

You have an error in your SQL syntax near 'A2DEE1_RWO FLOAT(1),

-- 
--Chris