MySQL

DROP DATABASE mysql_shiyan;。CD /home/shiyanlou/desktopGit clone https://github.com/shiyanlou/SQL4 #打开 MySQL Servicesudo service MySQL startDescription: The sudo command is used to execute commands in other identities, and the default identity is

First we need to know what data we repeat,///Step one: Group the data tables, GROUP by.The second step: after the conduct through having to limit filtering, the number of bars greater than or equal to 2Step three: make multiple table

Database manipulation language DML; database query Language DQL; Database schema definition language DDL; Database control Language DCL; DDL database schema definition language View all the user's database, show databases; the command to delete the

1. Purpose: Resolve client concurrent access to your conflict issues2, the Classification of locks1. Lock type1. Read lock (Shared lock)Query (SELECT): After a lock is read, the table record cannot be changed, but can be queried.2. Write lock (mutex,

You can use any of the fields as criteria for sorting, returning the sorted query results. You can set multiple fields to sort. You can use the ASC or DESC keyword to set the query result to be sorted in ascending or descending order. By

[[Email protected] ~] #cd/opt/source/[[Email protected] ~] #tar-zxf mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz[[Email protected] ~] #ln-S/OPT/SOURCE/MYSQL-5.6.37-LINUX-GLIBC2.12-X86_64/USR/LOCAL/MHA[[Email protected] ~]

when logging into the database:Select@ @version;Selectversion (); Copy code MySQL>Select@ @version;+-----------+| @ @version |+-----------+|5.5. -|+-----------+1Rowinch Set(0.00sec) MySQL>Selectversion ();+-----------+| Version () |+-----------+|5.5.

1, first open 3306, allow any IP connectionIn/etc/mysql/mariable.conf.d/Vim 50-SERVER.CNFThis location is not the same as the location of the online blog.In the my.cnf file The last one contains a folder, go to the folder to find yourself (personal

Cascading replication ModeSince the number of connections to the primary database is limited in the master-slave replication mode, it is not necessary to build more than 10 slave libraries for the primary server when it is close to full load in

Before you know the Binlog log three modes, first understand the Binlog log to resolve the command workers Mysqlbinlog. The role of the Mysqlbinlog tool is to parse the MySQL binary binlog log content and parse the binary log into SQL statements

Hierarchical relationship of database to server and clientAbout the databaseHow you need to store data in your program:1 variables (list, tuple, collection, dictionary, nested)2 external memory (file) (*.ini)3 tables, Excel (*.xls, *.xlsx, *.csv)4

I used MySql in Tomcat and checked it online. For example, I want to modify the configuration file. Finally, we found a method: Put the mysql-connector-java-bin.jar In the Tomcat 7.0 \ Lib folder, restart the Tomcat service, (of course, MySQL

New features such as views, stored procedures, and triggers are added to MySQL 5. Many of them are described. One of them is called the store function, which is a bit like the stored procedure, but the returned value is Oh, the usage is quite

Summary of Permissions 1. Create an accountGrant all privileges on *. * To Z1 @ localhost;*. * Indicates that you have permissions on all the local databases and tables. You can change the permission to on test. user, and you have permissions on

The high-performance MySQL book has been downloaded from the computer for almost half a year and has no time to read it. In the end, I decided to spend some time reading this book every day in March. Here I will record some knowledge points in this

MySQL Command Line   First, start and stop the MySQL ServiceNet stop MySQLNet startMySQL Second, log on to MySQLSyntax: mysql-u User Name-P User PasswordType the mysql-uroot-p command,Enter the password, enter 12345, and then press enter to enter

MySQL automatic backup: Home page, you need to create a backup storage directory. For example, D: \ data \ db_bak \ database folder (the same name as the database is recommended for identification) Find the folder where the database file is located.

Now there is a table named student. I want to copy the data in this table to a new table named dust. Although the following statements can be used for copying, I always feel uncomfortable, thank you for your help.Answer 01:Create Table Dust select *

1. first, add a reference to the MySQL database driver jar in eclipse. Right-click the project and choose Properties> JAVA build path> libraries> Add external jars, navigate to the downloaded MySQL driver jar and click OK. 2. Access code

The actual operations in windows are as follows: 1. Disable running MySQL. 2. Open the DOS window and go to the MySQL \ bin directory. 3. Enter mysqld -- skip-grant-tables and press Enter. If no prompt is displayed, it is correct. 4. Open another