PHP

Next, in the previous article, the INFORMATION_SCHEMA view is mentioned in the SQL table structure information query including the primary and Foreign keys and self-growth. In fact, in SQL2005, Microsoft has promoted the use of the

What data dictionary does a recent project need? table structure information is required. I have read a lot of queries on table structure information on the Internet, and I feel pretty bad. The better thing is to query the upgraded version

ViewPostSQL: The updated or deleted row values cannot be used to make the row a unique row, or change multiple rows during SQL database maintenance, several lines of records are found to have obvious errors but cannot be deleted. When you execute

Directory database design is the cornerstone of a successful software project. Many practitioners believe that database design is not that important. In reality, the scenarios are quite the same. The number of developers is several times that of

For a simple table, there are two rows and two columns (the row number is not counted at the moment). How can we do this if we want to swap the rows and columns? Prepare test data: CREATETABLETempSum (nINT, genderVARCHAR (10), totalINT);

For developers who want to develop the SQLServer2012 business intelligence project, they can now use the latest MicrosoftSQLServerDataTools Business Intelligence (SSDT-BI) software for development. The latest tools are available for SQLServer2005,

1. Split the string by the specified symbol and return the number of elements after the split (the method is very simple, that is, to check the number of separators in the string, and then add one, which is the required result .)

Database Design vocabulary table 1. accessmethod (2. alias (3. alternatekeys (4. anomalies (5. applicationdesign (6. attribute (7. attribute (8. attributeinheritance (9. basetable (10. binaryrelationship (11. bottom-upapproach (12. businessrules (13.

Actual Situation: 1: when the company's website traffic reaches several hundred thousand IP addresses per day, the pressure on the website server is very high, a very simple program, two adjacent SQL statements, when the server is busy, it may take 3

The OLTP system features a large number of small transactions with high concurrency in such applications, including SELECT, INSERT, UPDATE, and DELETE. These operations are relatively simple, and the transaction time is not very long, but the

SCN: SystemChangeNumberSCN is a logical internal timestamp of the Oracle database, used to identify the version submitted by the database at a specific time. When a transaction is committed or rolled back, it is assigned a unique identifier for the

Recently, it was found that there are too many logs in the binlog directory of mysql, and the disk space is full, resulting in Website access failure. -Rw ---- 1mysqlmysql1_3742161may3120: 51binlog. 201721-rw-rw ---- 1 mysqlmys Recently, it was

The database is not archived, and its online logs are repeatedly overwritten. This means that if the database needs to restore the application-related archive in the media, and the archive file does not exist due to non-archive, at this time, the

When someone asked a question about the Attach database failure, the error message is Msg5171, Level16, State1, Line2path \ allen_log.ldfisnot1_marydatabasefile. Obviously, this error indicates Attch. In the forum, someone asked a question about the

It is very important to regularly Delete mysql Master/Slave binlogs. Generally, you can use expire_logs_days10 to set the number of days that binlog is retained (not supported by mysql), but sometimes this is not enough, assume there are several

Last night, I updated a batch of data. It took more than 20 minutes to use the old update method, but less than two seconds to end with mergeinto. The efficiency is really quite different. For details, see: Update T_TMP_N using the BIRTH field of

Record the steps for upgrading the company's database. The company's system needs to be upgraded from 1.0 to 1.1, including all customers who are using our products because our customers are all over the country, it is impossible for every customer

Advantages of stored procedures: Reduced network traffic on the server client, enhanced security, code reuse, easier maintenance, and improved performance creation stored procedures: USEAdventureWorks2012; GOCREATEPROCEDUREHumanResources.

In this article, the system Centos6.0 is generally installed with the software workstation when I install my own system, and then update all the packages. When installing other software, there is a lot less dependency, A lot of trouble. In this

The following is the configuration and monitoring of the SGA big page on the AIX platform. 1. The page size supported by aix. AIX supports four types of page sizes, however, not every hardware platform supports four types at the same time. You can