Create database:

The first command you want to try is the CREATE command in order to create a database.

Syntax:

CREATE DATABASE xxx;

Example:

CREATE DATABASE person;

Create table:

After you created a database, you'll want to add a table:

Syntax:

CREATE TABLE 'xxx' (
col1 datatype option,
);

Example:

CREATE TABLE `Person` (

      `Name` VARCHAR( 150 ) NOT NULL ,

      `Age` INT( 3 ) NOT NULL ,

      `Gender` VARCHAR( 25 ) NOT NULL 

      );

There are no comments on this article.

Leave a message!

If you have any question or just want to leave a message, just fill out the form below!

Your e-mail will not be visible in your post, it is for validation reasons only

Name:
E-mail:
Comment:

About the author [X]

Maffelu

Creator and admin of MorkaLork.com.
Started programming in HTML back when frames and tables was the way to design a page, moved on to Pascal/Delphi, PHP, javascript/jQuery, VB.NET/C#, Java and C++.

Currently studies .NET (in general) focusing on ASP.NET.