Windows:1. Log into the system with the system administrator.2. Stop the MySQL service.3. Go to the Command window and enter the MySQL installation directory, for example, my installation directory is c:mysql, enter C:mysqlbin4. Skip permission
Schema and data type optimization: 1. Select the optimized data type Smaller is usually better: in general, try to use the smallest data type that can store the data correctly such as: just save 0-200,tinyint unsigned better. Simple: For example,
A problem needing attention1. When the database field is a blob type, the setbinarystream (int,inputstream,int) method in PreparedStatement must be used;2. When the database field is longblob type, you must use the setbinarystream
MySQL max_allowed_packet setting too small causes record write failureMySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter,
1. Stop MySQL service, CMD Open DOS window, enter net stop MySQL2, in the CMD Command Line window, go to MySQL installation directory such as E:\Program files\mysql\mysql Server 5.0\binDemonstration command:Enter e: Carriage return,Enter CD
Multi-Table query:Implementing a multi-table query is to implement table joins:Cross join: (Cartesian product)Example: SELECT * from Student,courses;Natural connection: (inner connection)Natural Connection Examples:SELECT * from Students,course
---restore content starts---error:2014 Commands out of sync; You can ' t run the This command nowI'm really drunk with this error number.Always tangled in why the stored procedure is executed, the commit operation is no longer found in the log of
[Warning] '--log_slow_queries ' is deprecated and would be removed in a future release. Please use '--slow_query_log '/'--slow_query_log_file ' instead.1. Modify the configuration
A MySQL backup related command:MYSQLDUMP-H host name-P Port-u user name-p password (–database) database name > file name. sqlCommands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlbacking up the
One: referencing mysql using parameter-based code, always prompt: "column name ' cannot be null" resolvesMySQL uses parameter-based code, and always prompts: "Column name ' cannot be null" Workaround 1: Add a oldsyntax=true directly inside the
"Watch and learn"1.mysql does not support top X usage and supports the limit x, Y usage;2. Multi-Table Connection query1. Table1 INNER join table2: Inner connection. Only the intersection rows of the two tables that are connected are displayed.2.
The Auto_increment property of the CREATE table setting is automatically set to 0 when the truncate operation is performedHttp://dev.mysql.com/doc/refman/5.0/en/truncate-table.htmlInnoDBfor a table before version 5.0.3, InnoDB processes by deleting
Common statements in MySQL:1: Create a table with self-growing primary keyDROP TABLE IF EXISTS user_login;CREATE TABLE User_login (user_id INT UNSIGNED not nullauto_increment,User_name VARCHAR () DEFAULT NULL,PRIMARY KEY user_id) Engine=myisam
In addition to the usual two table joins, the SQL (MySQL) JOIN syntax also supports multiple table joins. The basic syntax for multiple table joins is as follows:
1
Original: MySQL insert content is too long (Packet for query is too large)This has not been encountered before, one-time to the MySQL database insert content too long, the solution is to find the [mysqld] option in MySQL configuration file
How to modify the start value of mysql auto-increment IDMany friends in mysql think that the field AUTO_INCREMENT Type Auto-increment ID value cannot be modified. In fact, this is an incorrect understanding. The following describes how to modify and
Solve the Problem of forgetting the password of mysql in windowsIn windows, what should I do if I forget my mysql password? I will give a case and explanation! Solve the problem! The actual operations in Windows are as follows: 1. Disable running
Use Java to access images and other types of files in the MySQL database1. Notes
1. When the database field isBlobType, must usePreparedStatementInSetBinaryStream (int, InputStream, int)Method;2. When the database field isLongblobType, must
Mysql statement Summary
Some time ago, my project was finally completed. The project mainly involves reports and a lot of SQL statements, so I would like to summarize it.I. Basics 1. Database-related commands
A>. Create a database
Create database
Usage of loaddatainfile in mysql
The load data infile statement reads a table from a text file at a high speed.
1. Basic syntax
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS
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