Chuanzhi Podcast Liu Daocheng MySql series video tutorials

• Chapter1 Chuanzhi Podcast Liu Daocheng MySql series video tutorials
• 1-1 Database concepts
• 1-2 mysql entry statement
• 1-3 Introduction to add, delete, modify and query statements
• 1-4 Bytes and storage range of integer columns
• 1-5 Optional attributes for integer columns
• 1-6 floating point column
• 1-7 character column
• 1-8 Datetime column type
• 1-9 Table creation case
• 1-10 Detailed explanation of syntax for adding, deleting and modifying
• 1-11 Install ecshop and phpMyAdmin
• 1-12 Stage summary (1)
• 1-13 Detailed explanation of where
• 1-14 Detailed explanation of group
• 1-15 having detailed explanation
• 1-16 mysql written test questions
• 1-17 orderby.limit use
• 1-18 5 pitfalls in using clauses
• 1-19 where type subquery
• 1-20 from subquery
• 1-21 exists subquery
• 1-22 Stage summary (2)
• 1-23 union
• 1-24 Join query concept and left join syntax
• 1-25 The difference between left and right inner joins
• 1-26 Left connection written test questions
• 1-27 Addition, deletion and modification of columns in table management
• 1-28 view
• 1-29 Character sets and proofreading sets
• 1-30 Stage summary (3)
• 1-31 Basic concepts of triggers
• 1-32 trigger syntax
• 1-33 Trigger practice (order and inventory management)
• 1-34 The difference between before and after
• 1-35 Storage engine and transaction concepts
• 1-36 transaction syntax
• 1-37 Database backup and recovery
• 1-38 Index concept
• 1-39 Index management
• 1-40 Full-text indexing and stop words
• 1-41 stored procedure