1. Install JDK first. After downloading and installing JDK, you 'd better add java_home to the system variable.
2. Download JBoss (J2EE container). I downloaded jboss4.2.1.ga. The jboss4.2.3.ga that was downloaded first throws an exception and has
Run mysqld directlyProgramThe method to start the MySQL service is rare. The mysqld_safe script will continue to monitor its running status after the MySQL server is started and restart it when it crashes. Using the mysqld_safe script to start a
1. Insert force constraint, cascade delete, and cascade update"
User table:Create Table user(Userid integer not null auto_increment primary key,Username varchar (12) not null)Type = InnoDB;
After several attempts, I finally saw the same
Functions for escaping special characters in PHP MySQL
One is: mysql_escape_string
One is: addslashes
The difference between mysql_escape_string and addslashes is that
Mysql_escape_string always converts "'" to "\"
And addslashes
Convert "'"
Applications (such as PHP) execute MySQL statements in batches for a long time. Execute an SQL statement, but the SQL statement is too large or the statement contains blob or longblob fields. For example, processing image data. MySQL server has gone
Http://aronlulu.iteye.com/blog/790641
MySQL is widely used in the Internet. A large part of the reason is its replication mechanism, which is simple and practical. It can easily improve the performance of several PC hosts and is a must-have solution
MySQL configuration principles rational configuration of MySQL the most reasonable use of MySQL for MyISAM or InnoDB for different application conditions rational configuration for my. CNFConfiguration, followed by reasonable settings for servers
In MySQL, the data table contains the date type and the time type. Here, date stores the year, month, and day, and time stores the hour, minute, and second.
In Java
The date and time fields are of the date type. Note that Java. util. Date
Index is the key to quick search. The establishment of MySQL indexes is very important for the efficient operation of MySQL. The following describes several common MySQL index types.
Index fields in database tables can greatly improve the query
Mysqlconnection conn = NULL;
Try
{
// Mysqlconnection conn = new mysqlconnection (New mysqlconnectionstring ("myquest", "root", "amttgroup"). asstring );
// Instantiate a connection object. myquest is the database name, root is the database username,
C # MySQL connection
Mysqlconnection conn = NULL;
Try
{
// Mysqlconnection conn = new mysqlconnection (New mysqlconnectionstring ("myquest", "root", "amttgroup"). asstring );
// Instantiate a connection object. myquest is the database name,
[Switch] Use jquery (Ajax)/PHP/MySQL to automatically complete the Function
Copyright Disclaimer: During reprinting, please use hyperlinks to indicate the original source and author information of the article and this
1: Use the show statement to find out the current database on the server:Mysql> show databases;2. Create a database named mysqldataMysql> Create Database mysqldata;3: select the database you createdMysql> Use mysqldata; (when you press the Enter key
Today, I saw it in the jar. By the way, write it down.
There are two methods:
1. inefficient because of subqueries. But concise. In addition, I made an index for the socres table. Therefore, the performance is not much worse.
Mysql> show create
MySQL Server Optimization
Recently, I helped people maintain a DZ forum and summarized the following tuning skills to make MySQL servers run fast.
There are three ways to speed up the running of the MySQL server:
1. Replace the faulty hardware.2.
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