Mysql Database Basic Learning Notes

2. Database Basics
   1. The database is the warehouse of storing data, realizes the data sharing, reduces the data redundancy, adopts the specific data type, has the high data independence, has the data control function.
   2. Table, is a two-dimensional array used to store data and manipulate the logical structure of data.
   3. Data types, integer data types, floating-point data types, exact decimal types, binary data types, date/Time data types, string data types.
   4. The primary key is used to uniquely label each record in the table. You can define a column or more primary keys. The primary key cannot be the same.
4. Database Technology composition     hardware, software together constitute
   1. database system, database, database management system (DBMS), database application.

       

   2. SQL language   Structured Query Language, 3 main standard ANSI (US National Standards Agency) SQL; the sql,sql of different versions of each major vendor contains 4 sections, as follows:
      1. data Definition language (DDL): Drop,create,a Lter and other statements.
      2. Data Manipulation Language (DML): Insert,update,delete statement.
      3. Data Query Language (DQL): SELECT statement.
      4. Data Control Language (DCL): statements such as Grant,revoke,commit,roolback. The
   3. database provider
      1. ODBC Open database Connectivity develops databases that are interconnected and do not rely on the DBMS to handle all databases in a consensual manner.
      2. JDBC java Data Base connectivity  for Java Applications
      3. ADO Microsoft has developed and designed to interact with the database under the. NET Framework.
      4. PDO php Data Object PHP accesses the interface defined by the database.
6. What is MySQL: Small relational database management system
   1. Client-Server Software.
   2. MySQL version, MySQL Community Server Community Edition. MySQL Enterprise Server Corporate Edition Servers
   3. MySQL's advantages: fast speed, low price (free), easy to use, portability, rich interface, support query language, security and connectivity.
   4. New features of MySQL 5.7, support for JSON, performance and scalability, improved replication to improve usability performance, performance patterns provide better perspective, security, optimization, new GIS features, parcel InnoDB spatial index, use of Boost.geometry, colleagues improve integrity and standard compliance.
7. MySQL Tools
   2. MySQL Command-line utility
   4. Server-side use of tool programs
   1. mysqld, SQL daemon, process.
   2. Mysqld_safe, startup scripts, recommended for UNIX and NetWare.
   3. Mysql.server Server Startup scripts
   4. Mysql_multi, a server startup script that can start or stop multiple servers installed on the system.
   5. Myisamchk, used to describe, inspect, optimize and maintain MyISAM tables.
   6. Mysqlbug, MySQL bug report script. Send a bug report to the MySQL messaging system.
   7. mysql_install_db, the script creates a MySQL authorization table with default permissions, which is usually performed once when MySQL is first installed on the system.
   6. Client Tools
      1. Myisampack A tool that compresses the MyISAM table to produce a smaller read-only table.
      2. MySQL, interactively input SQL statements or execute their command-line tools from a file in batch mode.
      3. Mysqlaccess Check the script that accesses the permissions of the hostname, user name, and database combination.
      4. Mysqladmin client programs that perform administrative operations, such as creating a cargo deletion database, overloading the authorization table, flushing the table to the hard disk, and reopening the log file, as well as indexing the version, process, and status information for the server.
      5. The Mysqlbinlog tool, which reads statements from binary logs, contains executed statements in a binary log file that can be used to help the system recover from a crash.
      6. Mysqlcheck, check the repair analysis and optimize the list of targets to maintain the client program.
      7. Mysqldump the client program that dumps the MySQL database to a file.
      8. Mysqlhotcopy a tool to quickly back up a myisam or ISAM table when the server is running.
      9. MySQL import: Use load DATA infile to import the file into the related table's client program.
      10. Mysqlshow, displays the database, table, column, and index-related client programs.
      11. PERROR Displays the system cargo MySQL error code meaning of the tool.
   8. MySQL Workbench Next-generation Visual Database design software, Visual database operating environment, the main functions are:
      1. Database design and model building.
      2. SQL Development replaces MySQL Query Browser
      3. Database management replaces MySQL Administrator
      4. Divided into Community Edition and commercial edition
9. How to learn MySQL
   1. Cultivate interest.
   2. Consolidate the foundation.
   3. Learn new knowledge in a timely manner.
   4. Multi-time operation.

Mysql Database Basics Learning Note