MySQL

Installation environment: Operating System: winserver2003JDK: 1.5Tomcat: 5.5Opencms: 7.0 beta1, that is, opencms6.7.2 (opencms6.2.3 and so on)Database: mysql5Browser: ie6.0sp1 Installation Process: 1. Copy opencms. War to the webapps directory

1. AuthorizationGrant select, insert, delete, update on mydb. * to tan identified by '123 '; 2. open the port1) disable the FirewallChkconfig iptables offService iptables stopOr2) modify the/etc/sysconfig/iptables file and add-A RH-Firewall-1-INPUT-

Hardware configuration: AMD 3200 + Asus Motherboard Kst 512 M ddr400 * 2 120g ide Software Configuration: Httpd-2.0.52-28.ent.centos4 Php-4.3.9-3.15 Slave -----------------------------------------------------------------------------------------------

@ For ever 2010-12-22   For MySQL,MyISAM is a table lock and is suitable for reading much larger than writing; InnoDB is used for reading and writing frequently. For example, if the MyISAM format is used, when writing is much larger than

Installing Apache, PHP, and MySQL on rhel5.1 This will install the basic components for a dynmaic, database-driven web site. We useYum to handle dependencies and gather all of the required packages. 1. install Apache (httpd), PHP, MySQL

1. Switch to the root user and enter:YaST - --->Software ----->Software repositories. 2.Software managementPreviously, if your network speed is slow, you canSoftware Repositories URL: DVD: //Priority Set the attribute value to the minimum

Problem description: MySQL databases can be connected, and rails configurations related to MySQL are normal.HoweverProgramWhen accessing the database, the following error message is displayed on the server:Argumenterror (NULL pointer given ):(Eval):

Clears all content in a MySQL table.Delete from table name;Truncate table name;The delete statement without the where parameter can delete all content in the MySQL table. You can also use the truncate table to clear all content in the MySQL table.

Error 1005 (hy000): Can't create table '*****. frm' (errno: 150)   I have solved this problem from the following aspects: 1. Make sure that the referenced tables and fields exist;   2. The fields that make up the foreign key must be indexed

After installing MySQL, follow these steps to access the database. Choose my computer> mysql> MySQL 5.5 command line, and enter the password set during installation. You can use the following commands to quickly learn about MYSQL. 1. view the

Run the Blob test program. The data is a bit large, 32 MB. the following error message is returned:   Com. MySQL. JDBC. packettoobigexception: packet for query is too large (37748784> 1048576). You can change this value on the server by setting

MySQL disconnection in 8 hours There are two solutions: the first is to set the autoreconnect attribute to true; the second is to set the attributes such as testquery in DBCP. The cause is that the MySQL parameter interactive_timeout, that is, the

Http://hi.baidu.com/elongskyscj/blog/item/743b60c28d839f34e4dd3b2a.htmlBefore reading this article, install and set up the JSP, tomcat, and MySQL Databases correctly. If you have any questions, please read the relevant information.1. PreparationsNow,

My website uses MySQL and one field is "date". When I add a record MySQLSet the "date" Default Value of the record to the current date, I tried timestamp, but the default value is 14 bits, that is, there are years, months, days, hours, and minutes.

Http://blog.chinaunix.net/u/14014/showart_490462.html     Mysql> show variables like '% timeout '; The output is as follows: + ---------------------------- + ------- +| Variable_name | value |+ ---------------------------- + ------- +|

In some databases, there are cross tables, but this function is not available in MySQL. However, many friends on the Internet want to find a solution.Http://topic.csdn.net/u/20090530/23/0b782674-4b0b-4cf5-bc1a-e8914aaee5ab.html? 96198The solution is

After more than half a day, I finally cleared the operations for tomcat5.5 to configure the data source, which is actually a few simple steps. Tomcat5.5 connect to mysql5.0A. find the Tomcat server. XML file. Add the configuration file of the data

Some time ago, I tried to write several ranking stored procedures. Since I have never been in touch with them before, I wrote a full reference to the existing stored procedures. Fortunately, stored procedures can also be used. However, it was found

Reprinted from: http://hi.baidu.com/my_lough/blog/item/8a40a3169add7c4f21a4e9a5.html A problem occurred when inserting data to the MySQL database recently. A Chinese error is reported: incorrect string value ..... I searched some materials on the

One of the most powerful functions of MySQL proxy is to implement read/write splitting )". The basic principle is to allow the primary database to process transactional queries, but to process select queries from the database. Database Replication