MySQL

Configure Java and tomcat environment variables and start Tomcat Catalina_home = targetdir + "// apache-tomcat-5.5.12 ";Java_home = targetdir + "// jdk1.5.0 _ 05 ";Szkey = "environment ";Regdbsetdefaultroot (HKEY_CURRENT_USER

When executing commands on the MySQL command line interface, remember to set the encoding. Another unpleasant thing is that the last setting on the command line does not exist when you go in next time and you have to set it every time.   Set

The database on the local machine has not been used for a long time (the local machine is only used for occasional testing), forget the root password, sweat Finally, use the following solutions: 1. If MySQL is running, first exit: net stop MySQL.2.

JDBC: mysql: /// localhost: 3306/test? Useunicode = true & characterencoding = euc_cnThe performance of this method may be compromised, because it must undergo certain conversions. In addition, if DBCP is used in Tomcat, the method is invalid. (I

Like query in MySQL   In the like Query of MySQL, we find that Chinese search is always hard-earned. We have found several solutions on the Internet. You can refer to the following:   Method 1: The solution is to add the "binary" attribute to a

There are many types of character sets in the MySQL database, and the main impact on programming is the client Character Set and the MySQL database character set. A common operation in MySQL databases is to save and read data. In this process, there

Create a menu shortcut, create a desktop shortcut, create a url shortcut, and open a browser   Szfoldername = folder_startmenu;Createprogramfolder (szfoldername );Szcommandline = targetdir ^ "Apache-Tomcat-5.5.12 // bin // startup. Bat

MySQL date_format () format the date   Date_forma T (date, format) format the date or Date and Time Value Based on the format string, and return the result string.   You can use date_format () to format the date or datetime value to obtain the

Document directory Syntax MySQL date_sub () function MySQL date functionDefinition and usage The date_sub () function minus the specified time interval from date.Syntax DATE_SUB(date,INTERVAL expr type) DateA parameter is a valid date

Mysqldump command MySQL mysqldump is used for MySQL database export. The basic usage is as follows: Shell> mysqldump [Options] database [Tables] If you do not specify any tables, the entire database will be exported. Run mysqldump --

================ View the database ================================= = Use the show statement to find out the current database on the server: mysql> SHOW DATABASES;+----------+| Database |+----------+| mysql || test || tmp

MySQL transaction isolation level settings (these settings are aimed at the relationship between transactions and transactions) Http://blog.csdn.net/wangsifu2009/article/details/6715120 The method for setting the transaction level of InnoDB is:

Add the following two lines to the my. ini or my. CNF file, Set-variable = max_allowed_packet = 1 mSet-variable = net_buffer_length = 2 K   See the following MySQL 5.1 reference manual. 26.2.4.5.2. Prepare the MySQL server After creating a

During webpage creation, the string storage length in MySQL is 255, so blob can be used for long text. However, I find it hard to find the answer to this problem on the Internet. Here, I will write out my solution. I am working on a message book,

Because Apache is widely used on Windows platforms, we have to pay attention to its security settings. Many careless webmasters build production environments using Apache on their managed servers and install them by default. Apache is started as

Original article: http://www.360doc.com/content/10/0911/22/737570_52964836.shtml Error executing insert: incorrect string value: '\ xe8 \ XAE \ xA1 \ xe7 \ XAE \ x97...' for column 'dep' at Row 1 The solution to this problem is as follows: (read

1.1 MySQL storage engine Overview MySQL supports multiple storage engines. When processing different types of applications, you can select different storage engines to improve application efficiency or provide flexible storage. Including MyISAM,

I have read many articles about MySQL paging query optimization over the past two days.   The paging query of MySQL is usually not supported by limit, and the key points are as follows: 1. Minimize the offset of the limit, that is, the "M" in the

You can use the MySQL command line to modify the password of the MySQL database. The following describes the MySQL Command Line in detail. If you are interested, take a look. Format: mysqladmin-u username-P old Password New Password 1. Add a

If JSP is used to connect to the MySQL database, garbled characters may occur during Chinese access. A bunch of "? ", The following changes must be made: 1. connection string: String mysqldriver = "org. gjt. Mm. MySQL. Driver"; // database