SHOW VARIABLES like ' Event_scheduler '; ==> query Whether the event is turned onSET GLOBAL Event_scheduler = 1;==> Opens the event set Event_scheduler is always on in MY.CNF or My.ini, add event_scheduler=1 or mysqld.--event_scheduler=1
Http://www.cnblogs.com/mr-wid/archive/2013/05/09/3068229.htmlBlog Park A cow man wrote a MySQL QuickStart tutorial, if you are MySQL small white but later to use the database or want to know the database of students can understand.I went to a
The previous query is just a random look at the results, because found that the number of each query is very small, of course, it is now. But efficiency has always been the pursuit of the programmer, I will learn more about the gap.The first is the
SQL Simple Command Description:
Mysql.exe-u User name-p password-H IP address
show databases; View the database
The version number of the Select version ();p HP injection
Use database (table name);
Show tables; shows the table
1. Download the MySQL tarball 2. Unzip the package, add the bin to the path directory, create a new data folder, modify the My-default.ini file, modify the following options Basedir = D:\java\mysql-5.7.11-winx64datadir =
Because when I was doing. NET, I played PHP, so I used the Wamp server, and then I did the Java project, and I always used the above MySQL.But in the middle appeared several times garbled, the amount, today changed again wamp MySQL
Do not consider the main preparation. Clusters and other schemes, based on the design of the business is mainly the table structure and inter-table relationship design.As for the fields in the table are mainly defined by the business, we can specify
Mysql> ALTER TABLE name modify column field name type;For exampleThe Deploy_updateapp table Status field in the database is varchar (30)Modification types can be used (careful modification of types may result in errors in existing data)Mysql> ALTER
Delete data from a databaseThe delete from statement is used to delete records from a database table.Grammar= Some_valueNote: SQL is not case sensitive. Delete from is equivalent to delete from.In order for PHP to execute the above statement, we
Objective:Not every company is tall, not every company will use some very cutting-edge technology to do backup this piece, some enterprises or some industries or the team itself for various reasons use simple or complex way to do backup this piece,
MySQL basic information1. Installation directory/usr/local/mysql2. Data Catalog/home/mydb3. Configuration directory/etc/my.cnf4. Startup script/etc/init.d/mysqlPre-upgrade actions1, stop the online business, backup data Backup:
1 mysql-h localhost-u username-p Password-H does not write, default is localhostNote: It is best to mysql-h localhost-u username-p and press ENTER to build2 See what databases are availableshow databases;3 Creating a DatabaseCreate database PHP;(You
Replaced MySQL database with mariadb in CENTOS71. Make sure Yum is on the machine and perform the installation commandYum Install mariadb Maraidb-server2. Start MARIADBSystemctl start mariadb# Set boot Systemctl enable mariadb# close
Initialize mysql in Windows and mysql in windowsIn Linux, after mysql is installed, the service cannot be started directly. You must initialize the database first. Initialization mainly includes:
Initialize required files for logs, tablespaces,
MySQL variables and conditions, MySQL variable conditionsOverview
Variables are often used in stored procedures. The usage of variables is an important knowledge point, especially when defining conditions.
Mysql version: 5.6
Variable definition and
In linux, the mysql database is imported and exported.
Objective: To import data from mysql on the server to a Local Machine
Device: Local: Mac. Remote Server: linux
Log on to the server using ssh
Mysqldump-u [username]-p [database_name]> [/path/
In Linux, compile and install MySQL and parse the basic configuration process.
Install dependency:
CentOS:
# yum -y install wget gcc-c++ cmake make bison ncurses-devel perl unzip
Ubuntu: (using ubuntu requires a lot of root permissions. Please note
MYSQL error solution "Configuration file tmeplate E: \ website \ mysql \ my-template.ini cocould not", mysqlconfiguration
I started to try MYSQL today. I encountered some common problems when installing MYSQL. I hope it will be helpful to myself
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