Put the Mysql.exe in the bin directory under the MySQL directory under C:\WINDOWS, and you can execute the following command
Connection: Mysql-h host address-u user name-P user Password (note: U and root can be without spaces, others are the
Since the PHP and MySQL has a certain understanding, I will be in the company's huge Excel database eyeing, want to secretly "share" the confidential business data, while pondering how to get the hand, while thinking about how to convert into a
MySQL seems to start from 5.0 before the introduction of stored procedures, anyway before the application has never touched, but now because the main internal system, so many applications are used to the stored procedures, of course, the front
CMD command
CMD is the abbreviation for command. That is, the "MS-DOS" in OS/2, Windows CE and Windows NT platform based operating systems (including Windows 2000 and XP, Vista, and Server 2003) Way. " The command prompt in the Chinese version of
First, the use of mysqldump
1, mysqldump Backup Database
1. Enter the MySQL installation file bin directory, such as:d:\mysql5.5\bin>
2. Backing up the database with the mysqldump-uroot-p123 qh>d:\qh.sql command
mysqldump-uroot-p123 Login to
One, MySQL: index in B-Tree format saveThe memory storage engine can select either a hash or a btree index, and the hash index can only be used for = or equality comparisons.
1. Normal index: CREATE index on TableName (List of columns)
ALTER
Modify My.ini, add under [mysqld]
default-storage-engine=INNODB
Where the red font part is the name of the engine to be specified.
To modify an engine that has completed a table with SQL statements:
ALTER TABLE TableName TYPE=INNODB
My
Show tables or show tables from DATABASE;
Explanation: Displays the names of all tables in the current database
Show DATABASES;
Explanation: Displays the names of all the databases in MySQL
Show Processlist;
Explanation: Displays all processes
When you write access to MySQL database program, it is not very troublesome: a large set of functions and parameters, but also to check the results of the call, more headaches is every program to include database name, user, password, etc., want to
Scheduled backup MySQL
Put/etc/cron.hourly/
Copy Code code as follows:
#!/bin/bash
Dump=/usr/local/webserver/mysql/bin/mysqldump
out_dir=/data1/backup/
Db_name= database name
db_user= Database User
db_pass= Database
In MySQL database operations, we often write some SQL statements to achieve the desired functionality. But for the novice MySQL database, this seems to have a certain degree of difficulty. In this article we have summed up six of the more useful SQL
MySQL set up a large number of character sets, from the client to connect to the result set, from the server to the table to the column, can set the character set, flexible is very powerful, but it is very easy to problem, if not understand its
Recently, I helped my colleagues rewrite a MySQL SQL statement, the SQL statement involves two tables, one of which is a dictionary (a field needs to be returned), the other table is a business table (there are 150 fields in itself, all are returned)
This paper analyzes the effect of string index on update in MySQL. Share to everyone for your reference, specific as follows:
When you add a prefix index to a field that has a type of varchar, the conditional query time is substantially reduced
These two days the new server MySQL always automatically stop, check the log
9:13:57 [note] Mysql:normal shutdown9:13:57 [note] Event scheduler:purging the queue. 0 Events9:13:57 innodb:starting shutdown ...9:13:58 Innodb:shutdown completed; Log
In MySQL, how do you use SQL statements to rename a field in a table? We will use ALTER TABLE, an SQL statement.
The syntax for renaming a field is: ALTER TABLE change .
Now let's try to rename the T_name field in the test table to the
With its excellent performance, low cost and rich resources, MySQL has become the preferred relational database for most Internet companies. Although excellent performance, but the so-called "good horse with a good saddle", how to better use it, has
Scene
Product has a picture table, data volume of nearly 1 million, there is a related query statement, due to the high frequency of execution, want to optimize for this statement
Table structure is simple, main fields:
Copy Code code as
This article describes the two-level linkage menu effect implemented by Php+mysql. Share to everyone for your reference, specific as follows:
Generation College Professional cascading pull-down menu test /*******************************
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