MySQL

After installing MySQL on the server, want to use the local MySQL client connection database, the prompt does not allow the connection, compared depressed, found this article solved my problem:The contents are as follows:Local Computer ip:192.168.1.1

1. When the database is established, the specified database db_test is UTF8 encoded. ：Create database db_test character set UTF8;The commands to modify the database Db_test encoding are:ALTER DATABASE db_test character set UTF8;2. Check the current

When MySQL builds a table with two or more fields timestamp, the following error may occur:Incorrect table definition; There can is only one TIMESTAMP column with Current_timestamp in DEFAULT or on UPDATEThe reason is that when you set the timestamp

Here I summarize the common methods for judging whether records exist:SQL statement: SELECT COUNT (*) from TableName;The value of Count (*) is then read to determine if the record exists. For this method of performance is a bit wasteful, we just

1. export The data to a file on Windows first. (for example, here is a database)导出整个数据库mysqldump -u 用户名 -p密码 数据库名 > 导出的文件名导出指定表mysqldump -u 用户名 -p密码 数据库名 表名1 表名2... > 导出的文件名2. Copy data from Windows to Linux.3. Log in to the MySQL database of Linux4.

Start MySQL[Email protected] tools]# systemctl start mysqldConnect to MySQL as root[Email protected] tools]# mysql-u rootWelcome to the MySQL Monitor. Commands End With; or \g.Your MySQL Connection ID is 8Server version:5.6.25 MySQL Community Server

In web development, we often need to insert data from one table into another, and sometimes we need to specify an import field, which only needs to import records that do not exist in the target table, although these can be broken down into simple

If you want to myuser use MyPassword from any host to connect to the MySQL server:GRANT All Privileges on *. * to ' MyUser '@ '%' by'mypassword' withGRANTOPTION;If you want to allow users to connect to the MySQL server from a host myuser IP 192.1

Reference: Write a MySQL stored procedure for dynamic execution of SQL, or you can use temporary tables instead of views.Drop procedure if existsP_simulate_dynamic_cursor;Create procedurep_simulate_dynamic_cursor ()begin DeclareV_sqlvarchar(4000);

If there is no lock, concurrency is stronger, but data security can be problematic. So the database locks the data.Shared and exclusive locks也就是读写锁，共享锁可以叠加共享锁但是不能加排他锁， 排他锁则不能叠加。根据隔离级别等等，mysql会隐式的给数据自动加锁此外还可以使用share in model, for update

This semester studied the principle of database system, did the experiment, mark a remember.Directory (without a key directory not happy ...) )1. T-SQL simple query, connection query(1) Using SQL statements to build a library, build a table, and

Title1.100W data insertion, define while loop to execute 100W times from the 1-100w,insert statement, run from 11 o'clock to 10 in the morning of the next day, a total of 11 hours!!!1 DELIMITER $$2 3DROP PROCEDUREIFEXISTS ' Havefun '.'

When OpenID equals the Mendian field in the current Openid,order table and the contents of the ID field in Mendian, the order table is associated Mendian with the order form, and the data in the table order is taken out., (as M and as O are the

Reprint please indicate the source:This article is from: "Ouyida3 's Blog"1, Basicdatasourcefactorycaused by:java.lang.ClassNotFoundException:org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactorySolution: The original Oracle factory in Tomcat forgot to

ALTER TABLE????? ??? ??? ???? ?? (Heap, MyIsam, InnoDB ...)? ???? ??? ???. ?? ??? ?? ??? ??? ?? ??? ?? ????? ???? ????.[???? ?? ????]??) ALTER TABLE [????] type=[??????]"??? ???"?? Heap, MyIsam, InnoDB ...??? ???? ^^??? MyIsam?? ??? MyTable?? ???? ??

Use MySQL;DBName database query permissions to the [email protected] users, should maintain full user information, including the IP allowed to log in, or will add any host usersGrant Select on dbname.* to [email protected];Reclaim PermissionsRevoke

#wget http://www.cmake.org/files/v3.2/cmake-3.2.2.tar.gzYum-y install make gcc-c++ cmake bison-devel ncurses-develwget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.25.tar.gzGunzip mysql-5.6.25.tar.gzTAR-XVF Mysql-5.6.25.tarCD

MySQL master-Slave synchronization architecture is currently one of the most used database schemas, the Mysam engine is responsible for adding modified delete operations, the INNODB engine is responsible for querying, so-called read-write separation.

Environment: Centos6.6, python2.6Preparatory work:MySQL installation, as well as the installation of Mysql-python http://www.cnblogs.com/zychengzhiit1/p/4437310.html　　1. Create a Python projectdjango-admin.py Startproject Pythondemo2. Enter the

First, the database conceptThe warehouse used to store the dataHierarchical modelMesh modelRelational model (two-dimensional table) [MySQL, SQL Server, DB2, Oracle]Second, the design of relational model database1, conceptual design (E-R Figure 1:1 1: