English MySQL Terminology Glossary (Part 1 & 2)

This article presents a comprehensive English glossary of MySQL terminology, translating Chinese explanations of commands, data types, constraints, and control structures into clear English definitions for developers and database learners.

Term

English Definition sql Structured Query Language, a special‑purpose programming language for querying and managing relational databases. host Host (server address). user User name. password Password.

data

Data.

database

Database.

table

Table.

column

Column.

field

Column (alias).

row

Row.

port

Port number.

quit

Quit, exit.

exit

Exit.

charset

Character set / encoding.

collate

Collation rule.

collation

Collation rule.

delimiter

Delimiter.

create

Create.

drop

Drop, discard, stop.

exists

Exists.

int

Integer type.

tinyint

Tiny integer type.

smallint

Small integer type.

mediumnint

Medium integer type.

biging

Big integer type.

unsigned

Unsigned. zerofill Zero‑fill (pad with zeros).

float

Single‑precision floating‑point type.

double

Double‑precision floating‑point type.

decimal

Decimal (fixed‑point) type.

numeric

Numeric type.

fixed

Fixed type.

char

Fixed‑length character type.

varchar

Variable‑length character type.

binary

Binary type.

enum

Enumeration type.

set

Set (multiple‑choice) type.

bit

Bit type.

primary key

Primary key.

unique key

Unique key. auto_increment Auto‑increment.

default

Default value.

comment

Comment / description.

index

Index.

key

Index (alias).

foreign key

Foreign key.

fulltext key

Full‑text index.

constraint

Constraint. engine Storage engine. alter Alter (modify). show Show. describe Describe. rename Rename. view View. insert Insert.

value

Value. replace Replace. select Select. load Load. delete Delete. from From (source). order Order. limit Limit.

truncate

(no definition provided). query Query. distinct Distinct. where Where (condition). group Group. as As (alias). in In (within). like Like (pattern matching). count Count (quantity). avg Average. max Maximum. min Minimum. sum Sum. asc Ascending order. desc Descending order. join Join. inner Inner. cross Cross.

left

Left.

right

Right. outer Outer.

in

In (within).

any

Any one.

all

All.

some

Some (part).

union

Union.

identify

Identify.

grant

Grant.

revoke

Revoke, cancel.

privilege

Privilege.

start

Start.

transaction

Transaction.

autocommit

Auto‑commit.

begin

Begin.

end

End.

commit

Commit.

rollback

Rollback.

Term

English Definition

case

Case (conditional).

loop

Loop.

while

While (condition).

repeat

Repeat.

leave

Leave (exit loop).

declare

Declare.

call

Call (procedure).

procedure

Stored procedure.

trigger

Trigger.