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
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
: 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
constraint
constraint
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)》
[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!