Connecting to a database$link = mysql_connect (' localhost ', ' root ', ') ' or Die (mysql_error ());mysql_select_db (' class ', $link) or Die (Mysql_error ());mysql_query ("Set names GBK");Infinite Classification Class Library
The code
Setting up MYSQL Data synchronization
MySQL provides database replication functionality after version 3.23.15. The function of two database synchronization, master-slave mode and mutual backup mode can be realized by this feature.
The settings for
I have been using the MySQL tutorial this database tutorial software, it works relatively stable, efficient and very high. In the face of serious performance problems, there are generally several possibilities:
1, the index is not well established;2
Whether because MySQL is too big, back and forth backup waste resource bandwidth and worry, if you want to solve this problem requires incremental backup, the following is the Zhangxiao resource Network modified a MySQL incremental backup script, I
We offer free web space, free hosting, and paid hosting for all of your needs with your own domain name or child. We support PHP, Perl, and MySQL. Join the 122mb.com free web space community
Free online space
Disk storage: 200
Monthly
U.S. servers2G Space Capacity10G Flow limit per monthPHP space, support PHP5, CGISupport FTP, Web upload management files, but file type and file size limitCan create 3 MySQL databasesProvides 1 free level two domain nameCan bind one's own domain
Have you ever thought about starting using your own web page for personal or commercial use.
Please try our service and start a hobby website or profit all these are free.
Upgrade to high-capacity packages as the business grows.
Click on one of
Cases
The code is as follows
Copy Code
SELECT cat. ' Name ', class. ' Title 'From ' Cat ', ' class 'WHERE cat. ' id ' = class. ' Cat 'and cat. ' ID ' =2LIMIT 0, 30DELETE cat, class from Cat, Class WHERE cat. ' ID '
Full-standby batch processing under win
Batch processing is used for game servers, rigorously tested and formally used, and is used primarily to fully back up the database, of course. It's just a few backups.
, the function of FTP can be invoked
Encountered some errors in the project process that occurred because of a database version reason
MySQL server Upgrade Data restore table structure cannot be displayed
After the MySQL server upgrade, after the database data is restored, the DESC
Using commands is a commonly used mysqldump to operate (mysqldump commands are located in the mysql/bin/directory)
The Mysqldump tool has a number of options, some of which are listed below:
Option/option action/action performed
--add-drop-table
My most common method is
The code is as follows
Copy Code
Delete ID duplicate data, suitable for ID is manual primary keyDelete Person as a from as a,(Select *,min (ID) from person GROUP by ID having count (1) > 1) as
A MySQL tutorial exists The record is updated, and the SQL that is inserted into the record does not exist
INSERT table (auto_id, Auto_name) VALUES (1, ' yourname ') on DUPLICATE KEY UPDATE auto_name= ' yourname '
Using on DUPLICATE KEY updateIf
Apache/php/mysql Server Installation Kit SummaryJanuary 30, 2005 23:58 SundayFor developers who are already familiar with Apache+php+mysql installation configurations, or those who do not want to involve development but just want to build PHP
I suddenly find that the MySQL tutorial will produce different results for the different processing of count (*)
such as executionSelect COUNT (*) from TableNameMySQL can return results very quickly even for tens other data.And forSelect COUNT (*)
Ucoz provides m free website space with powerful CMSThe free second-level domain name suffixes offered by them include ucoz.com, ucoz.net, ucoz.org, ucoz.ru, ucoz.de, and ucoz. ua, ucoz. co. uk, ucoz. kz, ucoz. lv,. ua, 3dn.ru, my1.ru, clan. su, moy.
The Role function can be said to be an expected feature, which can be seen from its Worklog number (WL #988). This is an early and demanding requirement.The so-called Role can be considered as a set of permissions. This set has a unified name, that
Backup policyFor different scenarios, we should develop different backup policies to back up databases. Generally, there are three backup policies:Copy database files directly using cp and tarCopy bin logs using mysqldumpLvm2 snapshot copy BIN
I. OverviewProject requirements: Today, the server running environment is installed and configured on the virtual machine based on Centos. The web service uses nginx, the database is stored in mysql (using MariaDB), and the dynamic scripting
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