Database-Basic Concepts

1, database system = database + Database management system + application development tools + database Administrator + user + ... ；

2, SQL = Structured Query language;
SQL = DDL (data definition Language) +DML (Database Manipulation language) +DCL (Data Control language);

3. Data storage Development stage: Manual Management-File system phase-database system stage;

4, Common Database system: Oracle, DB2, Access, Sql_server, PostgreSQL, MySQL;

5, MySQL database classification: According to the deployment environment system information, MySQL database version information;

6, login MySQL database: mysql-h 127.0.0.1-u root-p;

7, configuration file Description: My.ini is the database is currently used by the configuration file, modify the file to achieve update configuration role;
My-huge.ini configuration file for super-large database;

My-large.ini is suitable for large database configuration files;

My-medium.ini suitable for medium-sized database configuration files;

My-small.ini is suitable for small database configuration files;
My-template.ini is a profile template, the MySQL Configuration Wizard writes the options in the configuration file to My.ini;

My-innodb-heavy-4g.ini indicates that the configuration file is valid only for the InnoDB storage engine and that the server's memory cannot be less than 4GB.

8. Manual/automatic start of MySQL service: net start MySQL (startup service); net stop MySQL (shutdown service)
Delete MySQL database: (1) Use EXE, MSI program installation situation: Re-click the installation program, the Installation Wizard interface to select the Remove option, click Next to completely delete the database;
(2) Using the compressed package installation: Run the C:/mysql/bin/mysql.exe--remove command in a DOS window (C:/mysql is the MySQL installation directory), and then delete the entire installation directory, and the My.ini file directly.

Database-Basic Concepts