1.2.2.Beginning with MySQL Basics

1.2.2.Beginning with MySQL Basics

Menu

• 1.Creating a Database - CREATE DATABASE

• 2.Creating a Table - CREATE TABLE

• 3.Inserting Values into Table - INSERT INTO

• 4.Retrieving Values from Table - SELECT

• 5.Selecting Distinct Values from Column - DISTINCT

• 6.Selecting a Specific Data using WHERE Clause

• 7.Selecting with Multiple Identifiers Using AND

• 8.Selecting with One of Many Identifiers Using OR

• 9.Sorting the Data Using ORDER BY

• 10.Limiting the Data Retrieved Using LIMIT

• 11.Updating or Modifying Data in a Table Using UPDATE

• 12.Deleting a Data from a Table Using DELETE

• 13.Copy table

• 14.Deleting a Table - DROP TABLE

• 15.Deleting all values in Table - TRUNCATE TABLE

• 16.Altering Table Structure - ALTER TABLE