MySQL

Copy codeThe Code is as follows:Select * from table where DATE_FORMAT (FROM_UNIXTIME (createtime), '% Y-% m-% D') = '2017-01-02' FROM_UNIXTIME use syntaxFROM_UNIXTIME (unix_timestamp, format)FROM_UNIXTIME (unix_timestamp), FROM_UNIXTIME

The project requires you to find some information and configure it yourself.(1) master serverModify the configuration file/etc/my. cnf (my. ini)[Mysqld]# Mysql-bin is the prefix of the log file. You can also use other names, such as the server name.#

1. decompress the ZIP package and Configuration First, extract mysql-5.5.25-winx64.zip to the d:/mysql-5.5.25 directory, and then according to the relevant information on the Internet, the my-large.ini (of course, you can also select another ini

For some systems with a large data volume, the database faces problems in addition to the low query efficiency, but also the long data warehouse receiving time. Especially for the report system, the time spent on data import may be several hours or

You can briefly describe the actual situation of the apsaradb for Redis platform. 2200 + 500 billion commands/day 50 billion Read/day Write/day 18 TB + Memory 500 + Servers in 6 IDC 2000 + instances It should be a big Redis platform at home and

Original table student field: mysql> select column_name,data_type -> from information_schema.columns -> where table_name = 'student';+-------------+-----------+| column_name | data_type |+-------------+-----------+| stu_id | int ||

This is the second article in the series. In the first article, I used the built-in SSL support of MySQL for stress testing, which produced some surprising results. Of course, it is expected that the throughput performance of queries using SSL is

Original article: http://xm-king.iteye.com/blog/770721 Read Uncommitted (Read Uncommitted content) Read Committed (Read submitted content) Repeatable Read (repeable) Serializable (Serializable)This is the highest isolation level. It forces

Http://hi.baidu.com/luck001221/item/cb4462299f9ea79ab73263d2? Qq-pf-to = pcqq. group 1. Go to the mysql official website to download an odbc driver. Because MSsql has never been integrated with the mysql driver, this tool needs to be downloaded

Recently, I was suddenly very interested in MySQL connections. According to the thread keyword, I can find the following status: show global status Variable_name Value Threads_cached Threads_connected Threads_created

Original http://www.111cn.net/database/mysql/58651.htm In actual development, you may need to deploy multiple MYSQL instances on one server. We recommend that you use the MYSQL official solution mysqld_multi. 1. modify my. cnfFor example, a

1. Use the-r/-I ParameterYou can use the mysqladmin extended-status Command to obtain all MySQL performance indicators, that is, the output of show global status. However, most of these indicators are accumulative values. If you want to know the

Tool raw materials: Mysql-5.0.37-win32 Network Disk: http://pan.baidu.com/s/1bnjCfTlInstallation Process Run the installer. Next Step Select "Custom" for Custom installation. Next Step Here you can delete unnecessary installation, you can change

 Solution When mysql is running, temporary files are automatically generated in the temp folder under the windows folder on drive C. These files are not large, but the number of files is very large, there may be hundreds of thousands of files in a

Assume that there are host A and host B (Linux system). The IP address of host A is 1.2.3.4 (of course, it can also be dynamic), and the IP address of host B is 5.6.7.8. Both hosts are installed with PHP + Mysql. Now we are operating on the data on

How can I query the size of each table in the MySQL database? MySQL has a database named information_schema, which has a TABLES Table. The main fields of this table are: TABLE_SCHEMA: Database NameTABLE_NAME: Table NameENGINE: The storage ENGINE

1. For MyISAM tables, you can import a large amount of data quickly. Alter table tbl_name disable keys; loading the dataALTER TABLE tbl_name enable keys; These two commands enable or disable the update of non-unique indexes in the MyISAM table.

When the table is modified, Message 5074, level 16, state 1, 2nd rows The object 'df _ ddczjlb_m1_ddczj1_5bba8402 'depends on the column 'ddczjlb _ GROUPID '. Message 4922, level 16, status 9, 2nd rows Alter table alter column DDCZJLB_GROUPID

I. SQL SQL: Structured Query Language Structured Query Language SQL industrial standard: by ANSI (ISO (international standard orgnation) core member) SQL statements compiled according to industrial standards can run on any database. Dialect: the SQL

One of the most recent tasks is to use the MSSQLServer database service, To support MySQL databases, SQL statements involve some type conversion functions, The result shows that the MySQL type conversion function "CONVERT" does not provide good