Database
Ctrlk
  • Introduction
  • Chapter1: MySQL
    • 1.1. MySQL在Max OSX上的筆記
    • 1.2.MySQL for Beginners
      • 1.2.1.Getting the Development Environment Ready
      • 1.2.2.Beginning with MySQL Basics
        • 1.2.2.1.Creating a Database - CREATE DATABASE
        • 1.2.2.2.Creating a Table - CREATE TABLE
        • 1.2.2.3.Inserting Values into Table - INSERT INTO
        • 1.2.2.4.Retrieving Values from Table - SELECT
        • 1.2.2.5.Selecting Distinct Values from Column - DISTINCT
        • 1.2.2.6.Selecting a Specific Data using WHERE Clause
        • 1.2.2.7.Selecting with Multiple Identifiers Using AND
        • 1.2.2.8.Selecting with One of Many Identifiers Using OR
        • 1.2.2.9.Sorting the Data Using ORDER BY
        • 1.2.2.10.Limiting the Data Retrieved Using LIMIT
        • 1.2.2.11.Updating or Modifying Data in a Table Using UPDATE
        • 1.2.2.12.Deleting a Data from a Table Using DELETE
        • 1.2.2.13.Copy table
        • 1.2.2.14.Deleting a Table - DROP TABLE
        • 1.2.2.15.Deleting all values in Table - TRUNCATE TABLE
        • 1.2.2.16.Altering Table Structure - ALTER TABLE
      • 1.2.3.Time to Jump in for More
      • 1.2.4.Few things that Keeps the Database in Shape
      • 1.2.5.Using Joins to Combine Tables
  • Chapter2: MongoDB
  • Chapter3: SQL Server
Powered by GitBook
On this page
  1. Chapter1: MySQL
  2. 1.2.MySQL for Beginners
  3. 1.2.2.Beginning with MySQL Basics

1.2.2.3.Inserting Values into Table - INSERT INTO

Previous1.2.2.2.Creating a Table - CREATE TABLENext1.2.2.4.Retrieving Values from Table - SELECT

Last updated 5 years ago

Was this helpful?

Was this helpful?