MySQL

/*** Description, this class is suitable for small web site database backup, built-in MySQL connection, simply configure the data connection* and the location of the storage backup can be.* Class is materialized and you can connect to the database

$times = time ();$filename = $times. ". CSV ";$a = "contact person, contact telephone number, application time";$days = Postget ("Days");$mktime = Daystomktime ($days);$sql = "SELECT * from V_tugou where ($times-times) $db = new db ();$result = $db->

Free dual-line space (top600 type)Price: 0 yuan/Year 0 yuan/2 yearsContent: 100M dual-line web page space. Line for telecom + Netcom = North-South InteroperabilityThis class of machine a server only put 20 users, greatly improve performance.Send

Free space without advertising PHP mysql ASP access space Free unlimited host features: Support php5+mysql5/asp+access;10g large space for most sites is equivalent to No limit, unlimited flow, space and database configuration comparable to the

Free Host free200Model: Free host 200M (free200)Current: 0 RMB/monthContent:-Free three domain name, can be bound to 4 domain names-Host Space 200M-Real-time web Interface modification FTP, domain name and home page, etc.-Assign a separate FTP

Free homepage Space/asp,php,jsp,asp.net,mysqlPrice: 0 RMB※ Web Space 100M, give a 20M database, limited resources, each user can only apply for one;※ Independent FTP Account 1, IIS connection is unlimited, the flow is not limited;※ has the control

MySQL as the most commonly used database, often encountered a variety of problems. What we're going to say today is the changes to the table storage engine. There are three ways, the list is as follows. 1. True connection modification. It is slower

MySQL set a numeric column, you need to take into account the range of values, so the value of the type must be considered, the following is the MySQL numeric type of storage length, of course, storage length is basically determined by its range.

Delete Database command drop Command: Drop Database The code is as follows Copy Code mysql> drop Database drop_database; Query OK, 0 rows Affected (0.00 sec) So the database name is deleted There may be an

Scenario: Perform a full backup every Sunday and perform an incremental backup 1 o'clock in the afternoon every day Configuration The prerequisite for performing an incremental backup is that MySQL opens the log-bin log switch, for example in

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

Sample database: CREATE TABLE Shop (Article INT (4) UNSIGNED zerofill DEFAULT ' 0000 ' not NULL,Dealer CHAR DEFAULT ' not NULL,Price DOUBLE (16,2) DEFAULT ' 0.00 ' is not NULL,PRIMARY KEY (article, dealer)); INSERT into Shop VALUES(1, ' a ', 3.45),

1, install the configuration MySQL: This article installs the system is Centos6.3: The code is as follows Copy Code Yum List MySQL # see if there are any packages installedYum install MySQL # install MySQL clientYum List

The format () function is used to format a number of x:###,###,##### truncated to D decimal places in the following format. The following example shows how to use and output the format () function: The code is as follows Copy Code

command-line import large files use the source function directly Import Database Common source Commands Enter the MySQL database console, such as Mysql-u root-p Mysql>use Database Then use the source command, followed by the script file (such

Usually there is a field in the table that creates date, and other databases have the option of default values. MySQL also has a default value of timestamp, but in MySQL, not only is the insertion of the modification will also update the value of

1, through floor error You can use the following code The code is as follows Copy Code and select 1 from (SELECT COUNT (*), concat (version (), Floor (rand (0) *2)) x to Information_schema.tables Group by X);and (select

MYSQL Modify Root Password command CMD switch to MySQL installation directory Cases D:/mysql/bin Prerequisite: The MySQL user root password is empty. Enter Mysql-u root MySQL In mysql> state enter update user set Password=password (' New

Inquire:In a select query, another select query is nested. One is the outer query and the other is the inner query.where child query That is, the WHERE query statement has a SELECT statement that treats the results of the inner query as the

Look at my example first. Error resolution for character set The problems that arise:Mysql> Update Users-> set username= ' Guan Yu '-> where userid=2;ERROR 1366 (HY000): Incorrect string value: ' Xb9xd8xd3xf0 ' for column ' UsernAme ' at row 1 An