MySQL

MySQL ExercisesCreate a student tableMysql> CREATE TABLE Student (-ID Int (TEN) not null unique primary key,-Name varchar (a) NOT NULL,Sex varchar (4),Brith year,Deparment varchar (20),Address varchar (50));Query OK, 0 rows affected (0.03 sec)View

First, DATETIMEDisplay format: Yyyy-mm-dd HH:MM:SSTime range: [' 1000-01-01 00:00:00 ' to ' 9999-12-31 23:59:59 ']Second, DATEDisplay format: YYYY-MM-DDTime range: [' 1000-01-01 ' to ' 9999-12-31 ']Third, TIMESTAMPDisplay format: Yyyy-mm-dd

Log in to MySQL:MYSQL-H host name-u user name-P-H: This command is used to specify the MySQL hostname that the client wants to log on, and the parameter can be omitted when logging on to the current machine;-U: The name of the user to log in;-P:

MySQL in your can ' t specify target table for update in FROM clause error means that you cannot select some of the values in the same table first, and then update the table (in the same statement).Example: DELETE from Sys_org_relation where Porgid

Preface: MySQL database, the knowledge is very much, want to learn to learn this piece of knowledge, estimated also to spend and learn Linux the same energy and time. Small series is also only some fur, for everyone to share ~One, MySQL installation(

One, the group copy is a what ghost?Start with MySQL replication technology, first of all, MySQL asynchronous replicationIn asynchronous replication mode, the execution transaction on master generates Binlog,slave on the local relaylog by connecting

1, installation Zabbix-agentYum-y Install zabbix-2.4.8-1.el6.x86_64.rpm zabbix-agent-2.4.8-1.el6.x86_64.rpmInstallation of the above two packages will be generated in the/ETC/ZABBIX/ZABBIX_AGENTD.D directory userparameter_mysql.conf This

Original link: MySQL View database related informationWhen using MySQL, you need to know the current database, such as the current database size, character set, user, and so on. Here's a summary of some commands for viewing database-related

MySQL optimizationPersonal originality, permission to reprint, please indicate the source, the author, otherwise investigate legal responsibility.Number of MySQL connectionsQPS number of queries per secondPV Page viewPeak Qps= Peak PV number * PV to

Mysql-mysqli_fetch_all (Error)Problem: Failed/Error getting the returned array using Mysql-mysqli_fetch_allCauses and solutions:The Mysqli_fetch_all function exists only in Mysqlnd, which is the native MySQL driver for PHP. Link MySQL There are two

MySQL order by string sort, MySQL string order by==============================? Copyright Sweet Potato Yiu September 30, 2017http://fanshuyao.iteye.com/First, the problem description:MySQL sort if the field used is string type, the collation is

It is always customary to compare with Oracle database when learning MySQL. When learning the storage structure of MySQL InnoDB, it is also unavoidable to compare with Oracle. Oracle's data storage is table space, segments, blocks, chunks, data

From_unixtime () is the time function in MySQLMysql>select from_unixtime (1249488000, '%y%m%d ')20071120Mysql>select from_unixtime (1249488000, '%y year%m month%d ')November 2007Directly converts a MySQL timestamp type to a date formatUnix_timestamp

Chapter III MySQL advanced query (i) I. Four classifications for SQL language 1. DML(data manipulation Language): Used to insert, modify, and delete data in a table, such as insert,update,delect . 2. DDL(data definitionLanguage):

Transferred from: http://www.cnblogs.com/caoruiy/p/4486249.htmlGrammar:To create a stored procedure:CREATE [definer = {User|current_user}] PROCEDURE sp_name ([Proc_parameter [, Proc_parameter ...]) [Characteristics ...]

Mysql-redundancy and duplicate indexes, mysql-redundant Indexes Mysql allows you to create multiple indexes on the same column, whether intentionally or unintentionally. mysql needs to maintain duplicate indexes separately, and the optimizer also

MySQL Base, mysqlbase /* Connect and disconnect the server */mysql-h address-P port-u username-p Password---> Input pwd /* Database storage engine */InnoDB:1) Ability to submit, roll back, crash recovery, and transaction processing (ACID)2) handling

Mysql master-slave copy notes, mysql master-slave notes I. Introduction to the test environment The master-slave replication test environment is ubuntu + mysql5.7, the master server ip address is 192.168.71.135, the slave server ip address is 192.168

Mysql introduction and compilation and installation, Mysql introduction compilation and Installation =========== MYSQL Working principle: 1. database Introduction: Simply put, a database is a data storage warehouse, which stores data on disks

Mysql query results are ordered by IDS in (). mysql query results Mysql query results are ordered by IDS in (). Instance code: select style_num_id, style_id, style_title, style_pic FROM gb_style where online = 1 AND is_hide = 0 and style_num_id