MySQL

Original: MySQL basic to library table operationslook at all the libraries , What do I do ?Mysql>show databases;Select a library statement : Use library nameCreate a database : Create database name [CharSet Character set ]Delete a database : drop

#!/bin/bash#sql file will be stored in the path basepath_sql= '/home/work/local/cms_sql_bak ' #/home/work/local/cms_sql_baksavepath_sql=$ basepath_sql/$ (date +%y)/$ (date +%m) #创建目录mkdir-pv $savepath _sql/mysql_bin= '/home/work/.jumbo/bin ' $mysql _

1. Download the interface package Mysql-connector-java-5.0.8-bin.jar2. Programming(1) Load driver(2) Programming connection operation(3) Return result processingProgramming examplesImport java.sql.*;p ublic class Access2database{public Connection

Table A records the following:AID Anum1 a200501112 a200501123 a200501134 a200501145 a20050115Table B records the following:BID bname1 20060324012 20060324023 20060324034 20060324048 2006032408Create these two table SQL statements as follows:CREATE

In addition to the usual two table joins, the SQL (MySQL) JOIN syntax also supports multiple table joins. The basic syntax for multiple table joins is as follows: 1

#!/bin/bash# Analysis of the MySQL slow log# Writen by Landline#IPadd = ' grep ' hostname '/etc/hosts | Awk-f ' End{print $ 'Ipadd= '/sbin/ifconfig eth0 |grep bcast |awk-f: ' {print $ {} ' |awk ' {print '} 'Serverday= ' date-d '-1 day ' +%y-%m-%d

BLOB (Binary large object), binary large, is a container that can store binary files.can be used to store information such as picturesDemo1: Storing pictures1String sql= "INSERT into Testblob (NAME,HEADIMAGFE) VALUES

Original: MySQL finds field names by field annotationsSometimes the table is too many fields, just roughly remember the table comments, want to find the field name through the field comments, you can use the following statement:SELECT

Original: MySQL Advanced cursorsWhat is a cursor? The SELECT statement may fetch an n statement at a time, so the cursor can take out a record in the select one of these. Every time you take out one, move it down! Can implement very complex

1. No suitable driver found for http://127.0.0.1:3306/testJdbc_url error, JDBC walks its own protocol.The correct path should be:jdbc:mysql://127.0.0.1:3306/test.2. mysql in database, instance, session.MySQL establishes a session, not with a

Original: MySQL Advanced master-slave replicationMaster-slave replication is not more than a server! , one change, the other changes, the content is actually the same!Principle:Operation on the database will generate a file, Binlog (binary file),

Original: MySQL insert content is too long (Packet for query is too large)This has not been encountered before, one-time to the MySQL database insert content too long, the solution is to find the [mysqld] option in MySQL configuration file

Original: Basic data type of MySQL FoundationColumn type LearningMySQL three major column typesIntegral typeTinyint/smallint/mediumint/int/bigint (M) unsigned ZerofillString Type  Char (M)Varchar (M)Text literal typeDate Time TypeDate

Original: MySQL Advanced indexIndex : is the directory created for the data .function : can speed up the queryNegative effect : reduce the speed of adding and deleting .Principles of Index creation :1: do not over-index2: Add on the column with

Linux backs up mysql Data every day and linux backs up mysql Preface: If your database file is large, it may occupy a lot of server resources during backup, so the webmaster should try to select the minimum period of time for the visitor to

Install ubuntu-14.04 in mysql-5.6.21 system, ubuntu14.04mysql1. Preparations before installing mysql(1)、download mysql-5.6.21.tar.gz from the official network(2), tar-zxvf mysql-5.6.21-tar.gz will generate a folder for the mysql-5.6.21(3)download

Mysql DATA export Permissions There are many ways to export mysql data, such as mysqldump, mysql-e 'SQL'> file, which can easily export data. However, when using a common user to export data, an error occurred. 1 Select * into outfile

Ubuntu ° ² × ° MySQLComment» ~~añéö~ózomö~» úço ~añe° ² × ° MySQL £°Õ â ï ö÷ ª Ç suð Ð sudo netstat-tap | grep mysql à ü Á î ² é ¿'Ç çañorð MySQL µä¶ Ë ~ú£;%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% $ netstat -tap | grep mysql

Mysql searches for field names through field annotations Sometimes there are too many fields in the table, just remember the table comment. To search for the field name through the field comment, you can use the following statement: SELECT

Mysql delete operation (delete + TRUNCATE), mysqltruncate Delete Syntax Single Table Syntax: DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name[WHERE where_definition][Order by...][LIMIT row_count] multi-Table Syntax: DELETE [LOW_PRIORITY] [QUICK]