Article
Topic
Learning
Download
Q&A
Programming Dictionary
Game
Recent Updates
login
简体中文(ZH-CN)
English(EN)
繁体中文(ZH-TW)
日本語(JA)
한국어(KO)
Melayu(MS)
Français(FR)
Deutsch(DE)
Next Section: MySQL transaction life cycle
(3045 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
Geek Academy mysql video tutorial
Chapter1 PHP giving MySQL
1-1 Introduction and use of MySQL
1-2 PHP operation MySQL
1-3 User data query
1-4 Adding user data and preventing SQL injection attacks
1-5 Modify user data
1-6 Delete user data
Chapter2 MySQL introduction and installation
2-1 Introduction to MySQL
2-2 Install MySQL on a Mac computer
2-3 Install MySQL on a Windows computer
2-4 Install MySQL on a Linux computer
Chapter3 Working with MySQL databases and tables
3-1 Create, use and delete MySQL database
3-2 MySQL database table operations
3-3 Obtain information about databases and tables and an introduction to database physical files
Chapter4 MySQL data types
4-1 MySQL numeric types
4-2 MySQL character type
4-3 MySQL date and time types
Chapter5 MySQL connect to database
5-1 MySQL connects to the database through shell
5-2 MySQL Connect to the database through MySQL Workbench
5-3 MySQL Connect to the database through Navicat for MySQL
Chapter6 MySQL operators
6-1 MySQL arithmetic operators
6-2 MySQL comparison operators
6-3 MySQL logical operators and bitwise operators
Chapter7 MySQL operation data
7-1 MySQL basic insert data
7-2 MySQL advanced insert data
7-3 MySQL update data and delete data
Chapter8 MySQL function
8-1 MySQL math functions and aggregate functions
8-2 MySQL string functions
8-3 MySQL date and time functions
8-4 MySQL data encryption function
8-5 MySQL control flow functions
8-6 MySQL formatting functions and type conversion functions
Chapter9 MySQL joins and unions
9-1 MySQL connection concepts and types
9-2 MySQL cross join, inner join and outer join
9-3 MySQL self joins and unions
Chapter10 MySQL subquery
10-1 The concept of MySQL subquery
10-2 Common ways to use MySQL subqueries (1)
10-3 Common ways to use MySQL subqueries (2)
Chapter11 Basic concepts of MySQL transactions
11-1 Basic concepts of MySQL transaction processing
11-2 MySQL transaction life cycle
11-3 Autocommit for MySQL transactions
Chapter12 MySQL transaction isolation levels and locks
12-1 The concept of MySQL transaction isolation level and serialization isolation
12-2 MySQL transaction isolation levels repeatable read, committed read and uncommitted read
12-3 MySQL performance and table locking for non-transactional tables
Chapter13 MySQL management and permission management
13-1 Basic tasks of MySQL database management
13-2 MySQL authorization table
13-3 MySQL permission control
Chapter14 Understanding and Application of PDO Objects
14-1 PDO object knowledge
14-2 PDO object initialization
14-3 PDO object application
Chapter15 PDO security processing and transaction processing
15-1 Course Introduction
15-2 PDO exception handling
15-3 PDO preprocessing
15-4 PDO transaction processing
Chapter16 PDO project example-student information management system
16-1 System introduction and construction
16-2 Add and view system functions
16-3 System function deletion and modification
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Elementary
Imperial CMS enterprise imitation website tutorial
3048 people are watching
Elementary
Newbies with zero foundation in WordPress build personal blogs and corporate websites
6743 people are watching
Elementary
Ultimate CMS zero-based website building instruction video
2724 people are watching
Elementary
Front-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]
3117 people are watching
Intermediate
Vue3.0 from 0 to build a universal backend management system project practice
5351 people are watching
Elementary
Zero-based front-end course [Vue advanced learning and practical application]
2821 people are watching
Elementary
WEB front-end tutorial [HTML5+CSS3+JS]
3506 people are watching
Elementary
Quick introduction to apipost
2161 people are watching
Intermediate
Vue3+TypeScript practical tutorial-enterprise-level project practice
3208 people are watching
Elementary
Let's briefly talk about starting a business in PHP
17423 people are watching
Intermediate
VUE e-commerce project (front-end & back-end dual project actual combat)
3828 people are watching
Elementary
Apipost practical application [api, interface, automated testing, mock]
2265 people are watching
Students who have watched this course are also learning
492089 plays
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)
notes
X
About us
Disclaimer
Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!