MySQL Database basics

First, MySQL introduction two, MySQL installation 1. Linux installation MySQLInstalling with the Yum packageYum Install Mysql-server mysql-y2. Windows install MySQLDownload the Windows version of MySQL (MySQL Community Server) installation package

Importing MySQL data into a hive table with Sqoop

First, the data of a MySQL table is imported into HDFs using Sqoop1.1, first in MySQL to prepare a test tableMysql> descUser_info;+-----------+-------------+------+-----+---------+-------+|Field|Type| Null | Key | Default |Extra|+-----------+--------

What is the use of Json_merge functions in MySQL?

Requirements Description :With the Json_merge function in MySQL, you can combine multiple JSON objects into one objectOperation Process :1. View a table with JSON columnsMysql> SELECT * from tab_json;+----+--------------------------------------------

MySQL in case use

Foreword: Meet such a demand, have a result, the result only records the student's score, now needs to statistic student's grade, 100-90 divides into excellent, 90-60 divides into passes, 60-0 divides into the failure. This requirement can be

MySQL Query optimization Note the following four details

Original: http://bbs.landingbj.com/t-0-244231-1.htmlIn any database, query optimization is an unavoidable topic. For database engineers, optimization is the most challenging task. MySQL Open source database is no exception. In fact, the author

SQLAlchemy inserting data to MySQL exception

1. Insert Chinese Error:Add after database name? Charset=utf8Engine = Create_engine ("mysql+pymysql://root:[email protected]/data?charset=utf8", echo=true)2. Normal insertion, but prompt for the following warning:2018-06-06 16:28:39,789 INFO

MySQL dual master (master-master) supplement

Environment:Host name host IP operating system Mysqla 172.18.252.221 CentOS 6.5 2.6.32-431.EL6.X86_64MYSQLB 172.18.252.222 MySQL version mysql-community-server-5.7.5-0.6.m15. el6.x86_64 MySQL dual master + semi-synchronous architecture reference

The meaning of explain usage and results in MySQL

[SQL]View PlainCopyPrint? explain Select  *  from user Explain select * from user[SQL]View PlainCopyPrint? Explain extended Select  *  from user Explain extended select * from user Id Select

Database MySQL Learning (i)

Database: A warehouse in which data is stored and managed according to data structures.MySQL is a relational database management systemAfter MySQL is installed ...MySQL Start-up1: Find MySQL Right-click on "Services" in the control Panel to start2:

The code even MySQL from the library "Table ' Performance_schema.session_var"

Issue background:There are two MySQL, a master one from, developed in the code even MySQL cluster, found that there are errors. Even the main library single point OK, even from the library single point error:Table

MySQL user management, common SQL statements, database backup

MySQL User management Create a user and authorize login Grant all on * * to ' user1 ' @ ' 127.0.0.1 ' identified by ' 123456 ';第一个*表示db_name;第二个*表示tb_name指定其来源IP127.0.0.1(只可通过此IP登录)也可以使用通配符%,代表所有IPidentified by设置密码[[email protected] ~]

MySQL storage and query billion-tier data

The first stage: 1, be sure to correctly design index 2, it is important to avoid SQL statement full table scan, so SQL must go index (such as: all > MySQL storage and query billion-tier data

MARIADB installation, uninstallation, and related settings (Linux server MySQL deployment)

First, install MARIADB database on CENTOS7A. InstallationYum-y Install mariadb Mariadb-serverB. StartSystemctl Start mariadbC. System on self-bootingSystemctl Enable MARIADBD. Next mariadb simple configuration (can set the root user's

MySQL performance is a tuning of the Max_allowed_packet

MySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, resulting in failure.View current configurationShow VARIABLES like

Four types of transaction isolation levels for MySQL

Test environment for this experiment: Windows 10+cmd+mysql5.6.36+innodbI. Basic elements of a transaction (ACID)  1, atomicity (atomicity): All operations after the start of the transaction, or all done, or all do not, it is impossible to stagnate

MySQL Modify Time function adddate (date, INTERVAL expr unit)

MySQL Modify time function:1. Adddate (date,interval expr unit) INTERVAL represents the time interval :SELECT now (); 2018-06-20 15:00:00--Current timeSELECT adddate (' 2018-06-20 15:00:00 ', INTERVAL-60 SECOND) as time; 2018-06-20 14:59:00--minus 60

How does the SQL statement learned by MySQL database be optimized? Database development

dba

1) Scene catch the slow query statement show full processlist;2) configuration parameters:Slow_query_log_file = On slow query open switchlong_query_time = 2 record SQL statement greater than 2 secondsLog_queries_not_using_indexes = on does not use

Mysql: Database operations, data table operations, field operations collation

MySQL Login nativeMysql-u root-p PasswordDatabase operations Create a databaseCommand: Create databases For example:mysql> CREATE DATABASE xhkdb;Display Databaseshow databases;Connecting to a databaseUse examples;Create a database and set the

MySQL optimization (5): Index failure analysis, in and exists usage scenarios

One, the index failure situationAs mentioned earlier, it is possible to determine whether an index is invalid by explain's Possible_keys, key property, if key is null, the index is either not built or the index is invalid, and some of the conditions

MySQL Database (iv)

Paradigm in the database:First normal form (1NF):Each column (field) in the datasheet must be the smallest unit that cannot be split, that is, to ensure the atomicity of each column.例如: userInfo: ‘山东省烟台市 1318162008‘ 依照第一范式必须拆分成     userInfo: ‘山东省烟台市‘

Total Pages: 3233 1 .... 1263 1264 1265 1266 1267 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.