VTC - MySQL 5 Development - Part 2 收录时间:2018-06-08 12:11:11 文件大小:2GB 下载次数:41 最近下载:2021-01-22 04:01:30 磁力链接: magnet:?xt=urn:btih:a362300727c03375ed16f67220b4c9b8be2a90f0 立即下载 复制链接 文件列表 20. Efficiency Checks/20.02. PROCEDURE ANALYSE function.flv 22MB 07. Importing Data/07.08. Importing on the Shell Command Line.flv 19MB 14. Transactions and Locking/14.12. Row Locking Demos.flv 16MB 01. Configuration/01.01. Startup Options.flv 16MB 14. Transactions and Locking/14.13. Explicit Table Locking.flv 16MB 16. Stored Routing Programming/16.23. Limitations on Cursors.flv 15MB 16. Stored Routing Programming/16.22. Declaring Cursors.flv 15MB 03. Inserting Data/03.03. INSERT demonstration.flv 14MB 16. Stored Routing Programming/16.18. The ITERATE Statement.flv 14MB 17. Triggers/17.09. Trigger Limitations.flv 14MB 06. Other MySQL DML Commands/06.07. Safe Updates Mode.flv 14MB 04. Deleting Data/04.03. DELETE with LIMIT.flv 14MB 15. Stored Routine Basics/15.08. Stored Routine Metadata.flv 14MB 03. Inserting Data/03.06. AUTO_INCREMENT issues.flv 13MB 17. Triggers/17.07. Dropping Triggers.flv 13MB 07. Importing Data/07.03. Importing Non-Tab Formats.flv 13MB 09. Multi-Table Queries/09.01. Addressing Multiple Tables.flv 13MB 12. Views/12.10. View Metadata.flv 13MB 18. Events/18.06. Event Metadata.flv 13MB 16. Stored Routing Programming/16.19. More We Can DECLARE.flv 13MB 17. Triggers/17.06. Tigger Metadata.flv 13MB 19. Indexes/19.08. FULLTEXT Indexes pt.1.flv 13MB 16. Stored Routing Programming/16.15. REPEAT Block Demos.flv 13MB 11. Joins/11.02. Join Basics pt.1.flv 13MB 02. Manipulating Data/02.02. Warnings and Errors.flv 13MB 14. Transactions and Locking/14.07. Isolation Levels.flv 13MB 16. Stored Routing Programming/16.12. CASE Block Demos.flv 13MB 08. Deriving New Tables/08.03. Including Other Features.flv 13MB 14. Transactions and Locking/14.10. Locking in MySQL.flv 13MB 15. Stored Routine Basics/15.02. Why Use Stored Routines.flv 13MB 08. Deriving New Tables/08.06. Temporary Tables.flv 12MB 13. Multiple Table DML Operations/13.04. Advantages and Limitations to Multi-Table UPDATEs and DELETEs.flv 12MB 10. Subqueries/10.02. Shape of The Result.flv 12MB 05. Updating Data/05.01. Updating Data.flv 12MB 01. Configuration/01.02. Configuration File.flv 12MB 03. Inserting Data/03.07. LAST_INSERT_ID function.flv 12MB 07. Importing Data/07.05. Changing Import Column Order.flv 12MB 14. Transactions and Locking/14.11. Explicit Row Locking with InnoDB.flv 12MB 08. Deriving New Tables/08.02. CREATE TABLE Using SELECT.flv 12MB 18. Events/18.01. Event Basics.flv 12MB 01. Configuration/01.03. Important Configuration Options.flv 12MB 14. Transactions and Locking/14.01. Transaction Basics.flv 12MB 18. Events/18.02. Event Execution.flv 12MB 05. Updating Data/05.03. UPDATE with LIMIT.flv 11MB 16. Stored Routing Programming/16.17. The LEAVE statement.flv 11MB 06. Other MySQL DML Commands/06.06. TRUNCATE TABLE Demonstration.flv 11MB 14. Transactions and Locking/14.03. AUTOCOMMIT Mode.flv 11MB 07. Importing Data/07.01. Importing Data.flv 11MB 07. Importing Data/07.02. Basic Import Demonstrations.flv 11MB 14. Transactions and Locking/14.09. Locking.flv 11MB 08. Deriving New Tables/08.01. New Tables From Existing Tables.flv 11MB 02. Manipulating Data/02.05. Elevating Warnings to Errors.flv 11MB 11. Joins/11.04. Inner Join Syntax.flv 11MB 13. Multiple Table DML Operations/13.01. Multiple Table INSERT.flv 11MB 16. Stored Routing Programming/16.01. Compound Statements.flv 11MB 15. Stored Routine Basics/15.09. Where They Are Stored.flv 11MB 16. Stored Routing Programming/16.10. Conditional Blocks.flv 11MB 18. Events/18.03. Event Syntax.flv 11MB 16. Stored Routing Programming/16.09. Variable scope.flv 11MB 02. Manipulating Data/02.03. SQL Modes.flv 11MB 14. Transactions and Locking/14.04. Transaction Commands.flv 11MB 19. Indexes/19.01. Index Basics.flv 11MB 16. Stored Routing Programming/16.11. IF Block Demos.flv 11MB 18. Events/18.04. Schedule Types.flv 11MB 17. Triggers/17.04. Trigger Examples.flv 11MB 14. Transactions and Locking/14.14. Table Locking Demos.flv 11MB 14. Transactions and Locking/14.08. Transaction Demos.flv 11MB 17. Triggers/17.05. Exploring Triggers.flv 11MB 18. Events/18.05. User Accounts for Events.flv 11MB 16. Stored Routing Programming/16.21. Declaring Error Handlers.flv 11MB 11. Joins/11.03. Join Basics pt.2.flv 11MB 14. Transactions and Locking/14.06. Isolation.flv 11MB 10. Subqueries/10.01. Subquery Basics.flv 10MB 22. Credits/22.01. About This Author.flv 10MB 17. Triggers/17.03. Trigger Syntax.flv 10MB 14. Transactions and Locking/14.16. Implicit Commits.flv 10MB 00. Introduction/00.01. Welcome.flv 10MB 16. Stored Routing Programming/16.03. Procedure Parameter Types.flv 10MB 04. Deleting Data/04.02. DELETE with WHERE.flv 10MB 11. Joins/11.12. Multiple Table Joins.flv 10MB 09. Multi-Table Queries/09.05. Resolving Table Name Conflicts.flv 10MB 16. Stored Routing Programming/16.13. Iterative Blocks.flv 10MB 17. Triggers/17.02. Uses for Triggers.flv 10MB 11. Joins/11.05. Basic Inner Join Demos.flv 10MB 13. Multiple Table DML Operations/13.03. Multiple Table DELETE.flv 10MB 14. Transactions and Locking/14.05. Savepoints.flv 10MB 04. Deleting Data/04.04. DELETE with ORDER BY.flv 10MB 11. Joins/11.13. Self Joins.flv 10MB 03. Inserting Data/03.01. Inserting Data.flv 10MB 06. Other MySQL DML Commands/06.02. REPLACE demonstration.flv 10MB 02. Manipulating Data/02.06. Interpreting Error Messages.flv 10MB 03. Inserting Data/03.08. Common INSERT Errors.flv 10MB 11. Joins/11.06. Inner Join Aggregation.flv 9MB 12. Views/12.04. View Column Names.flv 9MB 19. Indexes/19.02. Defining Indexes for a Table.flv 9MB 17. Triggers/17.01. Trigger Basics.flv 9MB 13. Multiple Table DML Operations/13.02. Multiple Table UPDATE.flv 9MB 20. Efficiency Checks/20.03. EXPLAIN command pt.1.flv 9MB 04. Deleting Data/04.01. Deleting data.flv 9MB 16. Stored Routing Programming/16.04. IN Parameters.flv 9MB 15. Stored Routine Basics/15.01. Procedures and Functions.flv 9MB 16. Stored Routing Programming/16.14. LOOP Block Demos.flv 9MB 10. Subqueries/10.03. Guaranteeing a Single Row Result.flv 9MB 06. Other MySQL DML Commands/06.03. ON DUPLICATE KEY UPDATE Option of INSERT.flv 9MB 02. Manipulating Data/02.04. Changing Syntax Interpretation.flv 9MB 03. Inserting Data/03.04. Default Values on Insert.flv 9MB 12. Views/12.03. Basic Syntax of a View.flv 9MB 03. Inserting Data/03.05. AUTO_INCREMENT on insert.flv 9MB 15. Stored Routine Basics/15.03. Basic CREATE FUNCTION syntax.flv 9MB 18. Events/18.07. Event Limitations.flv 9MB 14. Transactions and Locking/14.15. Deadlock Resolution.flv 9MB 05. Updating Data/05.02. UPDATE with WHERE.flv 9MB 06. Other MySQL DML Commands/06.04. ON DUPLICATE KEY UPDATE demonstration.flv 9MB 00. Introduction/00.02. What the Course Will Cover.flv 9MB 07. Importing Data/07.06. Converting Data On Import pt.1.flv 8MB 12. Views/12.02. Uses of Views.flv 8MB 16. Stored Routing Programming/16.08. Assigning Values to Variables.flv 8MB 02. Manipulating Data/02.08. System Error Warnings.flv 8MB 11. Joins/11.08. The USING() function.flv 8MB 14. Transactions and Locking/14.02. Transactions in MySQL.flv 8MB 19. Indexes/19.09. FULLTEXT Indexes pt.2.flv 8MB 06. Other MySQL DML Commands/06.01. Replacing Command.flv 8MB 12. Views/12.05. Updatabale Views.flv 8MB 11. Joins/11.07. The ON Clause.flv 8MB 08. Deriving New Tables/08.07. Altering Derived Tables.flv 8MB 12. Views/12.01. What a View Is.flv 8MB 20. Efficiency Checks/20.05. EXPLAIN command pt.3.flv 8MB 07. Importing Data/07.07. Converting Data On Import pt.2.flv 8MB 05. Updating Data/05.04. UPDATE result messages.flv 8MB 20. Efficiency Checks/20.01. Efficiency Checks.flv 7MB 16. Stored Routing Programming/16.02. Compound statements Demos.flv 7MB 16. Stored Routing Programming/16.07. Declaring Local variables.flv 7MB 15. Stored Routine Basics/15.07. Database Association.flv 7MB 12. Views/12.06. Insertable Views.flv 7MB 11. Joins/11.10. Outer Joins.flv 7MB 09. Multi-Table Queries/09.04. Table Name Conflicts.flv 7MB 17. Triggers/17.08. User Accounts for Triggers.flv 7MB 10. Subqueries/10.05. Table Subqueries.flv 7MB 21. Conclusion/21.01. What We Covered.flv 7MB 10. Subqueries/10.06. Columnar Subqueries.flv 7MB 10. Subqueries/10.10. Correlated vs Non-Correlated Subqueries.flv 7MB 15. Stored Routine Basics/15.10. Dropping Stored Routines.flv 7MB 10. Subqueries/10.14. When to Use Subqueries.flv 7MB 11. Joins/11.11. Join Criteria Options.flv 7MB 20. Efficiency Checks/20.04. EXPLAIN command pt.2.flv 7MB 08. Deriving New Tables/08.04. CREATE TABLE Using LIKE.flv 7MB 12. Views/12.09. Altering or Dropping Views.flv 7MB 16. Stored Routing Programming/16.06. OUT Parameters.flv 7MB 11. Joins/11.09. Natural Joins.flv 7MB 15. Stored Routine Basics/15.04. Invoking a Function.flv 7MB 11. Joins/11.01. The FROM Clause.flv 6MB 09. Multi-Table Queries/09.03. Resolving Column Name Conflicts.flv 6MB 02. Manipulating Data/02.07. Note Warnings.flv 6MB 10. Subqueries/10.12. Building Queries In Layers.flv 6MB 00. Introduction/00.03. System Requirements.flv 6MB 03. Inserting Data/03.02. Inserting Data (Archaic Syntax).flv 6MB 05. Updating Data/05.03. UPDATE with ORDERY BY.flv 6MB 06. Other MySQL DML Commands/06.05. TRUNCATE TABLE Command.flv 6MB 07. Importing Data/07.04. Skipping Header Lines on Import.flv 6MB 15. Stored Routine Basics/15.06. Invoking a Procedure.flv 6MB 16. Stored Routing Programming/16.05. INOUT Parameters.flv 6MB 11. Joins/11.14. Problems Joins Cannot Solve.flv 6MB 19. Indexes/19.06. Prefix Length Indexes.flv 6MB 16. Stored Routing Programming/16.16. While Block Demos.flv 6MB 10. Subqueries/10.04. Scalar Subqueries.flv 6MB 19. Indexes/19.05. Compound Indexes.flv 5MB 15. Stored Routine Basics/15.05. Basic CREATE PROCEDURE syntax.flv 5MB 21. Conclusion/21.02. Where To Go From Here.flv 5MB 12. Views/12.08. View Viability.flv 5MB 09. Multi-Table Queries/09.02. Column Name Conflicts.flv 5MB 10. Subqueries/10.11. Nesting Multiple Levels.flv 5MB 10. Subqueries/10.09. EXISTS Subqueries pt.2.flv 5MB 19. Indexes/19.07. Covering Indexes.flv 5MB 02. Manipulating Data/02.01. Data Manipulation Basics.flv 5MB 12. Views/12.07. View Consistency.flv 5MB 08. Deriving New Tables/08.05. Populating Derived Tables.flv 4MB 10. Subqueries/10.07. Row Subqueries.flv 4MB 04. Deleting Data/04.05. DELETE result messages.flv 4MB 00. Introduction/00.04. Brief Review of Part 1.flv 4MB 19. Indexes/19.04. Dropping Indexes from a Table.flv 4MB 16. Stored Routing Programming/16.20. Declaring Conditions.flv 4MB 10. Subqueries/10.08. EXISTS Subqueries pt.1.flv 3MB 10. Subqueries/10.13. Addressing The Same Table Twice.flv 2MB mysql5dev2.zip 27KB VTC - MySQL 5 Development - Part 2.nfo 7KB