MySQL-common method for unique serial numbers in databases-MySQL Development Skills (2) Video Tutorial-php.cn

Community

Learn

Tools Library

AI Tools

Leisure

English

Next Section： How to use SQL statements to create serial numbers for special needs (2055 plays)

Watch Again

Chapter

Note

Ask

Feedback

MySQL Development Skills (2) Video Tutorial

Chapter1 Course Introduction
1-1 Course Introduction
Chapter2 How to convert rows and columns
2-1 MySQL-row to column scenario introduction
2-2 MySQL-Requirements Analysis
2-3 MySQL-use the self-join method to convert rows to columns
2-4 MySQL-use CASE method to convert rows to columns
2-5 MySQL-Single column to multiple rows scenario introduction
2-6 MySQL-use the method of serializing tables to convert rows to columns
2-7 MySQL-use UNION method to convert columns to rows
2-8 MySQL-use serialized table method to achieve column conversion
Chapter3 How to generate a unique serial number
3-1 MySQL-common method for unique serial numbers in databases
3-2 How to use SQL statements to create serial numbers for special needs
Chapter4 How to remove duplicate data
4-1 MySQL-Use primary key to delete duplicate data
4-2 MySQL - How to handle complex deduplication

Previous section Next Section

Course Recommendations
Courseware download

Students who have watched this course are also learning