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
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!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.

PHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

PHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.
