Shulou(Shulou.com)06/01 Report--

This article mainly introduces the commonly used MySQL English words, the article is very detailed, has a certain reference value, interested friends must read it!

Learn all the MySQL English words involved in PHP

Sql:struct query language

Host: host

User: user

Password: password

Data: data

Database: database

Table: tabl

Column: column

Field: column

Row: OK

Port: Port

Quit: cancel, exit

Exit: exit

Charset: character set, character encoding

Collate: collation

Collation: collation

Delimiter: delimiter

Create: creatin

Drop: drop, give up, stop

Exists: exist

Int Typ

Tinyint Typ

Smallint Typ

Mediumnint Typ

Biging Typ

Unsigned unsigned

Zerofill fill 0

Float: single precision floating point type

Double: double precision floating point type

Decimal: decimal type, decimal type

Numeric: numeric

Fixed: fixed typ

Char: fixed length character type

Varchar: variable length character type

Binary: binary type

Enum: enumerating types

Set: multiple selection types

Bit: bit type

Primary key: primary key

Unique key: unique key

Auto_increment: self-growth

Default: default

Comment: comments, description

Index: index

Key: index

Foreign key: foreign key

Fulltext key full-text index

Constraint constraint

Engine storage engine

Alter change

Show display

Describe description

Rename renaming

View view

Insert insertion

Value value

Replace replacement

Select selection

Load loading

Delete deletion

From from.

Order sequence

Limit restriction

Truncate

Query query

Distinct distinguishing

Where's where?

Group group

As as

In is in. Inside

Like is like. The same

Number of count, countin

Avg average

Maximum max

Minimum min

Sum of sum

Asc ascending order

Desc descending

Join connection

Internal to inner

Cross crossover

Left: left

Right: right

Outside the outer.

In: yes. Inside

Any: any one

All: all

Some: some of them

Union: joint

Identify: confirm, identify

Grant: Grant

Revoke: revoke, cancel, abrogate

Privilege: permission

Start: start

Transaction: transaction

Autocommit: auto submit

Begin: start

End: end

Commit: entrust, promise, guarantee

Rollback: rollback

Case: yes. Situation

Loop: cyclin

While: when. When

Repeat: repeat

Leave: leave

Declare: declaration

Call: calling

Procedure: stored procedure

Trigger: trigger

The above is all the contents of the article "what are the commonly used MySQL English words?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.