MySQL

MySQL connector:http://dev.mysql.com/downloads/connector/odbc/5.1.htmlFirst the machine will install the MYSQL-CONNECTOR-ODBC plugin, which will enable Viso to recognize the ODBC driver for MySQL, 1. Open VisoSelect "Software and Database" and

Straight to the point, releasing first:1, http://blog.jjonline.cn/soft/J_Position/ajing.sql.gzphpMyAdmin compressed exported MySQL library, library name: Ajing, there are 6 tables, a table without suffix is the original data, each row is a village,

Today found Navicat for MySQL has a Linux version of Ha, happily speaking,First Officer online download Linux version: Http://www.navicat.com/download 1. Download the navicat110_mysql_en.tar.gz file2. Unzip the tar file after

Early in the morning I heard the system hangs, check the tomcat, found that Tomcat himself broke, my Tomcat always after a period of time automatically turn off, here is not discussing the problem of Tomcat, normally, after restarting Tomcat, the

Workaround:Method OneWith phpMyAdmin, this is the simplest, modify the user table of the MySQL library, but don't forget to use the password function. Method TwoUsing Mysqladmin, this is a special case of the preceding declaration. Mysqladmin-u

The storage engine is a table-level concept, and each table created should indicate its storage engine, and it is not recommended to cross-use the same storage engine for the same database.InnoDB: The enhanced version is XTRADB,MARIADB, which uses

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. When doing statistical functions, try to avoid querying database tables in real

MySQL Modify table structureThe following table names test5 only one field hobby operationModify Table NameALTER TABLE TEST5 rename Newtest;Change the name of a field at the same timeStatement structure ALTER TABLE name change field name new field

1, Windows do CSV file by default is the GBK character set, and MySQL set the default is the UTF8 character set, so to convert the file to UTF8 format.Iconv-f gbk-t utf8/tmp/file name. csv-o/tmp/file name 2.csv2. Import with SQL commandLoad data

The variables in SQL Server are first declared and then assigned:Local variables with an @ identifier, global variables with two @ (common global variables are generally defined);Declare local variable syntax: DECLARE @ variable name data type; For

Hibernate entity classWhen table name annotations are capitalized, MySQL auto-generated tables under windows are lowercase (case-insensitive), and MySQL automatically generates case-sensitive under Linux. Cause a database problem.Cause (MySQL is not

to better understand the connection type (type), the connection type is simply summed up according to the different query criteria. The table is defined as follows:1.id PRIMARY Keymysql> show create table key_id;+--------+----------------------------

Simply draw a diagram:first, the server planning192.168.116.132 (Master)--write operations192.168.116.129 (SLAVE1)--read Operation192.168.116.131 (SLAVE2)--read Operation192.168.116.130 (Haproxy)--AgentMySQL master-slave replication configuration

Recently wrote a program, real-time read Rsyslog log, but encountered a problem: MySQL insertion speed delay, very slow, so began to troubleshoot;1. Analysis procedures, will be considered more time-consuming place for threading analysis, invalid;2.

1. Querying all records and querying non-duplicate recordsSyntax:SELECT [All | DISTINCT]All: return all records Distinct: return non-repeating records valid for fields within the obtained record.  2. Case:(1) Look at the figure below, we found that

Package com.wangbingan.jdbc;import java.sql.connection;import java.sql.drivermanager;import  java.sql.ResultSet;import java.sql.Statement;public class JdbcUtil {public  Static void main (string args[])  throws exception {connection conn =  null;// 

Original address: http://koda.iteye.com/blog/682547MySQL's master-slave synchronization mechanism is very convenient to solve the high concurrent read application requirements, the development of the web has brought great convenience. However, there

Shell scripting + MySQL database for enterprise-level session Border controller file parsing and alertingdirsx30001.sh process files, generate MySQL backup files in a way to import#/bin/bash# #环境变量path =/home/sbclog/sx30001# #由于抓取的日志文件中没有年份参数,

In MySQL, the basic form of creating stored procedures is as follows: CREATE PROCEDURE sp_name ([proc_parameter[,...]]) [Characteristic ...] Routine_body Where the Sp_name parameter is the name of the stored procedure,

Today select * FROM table name where To_days (Time field name) = To_days (now ()); Yesterday select * from table name where To_days (now ())-To_days (Time field name) < = 17 days SELECT * FROM table name where Date_sub (Curdate (), INTERVAL 7 day)