Modify my. ini file. Add the following set-variable = lower_case_table_names = 0 (0: Case Sensitive; 1: Case Insensitive) to the mysqld section and restart the mysql service.
1. lower_case_tables_name = 0 (default in linux)Start the mysql tutorial
Mysql tutorial Modify Table/field Add/delete table Index
Create table test (blob_col blob, index (blob_col (10); in mysql 5.1, for myisam and innodb tables, the prefix length can reach 1000 bytes. Note that the prefix limit should be measured in
Differences between Truncate and delete in mysql clearing tables this article demonstrates how to use the TRUNCATE command and the differences between delete and truncate. The following describes how to delete all data instances in a mysql
The following describes two methods for importing excel Data to the mysql database. These two methods are simple and convenient, in the past, I used php programs to import excel Data to mysql databases. Now we don't need a program, just use the
The job needs to query the data of this month and this month for ranking. Take a closer look at the date format stored in the database, which is, in this way, I thought that the query method of the database by second would not work. I found a date
Grouping statistics statement for SQL data by day and month
Grouping statistics statement for SQL data by day and month/*In the database tutorial orders table, there is a "total" and a "createtime" field. Now we want to get the total of every day of
Table table1Id RegName PostionSN PersonSN1 Shandong Qilu pharmaceutical 223 22 Shandong Qilu pharmaceutical 224 23 Beijing Urban Construction Company 225 24 technology companies 225 2
The result I want to obtain is
Id RegName PostionSN PersonSN1
Create a stored procedure in the mysql tutorial"Pr_add" is a simple mysql stored procedure, which has two int-type input parameters: "a" and "B", and returns the sum of the two parameters.
Drop procedure if exists pr_add;
-- Calculate the sum of
The and or operators are used to filter records based on more than one condition.And or operators
And or can combine two OR more conditions in the WHERE substatement.
If both the first AND second conditions are true, the AND operator displays a
Technical solution 1:The first version written by the programmer during the compression time is used to complete the task without any optimization from the program. The implementation method is to use the database tutorial class to call the stored
1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.
2. Try to avoid null value determination on the field in the where clause. Otherwise, the engine will discard
Mysql drop table, create index, drop indexDROP [TEMPORARY] TABLE [if exists] tbl_name [, tbl_name,...][RESTRICT | CASCADE]Drop table removes one or more tables. All data and table definitions are removed, so be sure to use this command with caution!
Where clause is ambiguous
Where clause is ambiguousThe error message "Column 'languageid' in where clause is ambiguous" appears during a query using the mysql database, this error in where clause is ambiguous is probably caused by the fact that a
SQL multi-Table query
Select distinct (. name, B. name), COUNT (Electric Appliance sales revenue + special monthly sales revenue) as monse, COUNT (Electric Appliance sales revenue + special annual sales revenue) as year FROM a, B WHERE. id = B.
1. Use indexes to traverse tables faster. The index created by default is a non-clustered index, but sometimes it is not optimal. In a non-clustered index, data is physically stored on the data page randomly.Reasonable index design should be based
SQL classification:DDL-Data Definition Language (Create, Alter, Drop, DECLARE)DML-data manipulation language (Select, Delete, Update, Insert)DCL-Data Control Language (GRANT, REVOKE, COMMIT, ROLLBACK)
First, we will briefly introduce the basic
1. mysqldump1.1 backupMysqldump adopts an SQL-level backup mechanism. It imports data tables into SQL script files and is suitable for upgrading between different MySQL versions. This is also the most common backup method. Here are some main
Bidirectional encryptionLet's start with the simplest encryption: two-way encryption. Here, a piece of data is encrypted by a key and can only be decrypted by the person who knows the key. MySQL has two functions to support this type of encryption:
Mysql database functions
Query statement:SELECT field name FROM table name.Sort order by field name to be sorted desc: query in reverse order.The number of limit queries starting from the specified number: the specified number.Separate multiple
Mysql saves data that web developers use every day. Let's take a look at the tutorial on using the insert statement.
When data is put into a MySQL table, it is called inserting data. When inserting data, it is important to remember the exact name
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service