I have a couple of questions relating to limits on columns. First, is it OK to use numbers (1,2,3, etc.) as the names of columns? A quick scan of the manual doesn't turn up any such restrictions, but that doesn't mean that there isn't one.
Second, I know that there is a 255 character limit per column, but is there a limit on how many columns can be added at one time, or a limit on how many characters in total can be assigned to columns? The reason for the questions is that I'm trying to create a table with 25 columns, 20 of them using the numbers 1 through 20 as column names and there is a message that says there's an error starting at the column labelled '1'. As it happens, this is also the point where 255 characters would be exceeded. Any help would be appreciated. Rich -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
