Database backup Classes
How to use:
The code is as follows
Copy Code
Require_once ("backdata.class.php");$link = @mysql_connect ("localhost", "Database name", "password") or Die (' could not connect to server.
Download First
Download Phpexcel file, address: phpexcel.codeplex.com/
Find the following similar code in the reader.php file (the first line is both) and change to the correct oleread.php path: require_once ' oleread.php ';
Then create a new PHP
Save the following code as phpinfo.php:
Phpinfo ();?>
Mysql-------MySQL Support EnabledActive Persistent Links 1Active Links 1Client API version 5.0.37-------If you do not see it and you are sure that the database is installed, you may need to
The installation process is as follows:
First you can see that this is the mysql5.0 installation interface, select next to always install to the 2nd Step diagram display interface.
Step2
Next to here, is to choose the installation method. Look at
Here are one by one explanations:
1. Left intercept (str, length)
Left (str, length)
Description: Left (intercepted field, intercept length)
The code is as follows
Copy Code
Mysql> Select Left (' 111cn.net ', 3);+-----
Building a table: the process of declaring a column
The code is as follows
Copy Code
CREATE TABLE Table name (Column name 1 column 2 Type column 1 parameter,Column Name 2 column 2 Type column 2
Specific operations
MySQL supports the join syntax for select and some update and delete cases, with specific grammatical details:Table_references:Table_reference [, Table_reference] ...Table_reference:Table_factor| Join_tableTable_factor:Tbl_name [
Inquire
Today
The code is as follows
Copy Code
SELECT * FROM table name where To_days (Time field name) = To_days (now ());
Yesterday
The code is as follows
Copy Code
SELECT * FROM
Format: Grant Select on database. * To User name @ login host identified by "password"
Example 1, add a user test1 password for ABC, so that he can log on any host, and all databases have query, insert, modify, and delete permissions. First connect
1. Introduction to Group by statement:The GROUP BY statement is understood in the literal sense of the English language as grouping (group) according to certain rules. Its role is to divide a dataset into small areas through certain rules, and then
InnoDB and MyISAM are the two most commonly used table types used by many people when using MySQL, each with its own pros and cons, depending on the specific application. The basic difference is that the MyISAM type does not support advanced
At the same time, the amount of online access continues to increase for 1G memory server Obviously feel the difficulty of severe when even every day will panic or occasional server card This problem once bothered me for more than half a month MySQL
Apache
The code is as follows
Copy Code
Sudo/etc/init.d/apache2 start starts ApacheSudo/etc/init.d/apache2 Restart Restart ApacheSudo/etc/init.d/apache2 Stop Apache stopped
Mysql
The code is as
XML is used as the data exchange standard. Both Java and. NET support XML, but developers on other platforms do not have to worry about being abandoned by this technology. PHP is a popular script environment that supports XML. In this article, I
You can add, delete, modify, and query a simple blog implemented by php + mysql. The effect is shown in the following figure:I. Database and table structureDatabase: testTable: micro_blog (only one table) field: id, title, date, content, hitsThe
We will use the SimpleXMLElement function to operate xml files in php. Let's take a look at the usage of SimpleXMLElement.The SimpleXML function allows you to convert XML into objects.This object can be processed by using a common attribute selector
◆ The default encoding of the mysql database tutorial is utf8. If this encoding is inconsistent with your php webpage, it may cause mysql garbled characters;◆ When creating a table in mysql, you will be asked to select an encoding. If this encoding
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