Float,double is prone to error, when precision requirements are higher, it is recommended to use decimal to save, decimal in the MySQL memory is stored as a string, used to define the currency requirements of high precision data.
Example
Creates a
A remote connection to the MySQL database prompts the following message: "MySQL connect error–1130:host ' 202.43.**.** ' is not allowed to connect to this MySQL server"
Originally in the Create MySQL account is, limited Connection account remote
Int
(1). 4 byte storage, the length of the int is 4 bytes, the storage space is less than datatime, the int index storage space is also relatively small, the sorting and the query efficiency is relatively higher a little(2) The readability is
[USA]web44 free 300M can be bound m php space applicationMonthly flow limit of: 10GB;
Support PHP, and provide 5 MySQL database;
Support Web/ftp way to upload and manage filesAddress: http://web44.co.cc
American Cashfreeweb offers 250MB free php
First, login WDCP panel background add site
In the menu on the left, site management-new site, you can create the new domain name site we need. According to Chinese prompts input we need to set the host name, binding domain name,
The first thought was to use
1, into MySQL, create a new user root, the password is root: Format: Grant permissions on the database name. Table name to user @ Login host identified by "User password";
The code is as follows
Copy
1. First, verify that the server is in a secure state, that is, no one can arbitrarily connect to the MySQL database. Because the MySQL database is completely out of password protection during the reset of the MySQL root password, other users can
The code is as follows
Copy Code
Mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sql
Back up the MySQL database to back up the MySQL database in a format with a delete table in the format with the deleted
Use MySQL for database backup, and very formal database backup method, with other database servers have the same concept, but have not thought, MySQL will have a simpler use of the file directory backup method, but also quick to have good.
One,
Introduction of MARIADB (MySQL introduction skip)
MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL licensed license MARIADB is fully compatible with MySQL, including
First method: Recommended
Error description: After adding users in MySQL, you may be prompted to error 1045 (28000): Access denied for user errors.
Cause analysis: A record in the Mysql.user table where user is blank may appear, such as:
Mysql>
Standard SQL pattern matching
SQL pattern matching allows you to match any single character with "_", while "%" matches any number of characters (including 0 characters). In MySQL, the SQL schema defaults to ignoring the case. Some examples are
The way to reduce this type of problem is to minimize the loss of power to the server and shut down the MySQL database manually when shutting down the server.
Here's a look at this question:
Can ' t open file: ' xxx. Myi ' (errno:145), this error
Currently two client-side extension Library connection timeouts can be set to operate with options such as mysqli:
Copy Code code as follows:
Creating objects
$mysqli = Mysqli_init ();
Set timeout options
$mysqli->options
MySQL 5.1 provides support for prefabricated statements on the server side. If you use the appropriate client-side programming interface, this support can play the advantage of an efficient client/server binary protocol implemented in MySQL 4.1. The
1, connect the database
Laravel The database configuration file is config/database.php, open the file, the default content is as follows:
return [Default return result set to PHP object instance' Fetch ' => pdo::fetch_class,The default database
Mintty is a small but very practical Cygwin terminal, but there is a serious problem is the inability to invoke interactive Windows native programs, such as Mysql.exe, when you enter the following command in Mintty:
Copy Code code as follows:
Brief introduction
I know there are a lot of articles and guidelines for implementing master-from replication on the Internet. In master-from replication, the host affects the machine. But any changes from the database will not affect the primary
In the same way, it only explains different places from SQL Server.
Insert
Inserting multiple rows of query results into a table
Grammar
INSERT into Table_name1 (column_list1) SELECT (column_list2) from table_name2 WHERE (condition)
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