MySQL

#cd/USR/LOCAL/SRC# tar Xvzf mysql-5.1.34.tar.gz# CD mysql-5.5.1.34Configuration and compilation#chmod +x Configure#./configure--prefix=/usr/local/mysql--enable-local-infile#makeMake will prompt for ABI-related errors, and at the end of the makefile

First, basic query, forget passwordInquire>show databases like ' MySQL ';>show databases like '%my% '; Query that contains my databasesSet Password#mysqladmin-u root password ' passwd ';Change Password#mysqladmin-u root-p ' passwd ' password '

1.mySQL Create stored process procedure as follows:/* The wonderful thing is to define a label [delimiter//] means procedure is not SQL, procedure's key word was eaten by the dog? */2. Process Control Language If then end if3.case when end

I. Automatic installation of MySQL via YumYum Install Mysql-server my-clientIi. initialization and related configurationAfter installing the MySQL database, you will find an extra mysqld service, and you can start the MySQL service by entering

SELECT @ @tx_isolation; Viewing isolation LevelsSet session transaction ISOLATION level READ UNCOMMITTED; Set READ UNCOMMITTED levelStart transaction; Open transactionRollback Rolling backCommit SubmitSet session transaction Isolation level Read

Reference: http://blog.sina.com.cn/s/blog_4b93170a0100mbkm.htmlMySQL default maximum connection number is 100, add the default MySQL connection number method has twoMethod One: Enter the MySQL installation directory to open the MySQL profile my.ini (

I almost did not write a blog, feel the knowledge to learn and to do too many things, no time. But found that the blog record their learning experience is very good, take time to write points for their future reference also share to some people, I

1. Change the remote root passwordMysqladmin-h ip-uroot-p123456 Password PasswordIf ' Access denied for user ' root ' @ ' IP ' (using Password:yes) appearsThe remote host does not allow logins other than localhost, so the permissions are

Problem Description:When I insert a record, an exception occurs when the Save method is called (the record repeats), causing the subsequent commit statement to fail. When I delete duplicate records in the database, I find that the table has been

recently used a hospital server, but do not know the password MySQL, helpless under their own to find a solution, the process is very simple Oh! First enter the following line of statements: Mysqld--defaults-file= "E:\MySQL Server 5.1\my.ini(here is

Requirement: Date data for seconds and minutes when the database is retainedProcess: In MySQL, the date data type can only be stored in the date, so only the DateTime type, that in JDBC, call the Settimestamp () method, when the data is fetched, use

Core operation: Delete and change (simplified version)(1) Increase1. Creating a database: Create DB ly;2. Creating table: Create table ly (id int);3. Add a record to the table: INSERT into ly (ID) values (1);(2) by deleting1. Delete database: Drop

1. Installation (1) See if the installation Yum List installed mysql* (2) View existing installation packages Yum List mysql* (3) Install MySQL server side Yum Install Mysql-dev Yum Install Mysql-server (4) Installing the

Ubuntu14.04 use rails to connect to the mysql database and ubuntu14.04rails Rails comes with sqlite3 in all aspects, but the free version lacks a fatal function: Add a password! Although the third party has a compiled binary version of the encrypted

Tongda OA mysql adds a column of commands at a certain position in the table to be judged by a program. You have to write a document and use a program in the middle to determine whether a Column exists. If it does not exist, add the document. If it

Mysql statement optimization Summary (1) SQL statement optimization and Indexing 1. Innerjoin and left join, right join, subquery A. inner join is also called an equijoin, while left/rightjoin is an outer join. Select a. id, A. name, B. id, B. name

The default Requirements for the Case sensitivity of Mysql tables in windows and linux are as follows: Today, I set up a project environment in a virtual machine. I stole my laziness and copied the tables in the local database to the database in

Definition of mysql Stored Procedure Variables Mysql variables: 1. DECLARE variable_name datatype (size) DEFAULT default_value; The declaration here is equivalent to a local variable and will expire after the end. DECLARE multiple: DECLARE x, y

Simple operations in MySQL Linux (Service Startup and shutdown, startup and shutdown, view Version) Today, the younger brother recorded the simple use of MySQL in the Linux system, as follows:Start and Stop a service. view the

How to modify the default encoding in MySQL Linux The younger brother recorded the modification of the default MySQL encoding here, and changed the default encoding to utf8. I hope this article will help you. Thank you! Environment: Linux: centeros 6