MySQL English word summary (PHP novice collection)

In the previous article "PHP English Word Summary (PHP Newbie Collection)", we introduced the commonly used PHP English words involved in learning PHP. Let me share with you all the MySQL English words involved in learning PHP. Hope it helps newbies.

All MySQL English words involved in learning PHP

sql: Structured Query Language is a special purpose A programming language is a database query and programming language used to access data and query, update and manage relational database systems.

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：Fall, give up, stop

exists：Existence

intType

tinyintType

smallintType

mediumnint Type

bigingType

unsignedUnsigned

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 : List type

set: Multiple selection 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

foreign key：Foreign key

fulltext key Full text index

constraintconstraint

engine Storage Engine

alter Change

show Show

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 between

where where

group group

as as

in In...

like Like...

count Quantity, count

avg average

max maximum

min minimum

sum Sum

asc Ascending

desc Descending

join Join

inner Inner

cross Cross

left：Left

right: Right

outer Outside

in: Inside...

any：any one

all：all

some：part of it

union : Joint

identify: Confirm, identify

grant: Grant

revoke: Revoke, cancel, abolish

privilege: Permission

start: Start

transaction ：Transaction

autocommit：Autocommit

begin：Start

end：End

commit：Entrust, promise, guarantee

rollback：Rollback

case：In... .Situation

loop：Loop

while：When...

repeat : repeat

leave : leave

declare : declare

call : call

procedure：Stored procedure

trigger：Trigger

You can learn PHP even if your English is not good, learn PHP related All English words:

《

HTML English word summary (PHP novice collection)》

《

CSS English word summary (PHP novice collection)》

《JavaScript English word summary (PHP novice collection)》

《PHP English word summary (PHP novice collection)》

》 MySQL English word summary (PHP novice collection)》

[Related recommendations: mysql video tutorial, PHP video tutorial】

The above is the detailed content of MySQL English word summary (PHP novice collection). For more information, please follow other related articles on the PHP Chinese website!