Spaces instead of tabs not applying to create/alter code

[expired user #4867]'s profile image [expired user #4867] posted 12 years ago in General Permalink
The setting for using spaces instead of tabs doesn't apply to the code generated for create and alter statements. Is it possible to change that?
ansgar's profile image ansgar posted 12 years ago Permalink
That space-to-tab feature converts tabs which were typed via keyboard, not those which get prefilled by some automatic feature. These are two different things. But however, highly cosmetic if you ask me.
[expired user #4867]'s profile image [expired user #4867] posted 12 years ago Permalink
I use HeidiSQL to get create and alter statements from a master database which is then applied to other servers through the commandline.

Tab characters conflicts with MySQLs default rehashing feature.

This is one of the few situations that the "tab/spaces" argument has a functional side effect--spaces are always safe, tabs are not. It's not a personal preference (although I am a "space" man).

Currently we have to make a conscience effort to replace tabs with spaces before recording SQL in our documents to ensure they always work.
[expired user #4867]'s profile image [expired user #4867] posted 12 years ago Permalink
No chance then? I really thought that because tabs makes SQL statements less portable was good justification.

Please login to leave a reply, or register at first.