当前课程知识点:MySQL Database Programming > Chapter 8 Web Application Based on PHP and MySQL > Assignment for Chapter 8 > Update the permission table manually
返回《MySQL Database Programming》慕课在线视频课程列表
Since the permission is stored in the corresponding table, if we update the permission table manually, will the MySQL server automatically take effect immediately?If not, what method can be used to make the manually modified permission effective?
返回《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