> 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.
Try scanning a bit slower: 6.1.2 Database, Table, Index, Column, and Alias Names ... A name may start with any character that is legal in a name. In particular, a name may start with a number (this differs from many other database systems!). However, a name cannot consist only of numbers. > 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? None related to your trouble. Those limits are much higher than what you're trying to do. Try reading http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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
