Home Logo
Show Full Menu
Hide Full Menu
 

Creating a Table

Created: 26/10/10 Views: 2308 myFave Image


In this tutorial we will learn how to create a MySQL table

To create a database using SQL
  1. CREATE TABLE tableName (
  2. entityName DATATYPE NULL/NOT NULL, AUTO_INCREMENT
  3. entityName DATATYPE NULL/NOT NULL, DEFAULT 'defaultValue'
  4. entityName DATATYPE(length/value) NULL/NOT NULL,
  5. entityName DATATYPE NULL/NOT NULL,
  6. PRIMARY KEY (entityName)
  7. )



next tutorial: Inserting Data

There are no comments