pycharm+django+python3.4First install Python3.4.2 next install MySQL will prompt pythonconnector install this plug-in, using Pycharm to build the projectsettings.py Find the configuration item, attached
1. Log in to the database>mysql-h localhost-u root-p Database name2. Querying all the databases>show databases;3. Select a database>use database name;4. Querying all data Sheets>show tables;5. Querying the table for field information>DESC table name;
Export all librariesmysqldump-uroot-p123456--all-databases > All_databases.sqlImport all librariesmysql-uroot-p123456 The issues to be noted in the Data guide:1. ERROR 2006 (HY000): MySQL server has gone awayThis typically occurs when you import an
1, first, look at MySQL several built-in time functionsSELECT Current_timestamp Current_time (), sysdate ();The results are as follows:2, built-in function to calculate the time difference TimestampdiffTimestampdiff (INTERVAL,DATETIME_EXPR1,DATETIME_
1, choose the most applicable field properties, as far as possible to reduce the definition of field length, as far as possible to set the field not NULL, such as ' Province, gender ', preferably set to enum2. Use connection (join) instead of
Retrieve ID = 2 or id = 5 or id = 9 or id = or id = 38.Then according to 2, 5, 9, 56, 38 in this order, this is the topic requires the following for the solution: 1. SELECT * from ' test ' WHERE ' id ' in (2,5,9,56,38) the ORDER by FIELD (' id ', 2,5
Reset Root Password:1. Edit the MySQL master profile my.cnfvim/etc/my.cnfAdd a parameter under the [Mysqld] fieldskip-grant2. Restart the database serviceService mysqld Restart3. This allows access to the database without authorization.Mysql-uroot4.
:http://yunpan.cn/cKNFtdKAzicNn access password 4CBB(The package on the left for Dblinq "contains my auxiliary script" to the right of my written auxiliary script "has downloaded Dblinq's pro can only download script")I have been engaged in the
The version I installed is MYSQL-5.6.21-OSX10.9-X86_64.DMG, which prompts installation to fail when installed on a Mac OS X 10.10 system, such as.WorkaroundDuring the third step of the installation process, select Custom when the installation type
mysql5.6 installation http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.htmlMD input: Net start MySQL, service started successfullyMysql-u root-p (First login no password, directly press ENTER), login success!Mysql> Show databases;+----------
Basic conditions:No indexMain Table TEST_0 data: 1 million Database engine InnoDbSub-table test_1...test_100 data per 10,000, altogether 1 million database engine InnoDbProcess:100 data is modified in the main table to calculate the time spentModify
Automatically backs up the MySQL database scripts every day and automatically sends them to the mailbox you specify so that Vpser no longer worries about losing data.Mysqldump-uuser-ppassword–databases db1 DB2 db3
Linux start-up programs are generally placed in the/etc/rc.d/init.d/,/etc/init.d/is its soft connectionMySQL Set as Linux serviceCp/usr/local/mysql5/share/mysql/mysql.server/etc/init.d/mysqldChkconfig--add mysqld chkconfig--level 2345 mysqld onChown
Install mysql in linux
1. Download mysql. Here I advocate binary installation.
Use winSCP to transmit the downloaded mysql to the linux Server
2. decompress the downloaded mysql package
#tar -zxvf /{MySQL5.6_path}/mysql-{version}.tar.gzHere there
How to start MySQL from Windows Command Line
To start the mysqld server from the command line, you should start the console window (or "DOS window") and enter the command:
C: \> C: \ Program Files \ MySQL Server 5.0 \ bin \ mysqld
The path used
Mysql table names in Linux are case-insensitive.Scenario: Recently, the company switched the database from Oracle to Mysql. Since the table names in Oracle are case insensitive, the problem of table names not found in Mysql occurs, it is found that
Mysql connection usage instance, mysql usage instance
This article describes the usage of mysql connections between left and right. Share it with you for your reference. The details are as follows:
Use an example to parse the left, right, and Inner
Summary of the use of the if and case statements in MySQL, And the mysqlifcase statement
Mysql if can be used as an expression or a flow control statement in a stored procedure. The following statements are used as expressions:
IF expressionCopy
Garbled characters in MySQL data migration
If MySQL Data is transplanted from a lower version of mysql to a later version, it is prone to garbled characters when the transplanted data contains Chinese data. Many of them are migrated from MySQL4.x to
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