1.mysql Case Sensitive Configuration
MySQL case sensitive configuration related to two parameters,Lower_case_file_system and lower_case_table_names.
View the current case-sensitive configuration of MySQL
Show global variables like '%lower_case% '; +
Note: The main content of this article is referenced from Internet related articles1.MySQL Case Sensitive RulesIn MySQL, a library will correspond to a folder, the library of the table will be stored in the folder in the file, so the sensitivity of
After replicating the portal database in the development environment to the new environment today, there is a phenomenon that the primary key cannot be found when using the Sqlsugar ORM Framework for database operations. The key point was discovered
First, test analysis
Test demand sources
Development requirements Dr; Agreement standard requirements PR; user demand ur; case base requirements LR; competition demand CR; Sr. demand for succession;2. Test Item Analysis StepsA. Number
Reprint Test Case ReviewThe first thing to know is the definition of internal review, the internal review of the Test team, or the review within the project team. The review is defined differently and the content is not the same.I. Review
The use case diagram is used to describe the relationship between users, requirements, and system functional units. It shows a system function model diagram that can be observed by external users.
[PURPOSE]: help the development team understand the
Definition: Make sure that a class has only one instance and instantiate it and provide this instance to the entire system.Type: Creating class ModeClass Diagram:
Class diagram Knowledge Points:1. Class diagram is divided into three parts, which
Frequently encountered problems, some are not particularly important but more depressed things. For example today this MySQL is case sensitive. First, the test results.Linux environment, not under Windows platform. The difference is very big.
Copy codeThe Code is as follows:-- Simple Case FunctionCASE sexWHEN '1' THEN 'male'WHEN '2' THEN 'female'ELSE 'others' END-- Case search functionCase when sex = '1' THEN 'male'WHEN sex = '2' THEN 'female'ELSE 'others' END These two methods can
-- Simple Case FunctionCASE sexWHEN '1' THEN 'male'WHEN '2' THEN 'female'ELSE 'others' END-- Case search functionCase when sex = '1' THEN 'male'WHEN sex = '2' THEN 'female'ELSE 'others' END
These two methods can achieve the same function. Simple
Black box testing test case design methods include: equivalence classification, Boundary Value Division, cause and error analysis,
The white-box test case design methods include statement coverage, decision coverage, condition coverage,
Next
4. Conditional update.
For example, the following update conditions are available:
For employees with a salary of more than 5000, the salary is reduced by 10%.
Employees with salaries between 2000 and 4600 increase by 15%
-- Simple Case FunctionCASE sexWHEN '1' THEN 'male'WHEN '2' THEN 'female'ELSE 'others' END-- Case search functionCase when sex = '1' THEN 'male'WHEN sex = '2' THEN 'female'ELSE 'others' END
These two methods can achieve the same function. Simple
What is a use case? What is the scenario under which the use case, and what role does the case play in software modeling? A simple understanding of a use case is what a user can do with the system, and the use case simply describes what he can do,
The problem that arisesAlternative streams, also known as alternative event streams, are alternativeflow in English. in RUP and UML . An explanation of the alternate stream is as follows: The alternate event stream contains the behavior of optional
Swift can match the values of different data types in the switch:
var things = any[] () things.append (0) things.append (0.0) things.append (a) things.append (3.14159) things.append ("Hello ") Things.append ((3.0, 5.0)) Things.append (Movie
Here is an example of using the case function to complete this function
Case has two formats. Simple case function and case search function.--Simple Case function
Case
Sex
When ' 1 ' then ' male '
When ' 2 ' Then ' woman '
Else '
Linux environment, not under Windows platform. The difference is very big. Attention.A picture wins thousand words mysql> show create table ac;+-------+--------------------------------------------------------------- ---------------------------------
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.