MySQL

I have been compiling and installing myself, and the installation directory is clearly allocated. Today I saw a friend who did not know me. I checked that it was installed by default, I am not familiar with the default installed directory

Common commands: Show databases; show all databases Use pdns; select the pdns Library Show tables; view all table names in the database Select * From domains; query the content in the domians table Drop table domains; Delete the domains

1. Install and test the Apache package 1.1 install the Apache package Sudo apt-Get install apache2 1.2. Start and test the Apache Environment Sudo/etc/init. d/apache2 startVisit http: // localhost and you will see "It works!" on the

Today, when I learned yii by following the example in the book, I found that the following error is always reported when I create a MySQL table with a foreign key. Error 1005 (hy000): Can't create table '. ' (errno: 150) However, the error

ArticleDirectory 2.1.1 phpMyAdmin 2.1.2 use mysqldump command line 2.3.1 use phpMyAdmin 2.3.2 use MySQL Command Line 1. Overview There are two ways to import a MySQL database: 1) Export the database SQL script first and then

This document describes how to use the show command in a MySQL database: A. Show tables or show tables from database_name; -- displays the names of all tables in the current database. B. Show databases; -- display the names of all databases in

1. After MySQL is installed in SuSE Linux, the default value is: case-sensitive for table names, not case-sensitive for column names; 2. log on to the/etc/My. add lower_case_table_names = 1 after [mysqld] In CNF and restart the MySQL service. The

In general, MySQL does not have any special mechanism to provide log backup, deletion, and other management operations, but relies heavily on OS-level operations. For binary transaction logs, MySQL provides the expire_logs_days system

MySQL encoding settings 1. Edit the MySQL configuration file MySQL configuration file in Windows is generally in the system directory or in the MySQL installation directory named my. ini, you can search, Linux is usually/etc/My. CNF -- Add a

The theory of Shenma is full of clouds. The most practical example is: Today, I found that the website data was abnormal. I checked the database and encountered the following error when operating a table (tbl_test: Table '. \ mydb \ tbl_test' is

PHP and MySQL Transaction Processing /*There are two main methods to process MySQL transactions. 1. Use begin, rollback, and commit to implement Start a transactionRollback transaction rollbackCommit transaction validation 2. directly use set to

Today, a colleague asked me if MySQL could be backed up in real time from multiple master nodes to one slave node. Google can use mysqld_multi to manage multiple MySQL instances. I have previously thought about running multiple MySQL instances on

When you work on a large table, you may occasionally need to run many queries to obtain a small subset of a large amount of data, instead of running these queries on the entire table, instead, MySQL can find a few required records each time, and it

Install MySQL Download:MySQL 5.5.28 Install MYSQL: Select 'custom' --> next --> specify the installation path --> next --> install (there is nothing to say about installation, mainly MySQL configuration) On the installation completion page,

StorageProgramCategory Stored Procedure Storage Functions View Trigger Scheduled tasks Write the ";" delimiter of the storage program in the mysql.exe Client The mysql.exe client uses ";" as the statement separator

There are dual virtual tables similar to those in Oracle in MySQL: the official statement is purely to satisfy the habit of select... from,MySQL ignores the reference to this table. You can pay attention to the following: Select * from

1. Replication ProcessMySQL replication is an asynchronous replication, from one MySQL instace (called Master) to another MySQL instance (called slave ). The entire replication operation is completed by three processes, two of which are on slave

How to speed up SQL import in MySQL     1. If MySQL has very little data and the memory is large enough, you can prevent data from being sent to the memory disk. Linux: Mount-T ramfs NONE/Ram By default, half of the memory is used. If

The following describes how IISIntegration on Php, I will not talk about cgi here, Because cgi requires too many system permissions and is not recommended for use by virtual hosts, and cgi programs are rarely used.Iis6.0 integrationPhp Installation

In this system, each module has its own function distribution and code design. The Hiberate plug-in was used at the data layer, but the interaction between jdbc and mysql was first reviewed. Platform: Eclipse3.6 mysql5.0 This is an introduction to