December 2003
Beginner
648 pages
14h 1m
English
| Q1: | What characters can I use to name my tables and fields, and what is the character limit? |
| A1: | The maximum length of database, table, or field names is 64 characters. Any character that you can use in a directoryname or filename, you can use in database and table names—except / 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. |
| Q2: | Can I use multiple functions in one statement, such as making a concatenated string all uppercase? |
| A2: | Sure—just be mindful of your opening and closing parentheses. This example shows how to uppercase the concatenated first and last names from the master ... |
Read now
Unlock full access