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.