MySQL

Mysql grant permission assignment password modification www.2cto.com 1. Modify mysql-u root-p in the database and press enter to enter the password mysql> user mysql> select user, password from user; # view the PASSWORD # The PASSWORD is 41 BITs. It

Mysql opens the general log. After mysql opens the general log, all query statements can be obtained in the general log file in readable mode, but the general log file will be very large, therefore, it is disabled by default. In some cases, you need

Mysql timestamp and int storage time SQL code www.2cto.com show create table 20130107 date; CREATE TABLE '30301_date' ('id' int (11) NOT NULL AUTO_INCREMENT, 'C _ date' timestamp not null default CURRENT_TIMESTAMP, 'c _ date_long 'int (20) not null,

MySQL Reading Notes about table_lock_wait and table_lock_immediate received a document from a fellow user a few days ago, which is MySQL High Performance 2 Reading Notes, 97 pages, 6 w words. After describing the knowledge point, I hope to discuss

Ubuntu 11.10 mysql forget the root password solution 1. Run # killall mysqld 2 under the root account, and then run the following command www.2cto.com # mysqld -- skip-grant-tables // stop in the command line 3. Open a new command line, then run the

MySQL foreign key constraint mode if the primary keyword of Table A is A field in Table B, this field is called the foreign key of Table B, table A is called the primary table, and table B is called the slave table. Foreign keys are used to achieve

The steps for generating a random password for MySQL are simplified, which is more concise than the previous steps. Www.2cto.com [SQL] DELIMITER $ USE't _ girl '$ DROP FUNCTION IF EXISTS 'func _ range_string_mod' $ CREATE DEFINER = 'root' @

MySQL introduces the concept of stored procedure. Stored Procedures can improve execution efficiency and facilitate maintenance. Before there is no procedure concept, the common business logic SQL code is sometimes very long, and they are usually

The Principle and Implementation of the infinite classification of mysql left and right values is a very common application in our development. The most common and simplest method is id, name, f_id in MySql. The advantage is simplicity and simple

MySQL user creation and authorization environment www.2cto.com MySQL 5.1 + command line tool problem MySQL user creation and authorization solution 1. log on as the root USER to CREATE a new USER [SQL] C: \ Users \ Wentasy> mysql-uroot-p mysql>

MySQL time computing is a project today and requires mysql time function computing. So I searched for the MySQL time function documentation and finally asked me to find it. Now I want to give it to you. In the MYSQL function, I find several time

Mysql5.5.28.tar.gz compilation and Installation notes 1. yum installation dependency package yum install wget gcc-c ++ make cmake ncurses-devel libtool zilib-devel-y 2. Create mysql useradd-s/ sbin/nologin-M mysql 3. Compile and install

Mysql oracle SQL MYSQL Java code drop TABLE if EXISTS tmp_t; create TABLE tmp_t select min (id) id, 'name' from comp_info group by 'name' having count ('name')> 1; delete. * from comp_info a, tmp_t B where B. 'name' =. 'name' and. id> B. id;

Mysql starts and closes the shell script Java code #! /Bin/sh mysql_port = 3306 mysql_username = "root" mysql_password = "" function_start_mysql () {printf "Starting MySQL... \ n "/bin/sh/data/mysql/bin/mysqld_safe -- defaults-file =/data/mysql/$

Command mysqldump-hhostname-uusername-ppassword databasename> backupfile to back up MySQL database. the SQL backup MySQL database is in the format of a table with deletion. the MySQL database is in the format of a table with deletion. This allows

MySQL InnoDB Storage engine lock mechanism experiment MySQL's InnoDB Storage engine uses row-level locks, and the default transaction isolation level is Repeatable read, unlike Oracle's default transaction isolation level commit read. What is the

In Mysql, the sorting in SQL optimization is partially parsed in mysql. The copied SQL statements normalize the search results. Here there are sorting and grouping, statistics and other related sorting processes. sorting algorithms are of the

Mysql import. run the following command in the dos mysql installation directory/BIN directory: mysql-u username-p databasename use database_name and then run the following command mysql> source 111. SQL is 111 by default. the SQL path must be put in

Mysql 5.6.10 parameters (verification) my. there are two INI files that must be changed: Cancel table_cache and log-slow-queries = slow. log must be changed to slow-query-log-file = slow. log [mysqld] port = 3306 available basedir = D:/wamp/mysql

Mysql Command master-to-master 1. the select statement combines two string fields into one field: select concat (a, B) as c from tables 2. query by date group select DATE_FORMAT (created_at, '% Y-% m-% d % H') as t from tables group by t 3. mysql