On the server, after we have just installed MySQL, there is no way to direct remote, it only supports local login. So we have to set up the MySQL that we just installed to allow remote login.1. Use the "mysql-uroot-p" command to connect to the local
User_event: User Event tableCreate_time: A field that stores time in a table#获取当月数据SELECT * fromUser_eventWHEREDate_format (Create_time,'%y-%m')=Date_format (now (),'%y-%m') #获取3月份数据SELECT * fromUser_eventWHEREDate_format
Mysql-h host Address-u user name-P user password enter MySQL database
Mysqladmin-u username-p Old password password new password Change password
SHOW DATABASES; List Databases
Use database_name using database_name database
Create
Prepare MySQL for vs toolMysql-connector-net-6.8.3.msi Network Address: http://pan.baidu.com/s/1jHDWINkMysql-for-visualstudio-1.1.4.msi Network Address: Http://pan.baidu.com/s/1eSwemnoOpen vs Tools-"library Package Manager-" Package Manager control
In 1.mysql, the inner join and the left join need to optimize the right table, while the starboard join needs to optimize the table.2. Common indexes: Primary key, sort, range, where clauseNo indexes: Big data types, such as text, image, bitBehind
In the last section we learned about the operation of the library, we now know that there is a table in the library, similar to our Excel table, today we are going to learn the operation of the table below! First we log in to the database650)
1. After a successful creation of the stored procedure, use the call stored procedure name to execute the Times error:Illegal mix of collations (utf8_unicode_ci,implicit) and (utf8_general_ci,implicit) errors.Workaround: Check the encoding of the
Temporary table should be stored in memory, is a real table, but may not be visible (at least it only exists in your query process, you only see the result table), memory table The only advantage is the IO fast, but the structure will be simple, no
Index Type:1. General IndexCreate index index_name on test_table (column_name (length));2, unique index, can have a null valueCreate Unique Index on test_table (column_name (length));3, primary key index, can not be empty4, combined index, follow
1, the phenomenon: background from the JSP read the value garbledWorkaround: Add the following in the Web. xml file: encodingFilter class>org.springframework.web.filter.characterencodingfilterclass > encoding utf- 8
Whether the log is enabledMysql>show variables like ' log_bin ';How to know the current logMysql> Show master status;See binary log files with MysqlbinlogShell>mysqlbinlog mail-bin.000001 (to write absolute problem path d://)or Shell>mysqlbinlog
StatementThe Stars last nightBlog:http://yestreenstars.blog.51cto.com/This article by oneself creation, if need reprint, please indicate source, thank cooperation!ObjectiveManually implement MySQL ArchiveDemandA table has a large amount of data, but
The commands for MySQL to modify field types are: Mysql> ALTER TABLE name modify column field name type;Suppose that there is a table in MySQL: Address, which has a field in the initial case of varchar (30), then the modified type char can be
Mysql database usage and understanding (based on ubuntu14.0.4LTS64-bit)1. mysql database composition and related concepts first understand that mysql is a relational database. The biggest difference between mysql and non-relational databases is that
Web project design and development-DBHelper3 and dbhelper3
This course aims to add, delete, modify, and query data in the database based on DBHelper.
The specific content is:
I. Program writing
1. Create a project-Mangage2. Create five packages in
Mysql notes sharing and mysql sharing
Mysql LPAD and RPAD fill functions with insufficient digitsSummarize some features of the mysql databaseMySQL WHERE statement OptimizationMysql limit instance detailsHow does mysql implement multi-table joint
Database introduction, database
1. What is a database?
Database: Database, the medium for efficient data storage and processing (mainly two types of media: disk and memory ).
2. Database Classification
Based on different storage media,
Comparison of various storage engines of mysql DatabasesOne of the most important features of a mysql database that distinguishes it from other databases is its plug-in Table storage engine, which is table-based rather than the InnoDB Storage engine.
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