当前课程知识点:MySQL Database Programming > Chapter 4 Data Query and View > 4.2 Condition Query > 4.2.2 Condition Query(2)
返回《MySQL Database Programming》慕课在线视频课程列表
返回《MySQL Database Programming》慕课在线视频列表
-1.1 An Overview of Database
-1.2 Data Model
-1.3 Relation Model
-1.4 Design for Relation Database
--1.4 Design for Relation Database
-Assignment for chapter 1
-2.1 Introduction to MySQL
-2.2 The Configuration of WAMPServer
--2.2 The Configuration of WAMPServer
-2.3 Configuration and management of MySQL
--2.3 Configuration and management of MySQL
-2.4 The Use of MySQL Client
-2.5 Getting Started with Web Applications for MySQL Databases
--2.5 Getting Started with Web Applications for MySQL Databases
-Assignment for Chapter 2
-3.1 Database Operations
-3.2 Data Types
-3.3 Data Table Operations
-3.4 Modify Data Tables
-3.5 Record Operation
-3.6 Index
-Assignment for chapter 3
-4.1 Simple Query
-4.2 Condition Query
-4.3 Connection Query
-4.4 LIMIT and UNION
-4.5 Sort and Group
-4.6 Functions of MySQL
-4.7 Sub Query
-4.8 View
-Assignment for chapter 4
-5.1 Constants and Variables
-5.2 Operators and Expressions
--5.2 Operators and Expressions
-5.3 IF and CASE Statements
-5.4 WHILE Statements
-5.5 LOOP and REPEAT Statements
--5.5 LOOP and REPEAT Statements
-5.6 Cases of Loop and Cursor
--5.6 Cases of Loop and Cursor
-Assignment for chapter 5
-MySQL code and PHP script code
-Can case statement be used to realize single selection in practice?
-What will happen to the Loop if you do not use a Leave statement
-6.1 Introduction to Stored Programs
--6.1 Introduction to Stored Programs
-6.2 Create and Call Stored Procedures
--6.2 Create and Call Stored Procedures
-6.3 Create and Invoke Stored Functions
--6.3 Create and Invoke Stored Functions
-6.4 Manage the Stored Routines
--6.4 Manage the Stored Routines
-6.5 Use Cursors and Transactions in Stored Procedures
--6.5 Use Cursors and Transactions in Stored Procedures
-6.6 Triggers
-6.7 Events
-6.8 Case Study - Stored Programs in a System
--6.8 Case Study - Stored Programs in a System
-Assignment for chapter 6
-7.1 Account Management
-7.2 Privilege Management
--7.2.1 Privilege Management(1)
--7.2.2 Privilege Management(2)
-7.3 Backup and Recovery
-7.4 Log File Management
-7.5 Transaction
-Add User by using SQL statements
-Update the permission table manually
-When turn on logging functions
-How to reduce the probability of deadlock?
-Assignment for Chapter 7
-8.1 An Overview of PHP
-8.2 MySQL Database Connection with PHP
--8.2 MySQL Database Connection with PHP
-8.3 Using PHP to Realize MySQL Database Level Operation
--8.3 Using PHP to Realize MySQL Database Level Operation
-8.4 Using PHP to Realize MySQL Data Table Level Operation
--8.4 Using PHP to Realize MySQL Data Table Level Operation
-8.5 MySQL Web Development Instance
--8.5 MySQL Web Development Instance
-Assignment for Chapter 8