What are the commonly used MySQL English words?

All MySQL English words involved in learning PHP

sql：struct query language

host：host

user：user

password：password

data：data

database：database

table：table

column：column

field：column

row: row

port: port

quit: cancel, exit

exit: exit

charset: character set, character encoding

collate: collation

collation: collation

delimiter: delimiter

create: create

drop: drop, Give up, stop

exists: Exists

int type

tinyint type

smallint type

mediumnint type

biging type

unsigned unsigned

zerofill filling 0

float: single precision floating point type

double: double precision floating point type

decimal: decimal type, decimal type

numeric: number

fixed: fixed type

char: fixed-length character type

varchar: Variable length character type

binary: binary type

enum: enumeration type

set: multi-selection type

bit: bit type

primary key: primary key

unique key: unique key

auto_increment: self-increment

default: default value

comment: comment, 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 rename

view view

insert insert

value value

replace replace

select select

load load

delete delete

from from ...

order order

limit limit

truncate

query query

distinct distinguish

where where

group group

as as

in in

like as

count quantity, count

avg average

max max

min min

sum sum

asc ascending

desc descending

join connection

inner internal

cross cross

left: left side

right: right side

outer Outside

in: inside...

any: any one

all: all

some: part of it

union: Union

identify: confirm, identify

grant: grant

revoke: revoke, cancel, repeal

privilege: permission

start：Start

transaction：Transaction

autocommit：Autocommit

begin：Start

end：End

commit: entrustment, commitment, guarantee

rollback: rollback

case: in... situation

loop: loop

while: when.. When

repeat: repeat

leave: leave

declare: declare

call: call

procedure: stored procedure

trigger：Trigger

The above is the detailed content of What are the commonly used MySQL English words?. For more information, please follow other related articles on the PHP Chinese website!