MySQL

1. Create a database table:CREATE TABLE table_name (fields_name1 datatype,fields_name2 datatype ...);2. View the table:Show tables;3. Create a table with the main health constraint (including Tangokian and multi-character types)1. Single KEY

A new CentOS server installed, after installing lamp, restarted the system, found that MySQL can not boot and reported the following error: /etc/init.d/mysqld startStarting MySQL ... error! The server quit without updating PID file (/

1, transaction processingInnoDB supports transactional features, MyISAM not supported.Myisam executes faster and performs better.2,select, UPDATE, INSERT, delete operationMyISAM: if executing a lot of select,myisam is a better choiceInnoDB: If your

1. Assume that there are already mysql-5.5.10.tar.gz and cmake-2.8.4.tar.gz two source files(1) Install CMake First (mysql5.5 is compiled by CMake later)[[email protected] rhel5 Local] #Tar-zxv-f cmake-2.8.4.tar.gz[[email protected] rhel5 Local] #CD

MySQL user information is in the Users table under MySQL databaseWe look at a few users under the Mysql.user tableSELECT Host,user,password from user;Discovery System has 1 default users650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5B/69

I created a goods table here, first look at the data inside:mysql> select * from goods;+----+------+------+------------+-------------+------------+ | id | s_id | b_id | goods_name | goods_price | goods_ desc |+----+------+------+------------+--------

To back up a specified databaseMysqldump-u root-p Database name > backup file. sqlCasesMysqldump-u root-p123 Test >d:/test.sqlMysqldump Import CommandMysql-u User name-p password-H host database For exampleCreate DATABASE test;Mysql-u root-p 123

I created a goods table here, first look at the data inside:mysql> select * from goods;+----+------+------+------------+-------------+------------+ | id | s_id | b_id | goods_name | goods_price | goods_ desc |+----+------+------+------------+--------

Installation EnvironmentSystem: centos6.5_86x64Mysql:mysql-5.6.16.tar.gzNote: The mysql-5.6.16 installation is different from 5.5, 5.1, and the compilation is no longer used./configure, but compiled using CMake.1. Create a new directory to hold your

How to install MySQL database, do not say here, just say its master-slave copy, the steps are as follows:1, the master-slave server for the following actions：1.1. Consistent version1.2. Initialize the table and start MySQL in the background1.3,

Error:1) Change master results in:Last_io_error:error connecting to master '[email protected]: 3306 '-retry-time:60 retries2) Stop the slave process without unlocking:mysql> stop Slave;ERROR 1192 (HY000): Can ' t execute the given command because

1. Clean up the original MySQL1.1 See if MySQL is installedRpm-qa | grep mysql//This command will check if the MySQL database is already installed on the operating system 1.2 Deleting a databaseRPM-E MySQL//normal delete mode rpm-e--nodeps

Mysql permission control detailsOverview Mysql permission control can be controlled in different contexts and different operation levels. They include the following:**Management permissions allow users to manage mysql server operations. These

Innodb Engine analysis (initialization) in MySQL)MySQL's storage engine works in the form of plug-ins. This should be a major feature of MySQL! According to the deep understanding of MySQL, the plug-ins of the storage engine in version 5.1 are not

MySql DATA partition operation-new partition operation If you want to partition a created table and use alter to add a partition, mysql will prompt an error: The Code is as follows: ERROR 1505 Partition management on a not partitioned table is not

Connect to the mysql database in JAVA Last week, I designed the database course, using java and mysql databases, which involves the knowledge of connecting to the database using java.First we need to add a jar file, it is equivalent to a connection

Mysql partition technology I. Overview When the total number of MySQL records exceeds 1 million, will the performance be greatly reduced? The answer is yes, but the ratio of performance degradation> varies depending on the system architecture,

In-depth study of varchar and limit in mysql (easy to ignore) Why is the title named? Commen sence refers to things that everyone should know, but often they will know something or know something about it, today I will summarize some commen sense

Mysql sharding introduction, 1. What are common Sharding application scenarios? When the amount of data in the database is getting bigger and bigger, both reading and writing will increase the pressure. Imagine that when the data volume in a table

Detailed introduction of mysql partition technology and mysql Partition I. Overview When the total number of MySQL records exceeds 1 million, will the performance be greatly reduced? The answer is yes, but the ratio of performance degradation>