Next Section: MySQL 数值类型2813 plays

5 秒后自动播放下一节
  Watch Again

Geek Academy mysql video tutorial

Introduction >
ChapterCourseware
Chapter1PHP giving MySQL

Introduction and use of MySQL

13 minutes14 seconds

PHP operation MySQL

16 minutes08 seconds

User data query

16 minutes39 seconds

Adding user data and preventing SQL injection attacks

17 minutes31 seconds

Modify user data

16 minutes11 seconds

Delete user data

05 minutes14 seconds
Chapter2MySQL introduction and installation

Introduction to MySQL

04 minutes13 seconds

Install MySQL on a Mac computer

06 minutes49 seconds

Install MySQL on a Windows computer

06 minutes58 seconds

Install MySQL on a Linux computer

07 minutes20 seconds
Chapter3Working with MySQL databases and tables

Create, use and delete MySQL database

06 minutes16 seconds

MySQL database table operations

07 minutes01 seconds

Obtain information about databases and tables and an introduction to database physical files

04 minutes45 seconds
Chapter4MySQL data types

MySQL numeric types

10 minutes51 seconds

MySQL character type

07 minutes43 seconds

MySQL date and time types

05 minutes31 seconds
Chapter5MySQL connect to database

MySQL connects to the database through shell

06 minutes53 seconds

MySQL Connect to the database through MySQL Workbench

04 minutes28 seconds

MySQL Connect to the database through Navicat for MySQL

05 minutes20 seconds
Chapter6MySQL operators

MySQL arithmetic operators

06 minutes32 seconds

MySQL comparison operators

09 minutes46 seconds

MySQL logical operators and bitwise operators

07 minutes05 seconds
Chapter7MySQL operation data

MySQL basic insert data

06 minutes44 seconds

MySQL advanced insert data

08 minutes25 seconds

MySQL update data and delete data

06 minutes21 seconds
Chapter8MySQL function

MySQL math functions and aggregate functions

11 minutes19 seconds

MySQL string functions

08 minutes14 seconds

MySQL date and time functions

04 minutes41 seconds

MySQL data encryption function

09 minutes06 seconds

MySQL control flow functions

06 minutes00 seconds

MySQL formatting functions and type conversion functions

07 minutes14 seconds
Chapter9MySQL joins and unions

MySQL connection concepts and types

05 minutes29 seconds

MySQL cross join, inner join and outer join

11 minutes18 seconds

MySQL self joins and unions

07 minutes58 seconds
Chapter10MySQL subquery

The concept of MySQL subquery

07 minutes53 seconds

Common ways to use MySQL subqueries (1)

07 minutes32 seconds

Common ways to use MySQL subqueries (2)

06 minutes29 seconds
Chapter11Basic concepts of MySQL transactions

Basic concepts of MySQL transaction processing

08 minutes28 seconds

MySQL transaction life cycle

09 minutes23 seconds

Autocommit for MySQL transactions

04 minutes26 seconds
Chapter12MySQL transaction isolation levels and locks

The concept of MySQL transaction isolation level and serialization isolation

10 minutes23 seconds

MySQL transaction isolation levels repeatable read, committed read and uncommitted read

11 minutes57 seconds

MySQL performance and table locking for non-transactional tables

11 minutes10 seconds
Chapter13MySQL management and permission management

Basic tasks of MySQL database management

05 minutes41 seconds

MySQL authorization table

06 minutes06 seconds

MySQL permission control

08 minutes37 seconds
Chapter14Understanding and Application of PDO Objects

PDO object knowledge

12 minutes10 seconds

PDO object initialization

11 minutes07 seconds

PDO object application

12 minutes12 seconds
Chapter15PDO security processing and transaction processing

Course Introduction

01 minutes33 seconds

PDO exception handling

07 minutes43 seconds

PDO preprocessing

14 minutes44 seconds

PDO transaction processing

13 minutes07 seconds
Chapter16PDO project example-student information management system

System introduction and construction

02 minutes54 seconds

Add and view system functions

System function deletion and modification

14 minutes34 seconds
  • CancelreplySending
  • Cancelpost a noteSending