MySQL

In order to facilitate the performance of testing, table and other work, it is necessary to establish a larger data table. I'm going to build a tens of millions of user tables here first. Step: 1 Create a data table (MyISAM mode storage insert speed

1. Download MySQLAccess https://dev.mysql.com/downloads/mysql/5.6.html#downloads, download the corresponding version of the operating system (no account needs to register one first), take Mysql-5.6.38-win32 as an example2. UnzipTake decompression to

1, view database: show databases;2, using Database: Use database name;3, Enquiry form: Show tables;4, view table structure :desc table;4, CREATE TABLE, delete table, modify etc settings, Navicat can be easily done, not recorded5, add, delete, change,

Data types in MySQL (String type)Character Typedata types in the six databaseschar, varchar, text, Blob,enum,setChar and varcharchar fixed length: Disk space is wasted, but high efficiency, determine the length of the data is the same, the use of

About Char,varchar and text usually do not care too much, in general, probably now everyone is using varchar. But when the content to be stored is larger, what is the choice between varchar or text? I don't know......text, char, varchar are the data

MySQL comes with the IP conversion statement Inet_aton: Convert IP address to digital type Inet_ntoa: Converting a digital type to an IP address //Use the Inet_aton function to convert a string IP to an integer type; MySQL>

Problem: The program reported the error of table ' xxx ' doesn ' t exist, but the view database found that the table already exists and the letters are not misspelled.Cause: MySQL on Linux defaults to case sensitivity.FIX: Change the MySQL

1, the query when the timestamp format display:SELECT from_unixtime (1234567890, '%y-%m-%d%h:%i:%s ') from table_name2. The most efficient method of deleting duplicate records (because of the use of rowID) Example:DELETE from emp E where E.rowid >

In MySQL, a blob is a binary large object, a container that can store large amounts of data, which can accommodate different sizes of data. The Blob type is actually a type family (Tinyblob, Blob, Mediumblob, Longblob) and they are equivalent except

Installation Environment: Centos6.5MySQL version: mysql-5.5.32.tar.gzOne: Prepare before installation:1. Install some dependent librariesYum install cmake gcc gcc-c++ ncurses-devel Bison perl zilb-devel libio-devel perl-devel-y2. Create a MySQL user

Table: ID Tag Status1A02B03C14D1First,Groupby usage1. Combined count with CountSelectStatusCount(*) from Table Group bystatusStatus Count (*)0 21 22. Used in conjunction with Group_concatSelectStatus,group_concat (tag) as tag

1 #Coding=utf-82 3 ImportJSON4 ImportPymysql5 6db = Pymysql.connect ("localhost","Root","asdfg48520.","Test", Use_unicode=true, charset="UTF8")7cursor =db.cursor ()8sql ="""DROP TABLE IF EXISTS SHUJU1"""9 cursor.execute (SQL)Ten Onesql ="""CREATE

The modified users are listed as root.first, the root of the original myql password;Method One:Outside the MySQL system, use the Mysqladmin#mysqladmin-u root-p Password "test123"Enter Password: "Enter the original password"Method Two:By logging into

How to allow remote connection to MySQL database, the operation is as follows:First login account Mysql-uroot-p Using a MySQL user Use MySQL If you report this type of error: Error 1820 (HY000): You must SET PASSWORD

#登录Mysql-uroot-p123#查看用户Select User ();#退出QuitExit\q#查看帮助信息Help create user;#创建账号Create user ' Egon ' @ ' 192.168.11.* ' identified by ' 123 ';Create user ' Egon ' @ ' 192.168.11.1 ' identifled by ' 123 ';Create user ' Egon ' @ '% ' indenrified by '

Analysis of mysql indexes and Analysis of mysql A database index is a data structure designed to speed up table operations. You can use one or more columns to create an index by providing fast random search and Efficient Sorting of access

Use code parsing for user variables in mysql query statements, mysql statements In the previous article, we introduced MySQL optimization Summary-Total number of queries. This article introduces another knowledge in the query statement: code parsing

Mysql-innoDB-transaction,Transaction isolation level: 　　Read uncommitted (uncommitted read) At this level, the modifications in the transaction are visible to other transactions even if they are not committed, and the transaction can read

MySQL trigger,Trigger In Mysql, a trigger is a database object related to table operations. When a specified event occurs on the table where the trigger is located, this object is called, that is, the Operation Event of the table triggers the

Queries whether all tables in the specified database contain specified fields and database fields. Today, we encountered a problem: to update the values of a field in the database in batches, we need to first find the tables that contain this field,