MySQL Import a large database tutorial file method
File Size 800MB
Method One
The above document generally means that, when you encounter a large import file, first check the PHP tutorial. ini configuration file in the following three places,
Here is an example of using a date function. The following query selects all records and its date_col value is within the last 30 days:
Mysql> SELECT something from table
WHERE To_days (now ())-To_days (Date_col)
DayOfWeek (date)
Returns the week
First, the acquisition of software
1.php first go to http://www.php.net/downloads.php to download the latest PHP 5.2.0 version.
2.MySQL can be downloaded to the latest 5.0.xx version in
MySQL sometimes forgets the root password is a sad thing. This provides a password reset method under Windows and Linux.
Windows:
1. Log in as a system administrator.
2. Open cmd-----net start to see if MySQL starts. Stop the net stop MySQL when
0. Notes
Of course, MySQL is installed in a variety of ways, in Ubuntu, you can use the Apt-get way to install, the advantage is: fast and convenient. Basically, it will help you solve all the function library dependencies, normally, as long as apt-
System version: Ubuntu 12.04 64-bit
Install (the version used for the test is mysql-server-5.5):
Apt-get Install Mysql-server
Start and stop, etc.:
/etc/init.d/mysql start
/etc/init.d/mysql restart
/etc/init.d/mysql stop
Local connection:
When MySQL is replicating across the internet, others can steal information about MySQL's replication, which is plaintext, so there is no security, where the replicated information is encrypted via SSL. When the client does not have a fixed IP to
Introduction to the relevant concepts of MySQLMySQL for relational databases (relational database Management System), this so-called "relational" can be understood as the concept of "table", a relational database consists of one or several tables,
Periodic analysis Table
ANALYZE [Local | No_write_to_binlog] TABLE tbl_name [, Tbl_name]
Use this statement to parse and store the keyword distribution for a table. During profiling, a table is locked with a read lock. This is useful for MyISAM,
3.3.5 Create or delete the database directly in the database directory, just create a directory with the same name as the database under the MySQL data directory, and delete the database by deleting the directory. So, you can do this directly,
The following article is mainly to describe what is the role of delimiter in MySQL database? We generally think that this command is not related to stored procedures, is this the case? The following articles will give you the relevant knowledge,
Explanation of length value problem for MySQL int typeChase _something My friend seaside ask me MySQL what is the length of int type when building a table? Is this column allowed to store the maximum width of a value? Why I set it to int (1), also
Overview for databases such as MySQL and Infobright, the tables in the INFORMATION_SCHEMA database are read-only and cannot be updated, deleted, inserted, or triggered because they are actually just a view, not a base table, and have no associated
DAY17 Summary Today's content L JDBC1.1 Summary of last lessonSQL statements: 1. FOREIGN KEY constraint: foreign key * Maintain multiple table relationships! * To ensure data integrity! 2. Three types of relationships: * One-to-many: * One customer
XWiki is an open source wiki system written in the Java languageXWiki has a variety of versions, standalone version can be downloaded directly after the standalone installation, the default integration of Jetty run, but this way to install XWiki,
Mysql performance optimization solution sharing and mysql performance optimization sharing
There are many mysql performance optimization solutions on the Internet. However, mysql optimization is more troublesome than SQL server. In the same settings,
Understanding MySQL stored procedures and functions, mysql stored procedure functions
I. Overview
When it comes to stored procedures, the advantages and disadvantages of stored procedures may be introduced. We will not discuss them here. If someone
Basic tutorial on using table alias and field alias in MySQL,
MySQL table Alias (Alias)SQL table aliasIn an SQL statement, you can specify an Alias (Alias) for the table name and field (column) name. The Alias is a standard SQL syntax and is
MySql database Stored Procedure Learning
I used to hear from others about the stored procedure at work. I thought it was a very advanced thing. I used my spare time to read the relevant knowledge. Now I will summarize my learning knowledge as
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service