MySQL

MySQL string intercept1. Intercept string from leftLeft (str,length) truncated field, intercept lengthSelect Left (' admin1213 ', 5) from table2, starting from the right to intercept the stringRight (str,length) truncated field, intercept

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/75/55/wKiom1Y20huyVfqoAAFx8Sg-tSU187.jpg "style=" float: none; "Title=" PSB (1) _ Copy. png "alt=" wkiom1y20huyvfqoaafx8sg-tsu187.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02

80 mid-year marriage four pieces: watches, bicycles, sewing machine, radio (three Turn One Ring). It takes four things to get a business home, so the business is mean (ACID), four-piece list: atomicity ( Atom), consistency (Consistent), Isolation

Modified via MySQL command line:Set Character_set_client=utf8;Set Character_set_connection=utf8; Set Character_set_database=utf8;Set Character_set_results=utf8;Set Character_set_server=utf8;Set Character_set_system=utf8;Set Collation_connection=utf8

1, calculate the distance formula is long (on-line search), build a MySQL function: Delimiter $ $CREATE FUNCTION fun_jw_dist (lng1 double (15,9), LAT1 double (9), Lng2 double (15,9), Lat2 double (15,9)) RETURNS double (15,9) BEGIN DECLARE Dist

mysql recursive query,MySQL from the subclass ID query all the parent class (do unlimited classification often used)Because MySQL does not support recursive query syntax similar to Oracle with ... connectIt was thought that a similar query would

Objective The book reads times, its righteousness is self-existing. We all know, but now the society is really impetuous, and how many people can calm down to see the book?! As long as a problem is Baidu, Google ... In fact, the book is very

2015-10-25DirectoryResources[1] Tang Hanming. mysql database development, optimization and Management Maintenance (2nd edition) [M]. Beijing: People's post and Telecommunications press, 2014[2] Schwartz. High-Performance MySQL (3rd edition) [M].

2015-10-24DirectoryResources[1] Tang Hanming. mysql database development, optimization and Management Maintenance (2nd edition) [M]. Beijing: People's post and Telecommunications press, 2014[2] Schwartz. High-Performance MySQL (3rd edition) [M].

2015-10-24DirectoryResources[1] Tang Hanming. mysql database development, optimization and Management Maintenance (2nd edition) [M]. Beijing: People's post and Telecommunications press, 2014[2] Schwartz. High-Performance MySQL (3rd edition) [M].

1, set up the table user and insert data (at this time the database is users, the user name is root, the password is 123456)Create Table User varchar( varchar); Insert into User Values ('tufujie','123456');2. Writing Java files//demonstrates how

Installing the MySQL databaseAs we all know, the data is very important, once the data is lost, can not explain to the company, you may not be able to go down, so select the database must choose the public, we all use.Communication found that most

A SQL language that is compiled beforehand and stored in a database.First, create a functionTo create a format:CREATE FUNCTION sp_name ([func_parameter[,...])RETURNS type[Characteristic ...] Routine_bodyFunc_parameter:Param_name typeSummary: The

A small script that makes logical backups with mysqldumpFor small data volume backup, whole library, by date, by library, by table, classification# date-s "2015/01/01" && bash mybackup.sh#！ /bin/bash# using mysqldump for logical backup # directory

In the MySQL database, if you do not specify the innodb_file_per_table parameter to separate the data for each table, the MySQL data will be stored in the Ibdata1 file.MySQL ibdata1 storage data, indexes, etc., is the most important data source of

Introduction to DatabasesI am not a technical manual, not for preaching, just a little bit of personal opinion, idle to chat.Do know, the Web server parallel plus 10 units is very easy, but the database parallel plus 10 is difficult, even if added

Tags: mysql database/dba/Delete database tablesOverviewBecause there are some things, from the publication of an article to the middle of the current interval of several months, in the following time will be published on some of the MySQL articles,

--Query MySQL database link idle time hold maximum idle time in secondsSHOW VARIABLES WHERE variable_name = ' interactive_timeout ';--The wait_timeout is similar to the parameter, and when modified, it is modified together.SHOW VARIABLES WHERE

Problem: The columns in the MySQL table can define the bit width that it displays, so does the definition of bit width affect the range of data values?Test:1. Define a table for testingCREATE table t (x int,y int (2), Z int (2) zerofill);2. Insert

Smaller is usually better It's simple. Try to avoid null One, integer typeThere are two types of numbers: integers and real numbers. If you store integers, you can use these kinds of integer types: tinyint,smallint,dediumint,int,bigint.