MySQL bit type! What better method do you have? If there are only two types of promised data in MySQL, when setting its data type, we will first think of bit, which occupies less characters, is fast, and really cool! When this data type is inserted,
Alter table structure in MySQL
Project instance:Alter table testresult add xinlindoc longblob;Alter table testresult add xinlindocname varchar (50 );Other instances:Create Table T1 (a integer, B char (10); // The created table T1 starts.
Alter
Error
MySQL: Error: Query: not connected: Create Table 'schema _ migrations '('version' varchar (255) not null) engine = InnoDB
Solution;
Ruby is 1.8.6, rails is 2.2.3, MySQL is 5.1.51
This problem occurs because the libmysql. dll file
Alter table only allows adding columns that can contain null values or specified the default definition.
If:
If exists (select 1 from sysobjects where name = n' tab _ test') and not exists (select 1 from sysobjects A, syscolumns B where B. id =. ID
1. Download the MySQL installation-free compressed package
Download mysql-5.5.15-win32.zip to local D: \ mysql-5.5.15-win322. modify the configuration file
Copy the my-small.ini, one of which is the my. ini file, the port can be modified3. modify
The locking mechanism used by the MyISAM storage engine is fully implemented by the table-level locking mechanism provided by MySQL.
MySQL has two types of table-level locks: Write locks and read locks.
For write locks, MySQL uses the following
(I) hugepages Introduction
Hugepages is introduced by kernel 2.6 to adapt to the increasing physical memory size.
In Linux, the default page size is 4 K. If hugepages is used, the default page size is 2 m.
Let's look at two more terms:
Page table
In Windows, we use QT to develop database applications, such as MySQL. First, we must use the source code to compile the MySQL driver library;
1)install qt-sdk-win-opensource-2010.02.1.exe
In this case, QT creator is installed on QT. Assume that the
From: http://hi.baidu.com/netspider_2007/blog/item/aeed68917cdb3f85a877a4aa.html
Prerequisites for creating a foreign key: the columns in the table must be of the same type as the foreign key (the foreign key must be the external primary key )
1. query stored procedures in a database
Method 1 (view the content of a specified Stored Procedure ):
Select body fromMySQL. Proc where name = 'Procedure _ name ';
Method 2 (view all stored procedures ):
Show procedure status;
Ii. Export and
1. Because you need to back up the Haina Yun Member Management System
2. At least one backup every day
3. Full backup
4. Backup Directory management
5. the backup name is named after the date.
6. automatic backup at every day
So I wrote the
1. Non-root users install the binary MySQL distribution Edition
Create user
> Useradd fc
> Passwd fc
Enter password:
...
Log On with fc and upload the binary mysql version. My mysql 32-bit mysql-5.1.57-linux-i686-glibc23.tar.gz
After decompression,
Linux has been quite depressing recently. The following article is very helpful, in red ~
Recently, the mmm architecture of MySQL has been launched, and I want to make a try. I think there is a virtual IP address like LVS in it. I started to use
Install and configure the LAMP server in CentOS 6.2 (Apache + PHP5 + MySQL)Preparations: 1. configure the firewall, enable port 80 and port 3306 VI/etc/sysconfig/iptables-A input-M state -- state new-m tcp-p tcp -- dport 80-J accept (allow port 80
The front-end time is related to a DB project. alanc reports a query. Using indexes is much slower than not using indexes. So I followed up and used explain to look at two different query results.
The results of queries without indexes are as
As the data volume continues to grow, performance is particularly important. Perhaps after optimization and good solutions, you cannot feel the existence of performance problems, but as the data volume continues to grow,
From millions to tens of
The recording program has the function of writing recorded file information to the MySQL database for query by the BS system.
Therefore, a MySQL class is encapsulated for database operations.
The main interface is Update (): Execute SQL statements.
It's actually very simple, but I couldn't find any useful information on the Internet. It's strange.
Download the driver here
Http://www.mysql.com/products/connector/
The downloaded package contains examples.Knowledge required: Know how to add a
I have read an article about Asp.net and mysql on the Internet. For details about how to install mysql and connect to the MySQL database in. NET, see ASP. NET + MySQL simple illustration getting started.
Here I use EMS Mysql Manager lite tool to
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