1, MySQL common commands
Create database name; Creating a Database
Use DatabaseName; Select Database
Drop database name deletes databases directly, without alerting
Show tables; Show Table
Describe TableName; Detailed description of the table
A history project, customer requests to change IP, because the system is more remote, there is no source code, through the reverse compilation of IP written dead in the class, the reverse-compiled code can not be modified, after analysis of the code,
MySQL administrators should know how to set up a MySQL user account by specifying which users can connect to the server, where to connect, and what to do when they connect. MYSQL3.22.11 introduces two more statements that make this work easier: The
Js| Program | Performance First, overview
In Web applications, the generation of some reports may take a long time to compute, and some sites provide weather information that requires access to remote servers for SOAP calls to get temperature
JSP actions use you can dynamically insert a file, reuse the JavaBeans component, advance to another page, or generate an HTML for the Java plug-in. The action you can use is:
(1) Jsp:include--Included in a file when the page is requested.
(2) jsp:
Js
JSP actions include:Jsp:include: Introduces a file when the page is requested.Jsp:usebean: Find or instantiate a JavaBean.Jsp:setproperty: Sets the properties of the JavaBean.Jsp:getproperty: Outputs a JavaBean attribute.Jsp:forward: Move the
Programming | Advanced 6th Active Server components
In the previous chapters, we have studied two different kinds of objects: one is the built-in part of the ASP object model, the other is the object provided by the Script Runtime library. This
Response| Object Author: scholar
In the previous article, the author gave you a detailed introduction of the ASP built-in object one of the use of Request, I believe that you through a series of practice has been able to master, this article will
Network Reader scope:
This article is a short introductory article. This article assumes that readers have an understanding of Java IO Systems and Java Network systems.
Body:
The problem with file transfer is also a basic problem with IO
mysql| Recovery
If you forget your MySQL root password, you can recover it through the following procedure.1. Send Kill command to MYSQLD server to turn off MYSQLD server (not kill-9), and the file that holds the process ID is usually in the
1, the MySQL database does not have an incremental backup mechanism, when the amount of data is too large backup is a big problem. Fortunately, the MySQL database provides a master-slave backup mechanism, which is to write all the data in the
Ado|stream
ADODB.stream is the stream object of ADO, which provides access to binary data or text stream, so as to realize the reading, writing and management of convection.
The following methods are available:Cancel methodUse the following
Skills
31.TEXTAREA the number of adaptive lines of text
32. Date minus days equals second date
33. Which radio was chosen
stylebarcode
34. Script never Goes wrong
The 35.ENTER key allows the cursor to move to the next input box
36. Detect the
mysql| Reference | Reference Manual | cache | Chinese MySQL 4.1.0 chinese reference manual---dog (heart sail) Translate MySQL Reference Manual for version 4.1.0-alpha.
6.9 MySQL Query Cache
Starting with MySQL 4.0.1, MySQL server has an
Ways to lock tables
There are many ways to prevent client requests from interfering with each other or the server and maintenance programs interfering with each other. If you close the database, you can ensure that there is no interaction between
The root password for the MySQL database can be modified in several ways:
First, in a known MySQL database root user password, the method of modifying the password:
1, in the shell environment, using the Mysqladmin command set: mysqladmin–u root–p
The js| tutorial
Also, you can write multiple properties in one statement:
There are two main types of directive:
page, which allows you to do something like import classes, define a servlet
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