MySQL

Display database or table:     show databases;//can then use database_name;     show tables; Change table name:      alter table table_name rename new_t; Add columns  :      alter table table_name add column c_n  column attributes; Delete

Method One 1. Download MySQL source distribution, do not differentiate the operating system, we need something is the same; 2. Rename your MySQL folder under the data directory for Oldmysql; 3. Copy the MySQL directory under the data directory in

Looking for some information, and then I used the MySQL string processing of two functions concat () and left () 1, "CONCAT (str1,str2,...) Returns a string from the argument's link. Returns null if any argument is null. can have more than 2

Here is a simple piece of ASP import Excel data to save to other data such as MSSQL access MySQL, etc. oh, well, crap don't say much to see the following code. Set xlsconn = server. CreateObject ("Adodb.connection")Set Rs=server. CreateObject

Fatal error:the slave I/O thread stops because master and slave have equal MySQL server IDs The mosquitoes took a main three this afternoon. From MySQL replication, the result is that all servers are configured to find errors from the following

Recent server problems have caused the company's website data to be lost a lot. The wisdom of the soft also lost a lot. I've been working on this for the last few days. Repair data. It's time to restore a customer's data today. Found a consistent

Using a variety of well-designed tools to manage a MySQL database is much easier than simply using traditional methods. Developers should continue to look for tools that shorten development time. This is why we have compiled these 10 MySQL tools

Recently, a very strange MySQL problem, using different SELECT statements to query all datasets actually get different number of records. SELECT * Gets 4 records, and the Select field gets 3 records. specific questions can look at the following

  Sometimes we need to copy a whole column of data from one field to another, or we need to copy the value of one of the fields from one table to a field in another table, this article lists some of the SQL statements, and the friends you need can

MySQL 5.1 employs an authentication protocol based on the password-mix algorithm, which is incompatible with the protocol used by the earlier client (before 4.1). If you upgrade the server to 4.1, connecting with an earlier client may fail with the

When performing a rollback (rollback), if you receive the following message that 1 or more tables used in the transaction do not support transactions: Warning: Some of the changed non-transactional tables cannot be rolled back. These

Spock Proxy is an open source project generated by the actual project (Spock is the application of rails, Speck proxy should be available for use outside of rails, such as PHP or. NET), based on MySQL proxy development, is a branch of MySQL proxy,

Some children who have just come in contact with MySQL often mistakenly assume that Null is the same as the empty string '. This may seem like an unimportant thing, but in MySQL, the two are completely different. Null means that there is no value,

After a version of MySQL 5.x, the feature of the automatic shutdown idle connection of MySQL is modified, if a connection is idle to timeout (default 28,000 seconds 8 hours), the Reconnect reconnection request is not accepted, and a new connection

mysql| Data | Database CNET science and Information Network February 5 International Report according to software evaluation company Coverity Friday (January 4), through the open source database used by many websites--mysql's source code analysis,

Four, send data to the serverNow we don't have much difficulty reading data from the database. But how do you send data to the database in turn? In fact, this is not a problem with PHP. First, we create a Web page with a simple table.

Mysql 6 MySQL Sync The sync feature is introduced in MySQL 3.23.15, which can replicate data from a MySQL server to another server. This chapter describes the various replication features of MySQL. Describes the concept of synchronization, how to

Mysql 6.9 Sync FAQ Q: Master is still running, how can I configure slave without stopping it? A: You need to design several option parameters. If you have a backup of MASTER and record the data snapshot binary log file name and the offset location

mysql| Data | Database to check a lot of data, ASP and MySQL connection currently has two ways: one is the use of components, more famous is MYSQLX, but unfortunately to 99 of dollars. Two is to use MYODBC to connect, let's look at the second

We know that WordPress database table, you can set the prefix, the default is WP_, many students also default on the Wp_, if some reason (such as increased security) to modify the prefix of the WordPress data, what should we do? 　Before you start