Apply for 500M free website spaceWeb space: 500MIIS: UnlimitedFlow: UnlimitedSpace function: Chinese independent Control PanelScripting support: HTML, ASP, PHP, asp.netFree support: Dynamic, Joek, New Yun, Empire and other componentsOperating system:
Your page is completely FREE!
Now, you can have your own cyberspace in a quick and easy way. Your Web page will be available to millions of internet users in a few minutes.
The function of the network space:
We give each network space 100.00 MB.
The correct statement to change the table character set is:ALTER TABLE XXX convert to character set UTF8;Rather than take for granted:ALTER TABLE XXX default CharSet UTF8;
The character set is converted from GBK to UTF8,Increases the space occupied
How MySQL starts and stops on Windows, Linux
First, Windows Start and stop
[1.]mysqld-nt is appropriate when Windows services are not installed
• Start by switching to Mysqlbin under CMD, enter start mysqld• Stop switching under CMD to Mysqlbin
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 '
Description
These days tried to use a different storage engine to insert a large number of MySQL table data, the main test MyISAM storage engine and InnoDB. The following is an experimental process:
Realize:One, InnoDB storage engine.Creating
Use phpMyAdmin to change the root password
Use phpMyAdmin to change the MySQL root password is very convenient, installation configuration good phpmyadmin, first login admin interface, click on the right to modify the password link, enter you want
Master-Slave configuration We need to have two MySQL servers, we have to clear two points
1, the MySQL configuration file my.cnf location
2, how to start, stop MySQL, find a good startup file
Assuming that there are two machines, MySQL has been
The following error occurred while starting MySQL:
[Root@www ~]#/usr/local/webserver/mysql/bin/mysqladmin-u root-p 12345678Enter Password:/usr/local/webserver/mysql/bin/mysqladmin:connect to server at ' localhost ' failedError: ' Can ' t connect to
Warning:mysql_connect () [Function.mysql-connect]: Can ' t connect to the local MySQL server through socket '/var/lib/mysql/mys Ql.sock ' (2) in/home/content/63/8523763/html/deng/fqlbnet/admin/inc/db.php on line 34Can ' t connect to the local MySQL
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
MySQL Tutorial database tutorial backup and MySQL Restore method
1, mysqldump1.1 BackupMysqldump is a SQL-level backup mechanism that guides data tables into SQL script files and is relatively appropriate for upgrades between different versions of
now lamp (Linux, Apache, MySQL, Php/perl/python abbreviation) is already very popular. There are similar things under Windows, such as WAMP (Apache, MySQL, PHP on Windows). This article mainly describes how to completely manually configure Apache,
Some chat versions of emoji are commonly used in office-based communication software, and it is found that they cannot be stored in mysql.Because the four bytes (\ xF0 \ x9F \ x90 \ xAC) of the emoji during storage );Because the database uses the
MYSQL enable log[Root @ jianshe99] # whereis my. ini[Root @ jianshe99] # vi/etc/my. cnf[Mysqld]Datadir =/var/lib/mysqlSocket =/var/lib/mysql. sockUser = mysql# Default to using old password format for compatibility with mysql 3.x# Clients (those
MySQL parallel replication is already a commonplace. I started to deal with this issue online since 2010. I have been happy to share it for the first two or three years. Now I will mention this topic to avoid the suspicion of "stir-fried
1. Use the official PPA to install the latest Nginx version. Run the following command: The code is as follows:Copy code Sudo add-apt-repository ppa: nginx/stableSudo apt-get updateSudo apt-get install nginx Nginx control commands:Start
PHP page to UTF-8 encoding problems1. Add a line at the beginning of the code: The code is as follows:Copy code Header ("Content-Type: text/html; charset = utf-8 "); 2. Php file encoding problemsClick the editor menu: "File"-> "save as", you
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