Alter table: add, modify, and delete table columns, constraints, and other table definitions.
View column: DESC table name;
Alter table t_book Rename to BBB;
Add column: alter table table name Add column name varchar (30 );
Delete
The previous blog was banned by Sina and will be written here later.
Today, MySQL in a test environment suddenly crashes. In fact, MySQL is dead, but PS can still be seen. The MySQL version is 5.0.38.
Output the following information in the
Shell programming is very powerful!
When the site traffic is large, MySQL is under a high pressure. When the CPU usage of MySQL exceeds 300%, it cannot provide services, and it is almost stuck. At this time, the best way is to restart the MySQL
Back up database
# Mysqldump Database Name> Database Backup name
# Mysqldump-a-u username-P Password Database Name> Database Backup name
# Mysqldump-D-A -- add-drop-table-uroot-P> XXX. SQL
1. the exported structure does not export data
Starting, stopping, and restarting MySQL is a must-have operation for every webmaster with an independent host. The following describes the operation methods:
I. Startup Mode
1. Start with service: Service mysqld start
2. Use the mysqld script to
First, find a MySQL host that is installed with the same version as you (of course, you must know the root account and password) and find the data folder in the installation directory (for example, C: \ Program Files \ mysql \ MySQL Server 5.0 \,
In actual production and development, if multiple nodes coexist, You need to select the master node and implement ha automatic fault tolerance. I have thought about the writing method and shared it with you.
Lease protocol, MySQL Acid
High
It is a bit abrupt to give such a title, but this is a boundary value that I have been thinking about recently. The question is: how to define the data type for the time field in MySQL.
In the previous MySQL database design, we designed all the time
Introduction if you have worked in a large group of companies, you will have the opportunity to access MySQL, although it does not support transaction processing, stored procedures, however, the functions provided by MySQL can satisfy most of your
Document directory
Simple MySQL ORM for C
Http://daoluan.net/blog? P = 1613
I never knew that there was such an ORM thing that I had to contact after talking with @ haipo.
In the project, you need to store data in the database. The first
Select *, if (SVA = 1, "male", "female") as ssva from tableame where id = 1Quote control flow Functions
Case value when [compare-value] Then result [when [compare-value] Then result...] [else result] end case when [condition] Then result [when
In a web application system, if the database has a performance bottleneck and you are using a MySQL database, you can consider using a database cluster to achieve query load. Generally, database query operations in any system are more than update
Discuz is slow. when MySQL is frequently rushed to MySQL 100%, find the cause. Here, we will first write down the slow query log of MySQL on a Windows host, as shown below:Run the CMD command line in the bin directory of MySQL. net stop mysql. Find
Development Environment: Windows XP Professional SP3, vs2008, winform, mysql5.0, MySQL. data6.2.3.0
1. Read an image from the hard disk, convert it to a stream, and store it in this blob field.
View plaincopy to clipboardprint?
Private void
Basic Concepts
• Character refers to the smallest semantic symbol in human language. For example, 'A' and 'B;
• Given a series of characters, each character is assigned a value, which is used to represent the corresponding character. This value is
1. clone a table
You can use
Create Table... like statement to clone the table structure; Use insert into... select
Statement to clone part or all of the table data.
2. Temporary table
Need a table created for temporary use only and automatically
Mysql Oracle official download type exclusive seems a headache for us to choose
Download MySQL Community Server
Http://dev.mysql.com/downloads/mysql/
On this download site, select the platform "CMDL & red hat liunx 5 ".
Select installation package
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