Hi this is just a general question - how do other people organise a large amount of SQL?
I have begun to have a lot of SQL files lying around, used for some data-mining type stuff, & things are getting a bit messy.
I do my best with:
(a) putting user variables at the start of files for anything configurable
(b) putting repeated stuff in separate files & calling with SOURCE
(c) using nice formatting, where you have a line of spaces running down the middle:
http://www.hk8.org/old_web/oracle/prog2/ch03_02.htm
I wonder does anyone else have any good tips?
I was thinking there might be a good pre-processor you could write to make SQL more manageable and less repetitive - perhaps as a MysqlCC plugin. Anyone heard of anything along these lines?
Tom.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
