Search

MySQL Prototype/Syntax to Create a Table for Testing with an Auto-increment ID Field

Some times is Not so easy Starting Out in MySQL Development just because there is Not an High-way Prepared to let you Run Quickly.

Here as my "first stone" to make the Developer Life "one plume" Lighter on MySQL I simply leave here a Ready-Made Table Prototype prepared in Rubish like Style.

This is a very simple "Fac-Simile" of SQL for Testing pourposes Fast Table Creation to execute at MySQL prompt:

CREATE TABLE testing
(
    user_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (user_id),
    last_name   VARCHAR(20) NOT NULL,
    first_name  VARCHAR(20) NOT NULL,
    email       VARCHAR(100) NULL
);

Without Thinking about you can simply Copy and Paste it to MySQL Prompt to Star Out with a Simple Testing Ready-Made Table.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer