1. Add the database driver package to the glassfishv3 \ glassfish \ Domains \ domain1 \ Lib \ ext directory of the existing instance on the server.
2. Create a database connection pool
3. Create data as a connection Resource
4. Publish an
Primary Key Create Table Feng (
Teamno int not null, playerno int not null, Division char (6) Not null,
Primary Key (teamno) )
Create Table Feng ( Teamno int not null
Primary Key , Playerno int not null, Division char (6) Not null,) composite
MySQL memory table usage
Memory tables use Hash hash indexes to store data in the memory. Therefore, it is extremely fast and suitable for caching Small and Medium databases. However, the usage is limited. The following are some of the feelings
ManyProgramWhen developers use some front-end database development tools (such as PowerBuilder and Delphi) to develop database applications, they only pay attention to the gorgeous user interface and do not pay attention to the efficiency of query
Http://www.111cn.net/database/110/a7a8504655fc25e1dd63dbf06bd3c716.htm
Method 1
PhpMyAdmin is the simplest. Modify the user table of the MySQL database,
But don't forget to use the password function.
Method 2
Use
Address: http://www.pczpg.com/a/2010/0507/7815.html
Call the MySQL stored procedure in the same thing in PHP and then execute another or multiple commands (or execute multiple stored procedures in the same thing) again ), if you use the query
Installation environment and MySQL software
The installation environment of the company's MySQL cluster is Red Hat 5 or client os6.8
Msql cluster software version 7.2.8 (http://www.mysql.com/downloads/cluster)MySQL cluster Installation
A) node
(1) usage of Foreign keys:
The foreign key has two main functions:One is to allow the database to ensure data integrity and consistency through foreign keys.One is to increase the readability of the erimage.Some people think that the establishment
1. Download the installation file from the Internet (here I download a MySQL binary distribution)Http://dev.mysql.com/downloads/index.html
2. Upload the file to the host through securecrtCopy mysql-3.23.58-pc-linux-i686.tar to C:/program
[Root @ dbsvr01 E] # mysql-uroot-PEnter password:Error 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: Yes)[Root @ dbsvr01 E] #
======================================
Delete the value of user. User is null, or update null
I have been debugging for half a day because l transaction is not effective today. It is because the MySQL database MyISAM type table does not support transactions.Later, I changed the table type to InnoDB, and the transaction processing took effect.
MySQL character set support has two aspects:
Character Set and collation ).
The support for character sets is refined to four layers:
Server, database, table, and connection ).
1. Default MySQL Character Set
MySQL can refine the character set
MySQL configuration file my. CNF example is the most detailed translation, you can save for use.
# Begin config info# Descr: 4 gb ram, only InnoDB, acid, a small number of connections, large queue Load# Type: System# End config info
## This MySQL
1. Download sitescope (you can reply to the message, leave a mailbox, and send it directly to your mailbox)
2. Install sitescope
It can be installed by default. The license number can be blank first. If it is blank, it indicates a trial. If it is
I. Usage
1. Use the show statement to find out the current database on the server:
mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | +----------+ 3 rows in set (0.00 sec)
In practice, some colleagues often asked: what is the appropriate number of records in the MySQL Innodb table?Generally, the larger the table, the lower the performance. But how low is it? Is it a slow decline or a sharp decline? Is it a decline of 1
Mysql 5.0.22 Cluster for RedHat AS4-U2
Recently, I have seen a lot of information about cluster. I have been studying the load balancing and high availability of linux systems, but it has not been completely successful yet, but it only implements
Solve The InnoDB feature is disabled; you need MySQL built with InnoDB
When creating transactions, stored procedures, triggers, and external keys in MYSQL, the data table type must be InnoDB. However, sometimes MYSQL does not support this type and
Author: Lao Wang
PHP programmers should know that they can use the mysql_pconnect (permanent connection) function to connect to the MySQL database. Using a permanent connection to the database can improve efficiency. However, in actual applications,
Add an article: O (∩ _ ∩) O ~
The uninstall procedure is as follows:
Uninstall Mysql
[Root @ localhost ~] # Rpm-qa | grep mysql
Mod_auth_mysql-2.6.1-2.2
Php-mysql-4.3.9-3.15
Mysql-devel-4.1.20-1.RHEL4.1
Mysql-4.1.20-1.RHEL4.1
Mysqlclient10-3.23.58-4.
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