MySQL

Click here to go to the original page1. What is the storage engine?Data in MySQL is stored in files (or memory) in a variety of different technologies. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels,

Provenance http://blog.sina.com.cn/s/blog_46f224ea010008zp.html Numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available

For MySQL data fragmentation, in fact, and we delete the data is closely related to the deletion of data when the data file will inevitably create a discontinuous blank space, for a small amount of data deletion, and will not produce much white

Lab Environment:1.VMware2. Two Linux sub-computers3. Bridging, native when the clientExperimental Purpose:1. Compiling httpd and compiling PHP, compiling MySQL, familiar with the compiling process and principle2.HTTPD and PHP on the same server, PHP

Both the backup and restore databases are command-only operations without logging in:1. Backup table:Mysqldump-u root-p dbname table1 table2 > D:\sqlback.sql2. Back up one or more databases:Mysqldump-u root-p--databases dbname1 dbname2 >

#!/bin/sh#[email protected]Export black= ' \033[0m 'Export boldblack= ' \033[1;0m 'Export red= ' \033[31m 'Export boldred= ' \033[1;31m 'Export green= ' \033[32m 'Export boldgreen= ' \033[1;32m 'Export yellow= ' \033[33m 'Export boldyellow= ' \033[1;

private void Datatabletoexcel (System.Data.DataTable tmpdatatable, String strFileName){if (tmpdatatable = = null){Return}int rowNum = tmpdatatable.rows.count;//Lineint columnnum = tmpdatatable.columns.count;//columnint rowIndex = 1;//Lineint

Trigger statements exported in multiple sql: DROP TRIGGER IF EXISTS ' t_trig ';D elimiter//create TRIGGER ' T_trig ' before INSERT on ' t_goods ' for each RO W Beginset new.add_date = current_date (); INSERT into test2 SET a2 = new.id;end//delimiter;

Uninstall the previous Apache1, Control Panel first Uninstall2. Delete the Apache directory under E:\Program Files (x86) \apache Software FoundationFirst, install Apache1, custom personalized installation → Change the path to E:\Program Files (x86) \

Recently OJ and related open station abnormal slow, simply collapsed, has not found the reason!Go to the database server, go to MySQL, check it with show processlist command, find a lot of unauthenticated userGoogle a bit,Found that this is a MySQL

CMake installing MySQL 5.6.12Starting with MySQL 5.5, you'll compile the installation with CMake.Download MySQL: Http://pan.baidu.com/s/1o68xxqEFirst, install the mysql5.6.121. Create users, groups, and directories-G MySQL MySQLCreate a Data

StatementThe Stars last nightBlog:http://yestreenstars.blog.51cto.com/This article by oneself creation, if need reprint, please indicate source, thank cooperation!ObjectiveOne-click Automation to install MySQL server.EnvironmentOs:centos 6.2 32mysql:

One: ( stop running MySQL) [[email protected] ~]# service mysql stop Second: Restart MySQL with the "--skip-grant-tables" parameter [email protected] ~]# mysqld_safe--skip-grant-tables & [1] 23810starting mysqld daemon with databases From/var/lib/

Version: MariaDB 10 Environment: D disk, put 2 MariaDB decompression version, respectively d:\MariaDB,d:\mariadba 1, enter MariaDB,mariadba, copy my-xxx.ini(different files corresponding to different hardware configuration), renamed to My.ini 2

Because some record rows have been deleted, the self-increment field is not contiguous, and the Reflow or zeroing method is:Method 1:TRUNCATE TABLE nameThis will not only reposition the field of the increment, but also the table data are all deleted,

Knowledge key words: Date_format select Date_format (create_time, '%y%u ') weeks,count (Caseid) count from Tc_case Group by weeks;  Select Date_format (create_time, '%y%m%d ') days,count (Caseid) count from Tc_case Group by days; Select Date_format (

One, download the installation of the necessary dependency package1, because the high version of MySQL is installed with cmake, so download cmakewget http://www.cmake.org/files/v3.0/cmake-3.0.1.tar.gzTar zxvf cmake-3.0.1.tar.gzCD

1, Linux under the installation of MySQL is the default: distinguish the case of the table name, do not distinguish between the case of the column name;2, with the root account login, in the/ETC/MY.CNF [mysqld] After adding add

Lost connection to MySQL server at 'reading authorization packet ', system error: 0, mysqlconnection 1. Enter Mysqld If the Mysql/Bin environment variable has been set, enter the command directly in CMD. If the Mysql environment variable is not set,

Modify multiple data entries using mysqlupdateGenerally, the following SQL statement is used to update the field value:Copy codeThe Code is as follows:UPDATE mytable SET myfield = 'value' WHERE other_field = 'other _ value ';However, what if you