Adding Table and Inserting values

The SQL command used to create a new table in a database typically looks like this: CREATE TABLE table-name (field-name-1 field-type-1 modifiers, field-name-2 field-type-2 modifiers, ... , field-name-n field-type-n modifiers) The table name cannot contain spaces, slashes, or periods; other than this, any character is fair game. Each table (and the data it contains) is stored as a set of three files in your MySQL data directory. Here’s a sample...

Read More