MySQL

The common MySQL table engine has InnoDB and MyISAM, the main difference is that InnoDB is suitable for frequent write database operations, MyISAM suitable for reading the database a little bit more, how to change the table engine InnoDB to MyISAM?

LAMP installation ConfigurationConfiguring the EnvironmentOperating system: Redhat Enterprise as 4Packages installed: httpd2.0.4, mysql4.1,libxml2.6.16, zlib1.2.1.2,gd2.0.28, libpng1.2.7Description: The various installation instructions on the

Received a test today, the test environment front-end application of the MySQL database without connection, login to the MySQL server, view the error log, found that there are the following errors: ERROR 1135 (HY000): Can ' t create a new thread

apache|mysql| Security This article is written to friends who want to set up a secure web platform on the Win2K platform. The required program: Apache http://www.apache.org/dist/httpd/binaries/win32/ We choose Apache_1.3.28-win32-x86-no_src.msi, or

mysql| Security | access | server | data | database | Network MySQL security system is flexible. It allows you to set user access rights in many different ways. Typically, the grant and REVOKE statements are used to modify the authorization table

Table finance has two fields as follows Date Date Money Double (15,2) The 2010 financial data for the table finance is required below and is counted monthly SQL code Select Date_format (date, '%y-%m ') as Month,sum (money) as the finance

I. MySQL Sub-database sub-table scheme 1. Why divide the table:When the data of a table reaches tens of millions of, the time you spend querying is much more, and if you have a joint query, I think I might die there. The purpose of the sub-table is

Create full-text index (fulltext index)Create a full-text index while creating a tableFulltext (name) with PARSER NgramTo add by ALTER TABLEALTER TABLE ' Das '. ' staff_base ' Add fulltext index staff_base_name (' name ') with parser Ngram;Direct

1. Full backup and incremental backup 1.1 full-scale backupFull-volume data is all the data in the database, and a full backup is the backup of all the data in the database.Back Up all libraries:mysqldump -uroot -p123456 -S /data/3306/mysql.sock -F -

I. Annual ENQUIRY Enquiry data for the yearSELECT * fromblog_articleWHERE Year(From_unixtime (Blogcreatetime))= Year(Curdate ()) Second, query quarterly data query data with quarter numberSELECTArticleID, Quarter (from_unixtime (' Blogcreatetime ')

Build a Web server development environment for Apache, PHP, and MySQL on Mac OS x.Tools/Materials Mac OS X 10.10 Homebrew Software Method/Step 1. How do I turn on Apache server?There are two ways to open a Web server:One is:

MYSQL source code compilation principle AST and parse tree code syntax parsinghttp://blog.csdn.net/wfp458113181wfp/article/details/17082355using the AST treeCategory: ANTLR 2013-12-02 22:39 255 people read Comments (0) favorite reports Directory (?)

Query Day:Select * from Table where = To_days (now ()); Select * from Table where =Query one week:Select * from Table where 7 Day Date (column_time);Query one months:Select * from Table where 1 MONTH Date (column_time);MySQL date and time

Using JDBC to connect MySQL in PowerBuilderError encountered:Long Ll_count//Profile Mysqlsqlca.dbms = "JDBC" SQLCA. Logpass = "123" SQLCA. Logid = "root" SQLCA. autocommit = Falsesqlca.dbparm = "driver= ' com.mysql.jdbc.Driver ', url= ' jdbc:mysql://

Excel connects to MySQLEven today we have powerful reporting tools like Microsoft Crystal Reports and other flexible customer management applications, and Microsoft Excel is still the most commonly used tool when analyzing sales statistics and

There are two ways to define variables in a MySQL stored procedure:1. Use set or select to assign a value directly, and the variable name begins with @.For example: Set @var = 1;You can declare anywhere in a session that the scope is the entire

MySQL itself provides command line export tool mysqldump and MySQL source Import command for SQL data import and export work, through the MySQL command line export tool mysqldump command to export MySQL data into text Format (TXT) SQL file, The

We all know that the usual PHP connection MySQL is connected by the root username and password, by default, when the MySQL installation of the root initial password is empty, when installing the use of PHP open source system, you need to fill in the

  Mysql database is an essential combination for PHP website development. Generally, PHP connects to Mysql through the root user name and password. The initial root password is blank during Mysql installation, when installing and using the PHP

MySQL database functions are frequently used in actual operations. Therefore, it is best to have a certain understanding of MySQL database functions. I found this article very well on a website, I have made a special offer for you to share with you