I think it would depend on what you are going to do with the
data once it is in the database. If it will only ever be used as a pure
text field, then leaving it as a varchar would not be bad. On the other
hand, if you want to be able to use any of the date fucntions or use it
as a date in
Yes, the sql_yacc.y is used to generate the sql parser. The
parser is used more to "run" the sql rather than to break it into its
tokens. Using the lex files would be closer to your stated goals. The
file lex.h in the same directory as sql_yacc.y contains all the tokens
mysql uses to break