Show Table status;//View all table states, with this command to know when the table was created and when it was last updated, and whether the table is a base table or a view, and what table engine is the information.Show table status from DBName
Where,group by,having Re-explanationWhere to use:Where is used with in with, in (value 1, value 2, ...) ) indicates the result at value 1, value 2,。。。 Any one of them. Aggregate functions and the use of GROUP by:Aggregation function: In a select
If you forget the root password or other user password, do not worry, just follow the steps below. 1. Edit the MySQL master profile my.cnfvim/etc/my.cnfAdd a parameter under the [mysqld] field skip-grant2. Restart the database serviceService mysqld
Backup and restore of databasesDatabase backup and restore is the content of the later chapters, but in the learning time has required the backup and restore of the data, so I learned a bit. The database has many kinds of backup methods, and I'm
How to change the MyISAM type table in a MySQL database to a table of type InnoDBChange a single tableALTER TABLE TABLENAME ENGINE=InnoDB; ALTER TABLE TABLENAME ENGINE=MyISAM;Change multiple tablesSELECT ' "' engine=innodb; ' )from
Go to your MySQL bin directory firstCD D:/php/mysql/binEnter command mysql-u user name-p password database name for exportMysql-u root-p root eee In the event of the following errorMYSQL server has gone awayPlease modify the configuration file
Four steps for MySQL password setup in xampp (assuming you want to set a password of 123456)1, enter Http://localhost/phpmyadmin enter phpMyAdmin page Click Mysql->user in the host for the Host,user as the root of the column enter 1234562, go back
MySQL can be custom sorted by field () function, Format:field (VALUE,STR1,STR2,STR3,STR4),value and str1, str2,str3,str4 Compare, return 1,2,3,4, if encountered null or the data that is not in the list returns 0. Mysql> SELECT * from
1: Use the show statement to find out what database currently exists on the server:Mysql> SHOW DATABASES;2: Create a database Mysqldatamysql> CREATE DATABASE Mysqldata;3: Select the database you createdmysql> use Mysqldata; (press ENTER to appear
Installing NginxHow is the Windows version installed as a service?
Download Nginx Windows version
Download Microsoft's 2 tools: Instsrv.exe
Run commandInstsrv Nginx C:\nginx\nginx.exe, this installs a Nginx service
Configuring
There are several prerequisites for using the MySQL event feature:One: The version used must be 5.1 or above, because 5.1 support this feature laterSecond: Check if the event function is turned on:SHOW VARIABLES like ' Event_scheduler ';Show Off is
MySQL configuration for master-slave replicationOne, my.ini configuration file modification:1. Modify on the primary server:[Mysqld]#datadir =f:/application/mysql5.6/dataport=5616Event_scheduler=onMax_allowed_packet = 16MSkip-name-resolveSql_mode=
Set names UTF8;Set names shows what character set is used in the SQL statement sent by the client. Therefore, the set NAMES ' cp1251 ' statement tells the server to use the character set cp1251 "for future messages from this client." It also
Upload DLL files to any directory, such as: D:/recycler/lib_mysqludf_sys.dllImport the DLL, import to the Windows or MySQL plug-in directory according to the version (typically execute SELECT @ @plugin_dir to see the plug-in Directory specific path):
1, Link databaseMysql-hlocalhost-uroot-pEnter Password:2, display the databaseshow databases;3, using the databaseUse database name;4. Delete DatabaseDrop database name5,create database name;Data sheet:1,create Table Data Sheet name (ID int (one)
When using Navicat for database management, when you look at the Table object, you will find that the number of records in the data table is changing every time you refresh, especially the large table.For 1 million of the data will often show more
Simple MySQL database operations
For children who want to engage in or love mysql-related work, it is necessary to implement some simple operations on mysql under the command line. This article describes how to log on to the mysql database server,
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