Yesterday because the classmate's MySQL database did not know what to do, resulting in the root user can not use theIn particular, the use of root users do not need to enter the password can only see the Infomation_schema table, feel the root
In general, this information exists in the tables table of the INFORMATION_SCHEMA databaseMysql>desc INFORMATION_SCHEMA. TABLES;+-----------------+---------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+--
1. Check the book price, if the price is null, then show unknown, if the price is 10 to 20, then show the 20SELECT price,case when price= ' null ' then ' Unknow ' when the price>10 and price2.Select name, case if birthday ' 1988 ' Then '
Because the InnoDB preset is Row-level lock, MySQL executes row lock only when the primary key is explicitly specified, otherwise MySQL will execute table lock.1, explicitly specify the primary key is a row lock2, explicitly specify the primary key,
MySQL Installation tutorialPreparing the MySQL installation package in advance (: http://mirrors.sohu.com/mysql/MySQL-5.6/)The small part here is: mysql-5.6.34-linux-glibc2.5-x86_64.tar.gzIf necessary, contact the small part is responsible for
PackageCom.swift;//The package imported here is java.sql.Connection instead of Com.mysql.jdbc.ConnectionImportjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.SQLException; Public classTESTJDBC { Public Static voidMain (string[] args)
A brief introduction: Met was asked a parallel update lock problem, let me tangled for a while, later consulted the expert, finally figured.Two experiments:CREATE TABLE ' test1 ' (' ID ' varchar ($) Not NULL COMMENT ' id ',' NAME ' varchar (+)
Their system in a large number of users at the same time registered login, the terminal load is very large, because registration and login, not only to check the user's account, but also need to modify the read user-related Package information table.
Solution:Just add the following sentence before executing an ACTION statement (query operation, etc.) in a C + + program:mysql_query (&mysql, "Set names UTF8");The UTF8 here must be executed with the SQL statement in the database: the code in the
In the installation of MySQL, there are cases where the original permissions cannot be deleted. After research, you need to manually remove permissions by following these steps.1. Start the MySQL service mysqld start2. Go to MySQL database, use
Things go throughOne day, a sales C of our company's outer area said he could not find the workflow record for the previous August 3. Ask the reason, the original is updated number (our company's workflow is based on enterprise development). After
SQL statementsTo create a table:1 Create Table table name (2 column name type can be empty,3 column name type can be empty 4 ) ENGINE=DEFAULT CHARSET=UTF8;1 Create TableSchool (2Nidint not NULL Primary Key,3Namevarchar( -)4)
http://downloads.mysql.com/archives/community/First, MySQL Installer 5.6.26Mysql-installer-community-5.6.26.0.msi, 364.2MBMySQL Installer provides an easy-to-use, wizard-based installation experience for MySQL software (currently only supported by
A: MySQL Permissions table user field in detail:Select_priv. Determines whether the user can select data through the Select command.Insert_priv. Determines whether the user can insert data through the Insert command.Update_priv. Determines whether
Install the MySQL database on linux, set the user password, and log on to MySQL and linuxmysql.
Install the MySQL database on the newly installed Centos system.
Ti Jun blog original
> Ti Jun blog original http://www.cnblogs.com/tijun/
Step 1:
Record MySQL user data retrieval and mysql user Retrieval
Incident Handling
One day, a sales clerk in our company's external region said he could not find his workflow record before January 1, August 3. The reason is that the number is updated (our
The mysql index does not take effect.
Mysql used by the company's services has been slow recently during query. It often takes more than 10 seconds to check the query execution plan and find that the index does not take effect.
The storage engine
[Personal notes] Three relationships: one-to-one, one-to-many, and many-to-many ., Zhijintang: one-to-one
One-to-one: for example, a student corresponds to an ID card number and student archive;
One-to-many: A class can have many students, but one
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