RE: Column type

2003-11-18 Thread Arcadius
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

RE: sql parser

2003-11-09 Thread Arcadius
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