MySQL

To display the database:SHOW DATABASES database_name;To create a database:CREATE DATABASES database_name;To delete a database:DROP DATABASE database_name;To create a data table:CREATE table(Field name 1, data type [column-level constraint] [default],

MySQL comes with: mysqldump: Logical Backup tool, for MYSAM can be implemented Win Bei, InnoDB can be hot standby mysqlhotcopy: Physical Backup tool (warm backup) file system Tools: For example, you use the CP command directly under Linux (Cold

Insert tone belongs to DMLSimple usage: INSERT INTO tb_name (field 1, Field 2, ...) VALUES (value 1, value 2, ...) Attentionthe number of fields must be the same as the number of values。 Characters are quoted in quotation marks, numbers are not used,

Let's take a look at the MySQL template monitor Zabbix comes with:650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/93/A6/wKioL1kK_iiikGZrAALYPx_NDVs865.jpg "title=" Sogou May 04, 17 1810_1.jpg "alt=" Wkiol1kk_iiikgzraalypx_ndvs865.jpg "/>#

MYSQL Pen Question------Two days ago just made a set of MySQL pen questions, share to everyone------------------first part, single choice (total 40 points)1, the unique index in MySQL keyword is (C)A. Fulltext Index b.only index C.unique index

1. Download the JDK and Tomcat.Jdk:Http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.htmlTomcat:http://tomcat.apache.org/download-70.cgi2.JDK installation and configuration.(1) JDK installationRPM Package:# RPM-IVH

MySQL OverviewMySQL is a relational databaseConnect to MySQL database: Mysql-u root-pWhat is SQL: Structured query statementsSQL classification:DDL: Data Definition language* Create,alter,drop ...DML: Data Manipulation language*

After: is the data before and after the deletion and modification, and then triggered. Trigger the statement later than the monitoring of additions and deletions, can not affect the previous additions and deletions to modify. This means that the

Original address: MySQL processing high concurrency, prevent inventory oversoldToday, Wang also gave us a lesson, in fact, MySQL processing high concurrency, prevent inventory oversold problem, at the time of last year, Wang has mentioned, but

General steps for an SQL statement optimization:1 Understanding the execution frequency of various SQL statements through the show status commandMysql> Show status; #show Status: Display Server status information+-------------------------------------

#!/bin/bash#at sunday, we will backup the completed databases and  the incresed binary log during saturday to sunday. #In  other  weekdays, we only backup the increaing binary log at that  day!################################ #the

The MySQL CONCAT () function is used to concatenate multiple strings into a single string, one of the most important MySQL functions, and the MySQL CONCAT () function is described in detail below for your referenceMySQL CONCAT (str1,str2,...)Returns

1 Write comments when creating a tableCREATE TABLE Test1(field_name int comment ' field comment ') comment= ' table notes ';2 Modifying a table's annotationsALTER TABLE TEST1 comment ' modified table comment ';3 Modifying a comment for a fieldALTER

The company's time stamp certificate business, to the release process intermediate data processing needs to use the stored procedure. Make a short record of this to avoid forgetting.DROP procedurerecord_timestamp_deal; # #创建存储过程Create

==============================Common operations for MySQL databases==============================I. Connection and shutdown of MySQL-H: Specify the server location to which you are connected-U: The user name of the database-P: Database password1

mysql backup type:1 depending on the backup, the server is online and is divided into:1) Hot-standby-the server is online and read and write unaffected.2) Win Bei--The server is online, but requires a lock table, and is readable and not writable.3)

The difference between stored procedures and functions A stored procedure can return multiple values, and a function can return a Functions can be embedded in SQL and can be called using SELECT, and stored procedures cannot be

First, the basic queryQuerying all Columns　SELECT * from table name;　　Querying a specified column　　Select field 1, Field 2 from table name;　　Second, the conditions of inquiryThe WHERE clause is given when querying to limit the results of the query

#!/bin/bash#定义变量mysql_host=192.168.56.21Mysql_username=rootmysql_port=3306Mysql_passpwd=oracleMysql_sock=/data/mysql/3306/tmp/3306.sockMysql_cnf=/data/mysql/3306/my3306.cnfMysql_datadir= ' cat ${mysql_cnf}|grep datadir|awk-f ' = ' {print $}

Mysql service 1067 error: modifying the mysql executable file path, 1067 mysql Today, the mysql service error 1067 occurs. Setting and using a system account cannot start mysql. the system configuration information is verified later, it is found