MySQL

Author: Yang xinqi   Recently, three projects were started on hand, and the other two started from the bottom layer. One was started for a while and developed by a small team in a small city, there are no dedicated DBAs for database design and

Autocommit MySQL is automatically submitted by default. You can view and modify it using the following command: Mysql> show variables like 'autocommit ';+ --------------- + ------- +| Variable_name | value |+ --------------- + ------- +|

Data Type Description Bytes Recommended Smallint Integer in the range of-32000 to + 32000 2 Store relatively small integers.For example, age and quantity Int Integer in the range of-2000000000 to +

Original article: http://www.phpv.net/html/my.cnf_configure.html From hi! A copy of the configuration copied by the admin. The notes are very good. # Begin config info# Descr: 4 gb ram, only InnoDB, acid, a small number of connections, large

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

MySQL Remote Access command Format:Mysql-H host address-u user name-P User Password Example: Yanggang @ host :~ $ Mysql-h192.168.1.11-uroot-p123456Error 2003 (hy000): Can't connect to MySQL server on '192. 168.1.11 '(192) An error

In Windows, if MySQL has been installed previously, after fixing or uninstalling and reinstalling it, the last step will prompt that it will fail! Possible causes: 1. The firewall is enabled, and the network port 3306 is not enabled. As a

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

For the description of the valid format of the value range of each type and the specified date and time value, see 7.3.6 Date and Time type. Here is an example of using the date function. The following query Selects all records. The value of

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

ArticleDirectory What is phpnow? Download phpnow 1.4.5 Phpnow plug-in Other files All files What is phpnow? The free green Apache + PHP + MySQL environment package under Win32.Simple installation and quick setup of PHP

ArticleDirectory Install the MySQL Module Connect to database Focus on inserting and updating data   Install the MySQL Module Sudo easy_install mysql-Python Connect to database 1 # ! /Usr/bin/ENV Python 2 # Coding =

Shortly after I first came into contact with MySQL, I found that many enterprise-level functions were missing. I wanted to view the SQL statements executed by MySQL in real time, similar to the event probe in MSSQL. I searched for them online, the

Uninstall Apache[Root @ server ~] # Rpm-Qa | grep httpdHttpd-2.2.3-11.el5_2.centos.4Httpd-manual-2.2.3-11.el5_2.centos.4 Note:The rpm-Qa | grep MySQL command is used to list all mysql-related packages. In the preceding example, the RPM package list

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,

During our website design and production process, it is more convenient to save images to the database than to save them as files. And MySQL, which can easily implement the above functions. In this article, we will show you how to save images to the

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 hompy project uses two data servers with 8 GB and 6 GB Master/Slave databases respectively.At the beginning, I always went down the machine. I used my-huge as the basic configuration many times,Later, I borrowed the configuration of

From: http://blog.52news.com/article.asp? Id = 1659 After MySQL is installed, you can start the bin-log function to record database data operation records and recover data when necessary. MySQL logs are divided into the following types:Error

Parent-Child tables are often involved when adding, modifying, and deleting records in a database.For example, a province table and a city table have a foreign key province_id referenced to the primary key of the province table. In this way, we can