What characters can I use to name my tables and fields, and what is the character limit?
A
The maximum length of database, table, or field names is 64 characters. Any character that you can use in a directory name or file name, you can use in database and table namesexcept / and .. These limitations are in place because MySQL creates directories and files in your file system, which correspond to database and table names. There are no character limitations (besides length) in field names.
Q
Can I use multiple functions in one statement, such as making a concatenated string all uppercase?
A
Surejust be mindful of your opening and closing parentheses. This example shows how to uppercase the concatenated first and last names from the master name table:
mysql> SELECT UCASE(CONCAT_WS(' ', firstname, lastname)) FROM table_name; +--------------------------------------------+ | UCASE(CONCAT_WS(' ', firstname, lastname)) | +--------------------------------------------+ | JOHN SMITH | | JANE SMITH | | JIMBO JONES | | ANDY SMITH | | CHRIS JONES | | ANNA BELL | | JIMMY CARR | | ALBERT SMITH | | JOHN DOE | +--------------------------------------------+ 9 rows in set (0.00 sec)
If you want to uppercase just the last name, use
mysql> SELECT CONCAT_WS(' ', firstname, UCASE(lastname)) FROM master_name; +--------------------------------------------+ | CONCAT_WS(' ', firstname, UCASE(lastname)) | +--------------------------------------------+ | John SMITH | | Jane SMITH | | Jimbo JONES | | Andy SMITH | | Chris JONES | | Anna BELL | | Jimmy CARR | | Albert SMITH | | John DOE | +--------------------------------------------+ 9 rows in set (0.00 sec)
