Introduction

MySQL is software that stores data in tables — like Excel, but many people can use it at once, and you ask questions with SQL. A college app stores students, marks, and fees here. Your website does not keep 10,000 names in a random text file. It asks MySQL: give me the student with roll 12.

SQL is the language. MySQL is one program that understands SQL. Same idea as: English is the language, and two people can both speak it. PostgreSQL and SQL Server also speak SQL, with small differences. In an interview, say: SQL = language, MySQL = the database server.

Picture this. Database = the college cupboard. Table = one register (students). Row = one student (Asha, roll 12, 72 marks). Column = one heading (name, roll, marks). You never mix ‘what is a table’ with ‘what is a row’ in a viva.

You talk to MySQL with statements that end in a semicolon. First week: CREATE TABLE, INSERT a row, SELECT it back. That is enough to prove you understand it. Don’t start with replication or sharding on day one.

Trap: calling MySQL a programming language like Java. Java writes programs. MySQL stores and finds rows. Another trap: saying SQL and MySQL are the same word. They are not.

On the example next to this theory: Introduction: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Diagram

App  ──SQL──►  MySQL server
                    │
                    ▼
              database: college
                    │
                    ▼
              table: students
                    │
                    ▼
         row: Asha | 12 | 72

Exam tip

Say: SQL is the language, MySQL is the database. Then: table of students, one SELECT.

Introduction — sample query

-- Introduction
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Introduction: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefMySQL stores data in tables. You ask questions with SQL.
RuleDatabase → table → row → column. SQL is the language; MySQL is the server.
RememberSELECT name FROM students; is the first real sentence.
Usewebsites, college portals, shops — any app that must remember users.
TrapCalling MySQL ‘a language like Java’.

Introduction

Trap: calling MySQL a programming language like Java. Java writes programs. MySQL stores and finds rows. Another trap: saying SQL and MySQL are the same word. They are not.

On the example next to this theory: Introduction: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Diagram

App  ──SQL──►  MySQL server
                    │
                    ▼
              database: college
                    │
                    ▼
              table: students
                    │
                    ▼
         row: Asha | 12 | 72

Exam tip

Say: SQL is the language, MySQL is the database. Then: table of students, one SELECT.

Introduction — sample query

-- Introduction
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Introduction: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefMySQL stores data in tables. You ask questions with SQL.
RuleDatabase → table → row → column. SQL is the language; MySQL is the server.
RememberSELECT name FROM students; is the first real sentence.
Usewebsites, college portals, shops — any app that must remember users.
TrapCalling MySQL ‘a language like Java’.

Introduction

Introduction — sample query

Short notes

Questions

Introduction

Introduction — sample query

Short notes

Questions