Next Section: 建表案例2624 plays

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

Chuanzhi Podcast Liu Daocheng MySql series video tutorials

Introduction >
ChapterCourseware
Chapter1Chuanzhi Podcast Liu Daocheng MySql series video tutorials

Database concepts

19 minutes19 seconds

mysql entry statement

43 minutes17 seconds

Introduction to add, delete, modify and query statements

20 minutes09 seconds

Bytes and storage range of integer columns

39 minutes23 seconds

Optional attributes for integer columns

22 minutes29 seconds

floating point column

26 minutes11 seconds

character column

29 minutes45 seconds

Datetime column type

46 minutes06 seconds

Table creation case

11 minutes13 seconds

Detailed explanation of syntax for adding, deleting and modifying

30 minutes53 seconds

Install ecshop and phpMyAdmin

31 minutes45 seconds

Stage summary (1)

17 minutes24 seconds

Detailed explanation of where

31 minutes40 seconds

Detailed explanation of group

31 minutes42 seconds

having detailed explanation

19 minutes19 seconds

mysql written test questions

09 minutes59 seconds

orderby.limit use

35 minutes39 seconds

5 pitfalls in using clauses

23 minutes00 seconds

where type subquery

16 minutes28 seconds

from subquery

18 minutes22 seconds

exists subquery

12 minutes48 seconds

Stage summary (2)

13 minutes31 seconds

union

54 minutes05 seconds

Join query concept and left join syntax

42 minutes22 seconds

The difference between left and right inner joins

37 minutes59 seconds

Left connection written test questions

24 minutes29 seconds

Addition, deletion and modification of columns in table management

14 minutes43 seconds

view

57 minutes58 seconds

Character sets and proofreading sets

47 minutes00 seconds

Stage summary (3)

27 minutes11 seconds

Basic concepts of triggers

12 minutes29 seconds

trigger syntax

27 minutes41 seconds

Trigger practice (order and inventory management)

28 minutes46 seconds

The difference between before and after

14 minutes00 seconds

Storage engine and transaction concepts

37 minutes22 seconds

transaction syntax

21 minutes21 seconds

Database backup and recovery

29 minutes47 seconds

Index concept

31 minutes00 seconds

Index management

29 minutes09 seconds

Full-text indexing and stop words

32 minutes53 seconds

stored procedure

19 minutes47 seconds
  • CancelreplySending
  • Cancelpost a noteSending