1. Home
  2. Programming
  3. PHP, MySQL and Apache in 24 hours

Q&A

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 directory 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.



    		Part I: Getting Up and Running
    		Part II: Basic Language Elements
    		Hour 4. The Building Blocks of PHP
    		Hour 5. Flow Control Functions in PHP
    		Hour 6. Working with Functions
    		Hour 7. Learning Basic SQL Commands
    		Learning the MySQL Data Types
    		Learning the Table Creation Syntax
    		Using the 'INSERT' Command
    		Using the 'SELECT' Command
    		Using 'WHERE' in Your Queries
    		Selecting from Multiple Tables
    		Using 'JOIN'
    		Using the 'UPDATE' Command to Modify Records
    		Using the 'REPLACE' Command
    		Using the 'DELETE' Command
    		Summary
    		Q&A
    		Workshop
    		Hour 8. Interacting with MySQL Using PHP
    		Part III: Getting Involved with the Code
    		Part IV: Simple Projects
    		Part V: Administration and Fine-Tuning