mymail sec

briefly demonstrate this situation: master [localhost] {msandbox} (Test) > CREATE TABLE Charset_test_utf8 (ID int primary key auto_increment, Char_col V Archar (m) charset = UTF8; Query OK, 0 rows affected (0.04 sec) master [localhost] {msandbox} (Test) > Set names GBK; Query OK, 0 rows Affected (0.00 sec) Master [localhost] {msandbox} (Test) > INSERT INTO Charset_test_utf8 (char_c OL) VALUE

management of MySQL usersFirst, view the current Connection account information1.1, view the current database to connect the account informationUse command: Show ProcesslistMySQL [(None)]> show processlist;+--------+-------------+---------------------+--------+---------+------+----------+------------------+| Id | User | Host | db | Command | Time | State | Info |+--------+-------------+---------------------+--------+---------+------+----------+------------------+| 232091 | Zabbix | 172.17.207.88

Tags: 1.7 configuration inux developed differently based on version specific SEL9.1 Creating a Database Command syntax: Create databaseIn the case of MySQL default character set, the database test is as follows: A. Creating a database named ZBF [emailprotected] 08:3120->create database zbf; Query OK, 1 row affected (0.00 sec) [emailprotected] 08:3810->show databases like ‘z%‘; +---------------+ | Database (z%) | +---------------+ | zbf | +----------

Label:1. Import Test Database dataBuild Libraryshow databases;CREATE datbase Easthome;Build tableCREATE TABLE TJ (name varchar (8), Tel Int (8));CREATE TABLE Sex (name varchar (8), sex int (1));Inserting informationINSERT into EASTHOME.TJ (Name,tel) VALUES (' Liyan ', 88888888);INSERT into EASTHOME.TJ (Name,tel) VALUES (' Zy ', 77777777);Insert into Easthome.sex (name,sex) VALUES (' Zy ', 1);mysql> INSERT INTO Easthome.sex (name,sex) VALUES (' Liyan ', 0);Query OK, 1 row Affected (0.00

undoubtedly be garbled.So here's a quick demonstration of the situation.master [localhost] {msandbox} (Test) > CREATE TABLE Charset_test_utf8 (ID int primary key auto_increment, Char_col Varc Har (()) charset = UTF8; Query OK, 0 rows affected (0.04 sec) master [localhost] {msandbox} (Test) > Set names GBK; Query OK, 0 rows Affected (0.00 sec) Master [localhost] {msandbox} (Test) > INSERT into Charset_test_

To create a table and insert a data statement:Mysql> CREATE TABLE salary (userid int,salary decimal (9,2));Query OK, 0 rows affected (0.11 sec)Mysql> INSERT into salary values (1,1000), (2,2000), (3,3000), (4,4000), (5,5000), (1,NULL);Query OK, 6 rows affected (0.13 sec)Records:6 duplicates:0 warnings:01.if (value,t,f) function: Above 2000 is considered ' high ' and the others are lowMysql> Select if (salar

. Select the rack package you need most and press the "OK" button.If the package already exists in your local repository, the wizard only joins the dependency information in Pom.xml, and the contents of the Pom.xml file are as followsXML codeIf the local repository is not available, then the wizard will go to Maven's server to download the rack package and download the log in the console output as follows:06-8-4 09:21 A.M. 07 sec: Local Repository fol

With the advent of LBS applications, it is particularly important to implement location-based search in databases. First, design a simple data table to store latitude and longitude information: CREATE TABLE `index` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lat` double NOT NULL, `lng` double NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8; After the creation is complete, we can check whether it looks like this. mysql> desc `index`;+-------+---------+------+-----+---------+---

-pp.noarch[Email protected] 09.mysql]# RPM-UVH mysql-community-*.rpm 2. Start the serviceSystemctl Start mysqldSystemctl Enable Mysqld 3. Information related to MySQL database serviceProcess name MysqldProcess owner and owning group MySQL MySQLDefault port number 3306Transport Protocol TCPConfiguration file/etc/my.cnfDatabase Directory/var/lib/mysqlLog file/var/log/mysqld.log (store initial password) Connect to the database service using the database administrator root user initial password[Emai

(NULL). Foreign KEY (English: foreign key). In fact, in a relational database, each data table is connected to each other by a relationship, and the parent key (primary key) is placed in another data table as a property to create relationships with each other, and this property is a foreign key. For example, students and teachers correspond to the teaching relationship, the student data sheet will have a property called the instructor (foreign key), and this value is corresponding to

|+--------------------+| information_schema (mysql) | | Test |+--------------------+3 rows in Set (0.06 sec)MySQL command, you need a semicolon at the end.2. Querying a table for a libraryFirst you need to switch to a library:mysql> Use mysql;database changedThen list the tables:Mysql> Show tables;+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv | |