The following is an explanation of the configuration of the PHP operating environment in WAMP Environment:
First, preparation-download the required software
Apache Httpd-2.2.22-win32-x86-openssl-0.9.8t.msiPHP Php-5.2.17-win32-vc6-x86.zipMySQL
Method one SQL script form
Action steps are as follows:2.1. Export SQL ScriptOn the original database server, you can export the SQL script using the phpMyAdmin tool, or the mysqldump command line (mysqldump command in the mysql/bin/directory).2.1.1
Scene: Need to do a fuzzy query about the title, only a little more records, and need to be relatively accurate, such as search: AC, can not appear ABC, acceptable ACB,BAC, and so on.
MySQL Full-text search has three different modes:
One, natural
Statement
The code is as follows
Copy Code
Show grants for your users
Like what:
The code is as follows
Copy Code
Show grants for root@ ' localhost ';
View user rights.
Assume that the Perl language and MySQL database are installed.
DBI Installation: DBI Detailed information reference: http://dbi.perl.org/1. Download DBI Package:
wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.620.tar.gz
2
Do not use long when you can use short columns of data. If you have a fixed-length char data column, do not allow it to be longer than you really need. If you store the longest value in a data column with 40 characters, do not define char (255), but
The first day of the quarter, and then you can convert the string to a date. There are many methods, including aliases (synonyms) for the same function. such as Curdate (), Current_date (), current_date, now, etc. can return to the same day
MySQL
Environment description
Linux:rhel 5.3nginx:nginx-1.6.2python:2.7.9django:1.6.7uwsgi:2.0.10
Note that the necessary development kits and Libxml2,python-devel,pcre-devel,mysql-devel for compiling the environment must be installed beforehand
2.
100W of data for many friends, but today I thought of creating a large number of data test environment, so I looked for how to insert 100W data, I used 20 fields. In contrast, the first is to use the MySQL stored procedures to get:
The
Login to the MySQL system:
code is as follows
copy code
# mysql-uroot-p Enter Password: " Enter the original password Mysql> use MySQL; mysql> Update user set Password=password ("test")
Click the "SQL" tab on the top to enter the SQL command input interface. Enter the following command:Update mysql. user set password = PASSWORD ('snsgou $123456 ') where user = 'root ';Note: If you have changed the root password, you also need to
1 problem description:The following is a graph of the number of threads after the application goes online: Observe the number of threads: increase from 0.2k to 1.4 k, and then suddenly change to 0.2 k. All the added threads are Damon threads.Have
Integration with MySQL in PHPIntegration with MySQL in flash and PHPBy Ben Smith, a. k. a Ω mega: May 12, 2005This tutorial teaches you how to integrate flash, PHP, and MySQL. We will learn how to parse text into HTML text from external script files.
Learn to use phpMyAdmin, a Web-based database management tool.If appropriate tools are used, MySQL database management will be quite simple. To use the MySQL command line method, you must be familiar with MySQL knowledge and use the same SQL
By default, log files are enabled for MySQL/MariaDB installed in the one-click LNMP installation package. If data operations are frequent, a large number of logs are generated, generate a mysql-bin.0000 * similar file
Php Tutorial pseudo-static and php mysql tutorial apache configuration detailsConfiguration process:(1) http. conf Run php directly as a module of apache. I added two sentences to it:Loadmodule php5_module "e:/php/php5apache2. dll"Addtype
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