In my website development, I used php4.0 + mysql3.23.38 to establish a variety of applications. Next, we will take a simple chat room design as an example to introduce the application of PHP + MySql in Web development.
1. Overall Design
1.
Discuz not found! Forum data table!
When upgrading from 5.5 to 6.0, the following problems occur when you run http: // *****. com/upgrade9.php after the upload is complete:
Discuz not found! Forum data table!Modify the database settings in
MyISAM is the default storage engine of MySQL. MyISAM does not support transactions or foreign keys, but it has fast access speed and has no requirements on transaction integrity.The InnoDB Storage engine provides transaction security with commit,
Sqlite provides some C function interfaces that you can use to operate databases. By using these interfaces, you can pass some standard SQL statements (in char * type) to the sqlite function, and sqlite will operate the database for you. Sqlite is a
1. Use mysqli extended library Preprocessing Technology mysqli stmt to add three users to the databaseCopy codeThe Code is as follows:
// Mysqli extended library Preprocessing Technology mysqli stmt adds three users to the database// 1. Create a
Modify the MySQL password:Copy codeThe Code is as follows:Mysqladmin-u root-p password 123456Mysqladmin-u username-p old password New password
Forget the MySQL password:Copy codeThe Code is as follows:Chown-R mysql: mysql/var/lib/mysql/Etc/init.
1. Add a fieldCopy codeThe Code is as follows:If not exists (SELECT * from syscolumns where id = OBJECT_ID ('querydatasource ') and name = 'iscrosstable ')BEGINAlter table QueryDataSource ADD IsCrossTable bit default (0) -- insert FieldEND 2 stored
In linux Linux uses utf8 encoding by default, while windows uses gbk encoding, so the above garbled characters may occur.Solve the Problem of garbled data during mysql Import and ExportThe first thing to do is to determine the encoding format of the
The number of split fields must be limited. Therefore, it is impossible to store an infinite number of characters in a string.The table to which this field belongs is associated with this field. It must be a one-to-many relationship.For example, the
You cannot create one. the error of the frm file seems to imply an error in the file permission of the operating system or other reasons, but in fact, none of these are actually. In fact, this mysql error has been reported as a mysql bug and has
1. mysql remote connection commands can be used to remotely import and export dataMysqldump -- default-character-set = gb2312-hsf-0000000.00-uroot-pxxxxxx mydatabase> d: \ data. SQLExport the specified database to an external SQL file!Restore
However, I am not going to describe the implementation details of a storage engine or the advantages and disadvantages of various storage engines. I just want to describe how mysql handles binlog and clarify several obfuscation problems.Binlog is
Reinstalling the system is always a good solution, but who would like to do so :(Later, I did not intend to find that the uninstallation was not completely caused by the uninstallation. The following describes how to unmount MySQL 5.1:1. add and
In most cases, the database is damaged only when the index file is damaged, and the real data is damaged rarely. Most forms of database corruption can be easily repaired.As with the previous verification, there are three methods to fix the
Copy codeThe Code is as follows:Repair table 'table _ name' REPAIR tableOptimize table 'table _ name' OPTIMIZE tableRepair table is used to REPAIR damaged tables.Optimize table is used to recycle idle database space. When the data rows in the TABLE
Premise: You will use vi. Obviously, this article is tested in Linux. This document uses the MySQL command line tool. If you do not, you can use phpMyAdmin.Step 2: Download the pure real IP data and decompress it into ip.txt.Explanation: you do not
View parameters: show variables;SET parameter: set global parameter name = value. For example, SET the maximum number of connections to a database to set global max_connections = 1000.Use the shell> mysqld-help command to obtain a table with all
At the beginning of the year, I had been working on the migration of a website MSSQL2000-> MySQL5. Because different program systems were used, the main problem was data migration. Because the structure of the two System databases is very different,
Can't connect to MySQL server on 'localhost' (10048), which is generally seen on windows 2003 server using mysql.Cause of the error:Applications need to be quickly released and create new connections. However, because the connections in TIME_WAIT
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