A tag is a keyword or label that categorizes your question with other, similar questions. Using the right tags makes it easier for others to find and answer your question.
The strategy selected by the query optimizer to process a query.
Oracle Database 12c. Please also tag oracle for search purposes.
UPDATE changes the values of the specified columns in all rows that satisfy the condition. Only the columns to be modified need be mentioned in the SET clause; columns not explicitly modified retain t…
A type of integrity constraint used in a RDBMS platform to ensure that a value in a column matches one of a range of key values from another table.
Splitting a database table into multiple segments for performance or manageability.
A widely-used open-source operating system that is particularly popular on servers.
MySQL version 5.7 - please also tag with mysql for search purposes.
the process of moving databases or data from one place to another
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.
a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
a relational model database server developed by IBM. It primarily runs on Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows servers.
A mechanism for managing concurrent access to shared data or resources by granting temporarily exclusive access to the processes requesting the lock.
useful and which are not.
a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).
A core statement in SQL that does what it says on the tin: inserts data into a table.
MySQL's Standard Dump/Backup Utility
a relational database management system that is part of the Microsoft Office suite.
When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.
directly relevant to the question and likely to be the source of your problem, not just because you're using a PHP library to connect to a database. PHP stands for Professional Hype…
A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.
The choice of settings for hardware, firmware, software or other components of a database system.
PostgreSQL version 9.3
Performance issues with PostgreSQL queries
the process of organizing columns into tables within a relational database in such a way as to minimize redundancy and avoid insertion, update and deletion anomalies.
A mechanism for committing a consistent set of changes into a database atomically.
A function performs some specified work, usually taking parameters as input. In terms of databases these may be specific to SQL or to the database vendor.
GROUP BY : SQL Aggregation for Common Values
Installation (or setup) of a database application, is the act of putting the application onto a computer system so that it can be executed.
describe when a `SELECT` statement is used as part of a larger SQL statement. The larger statement may be DML and is always found within brackets or parenthesis.
Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.
A virtual table that represents the data in one or more tables in an alternative way.
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
In relational database design, a primary key can uniquely identify each row in a table. A primary key comprises a single column or a set of columns.
Linked server allows operation to multiple server as one query.