MySQL SQL Delete Notes - 0 views
-
adie afton on 29 Jan 11To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table.
Group items matching
in title, tags, annotations or url
SQL Server 2005 - Service Broker - 0 views
-
The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker.
Reporting Services - 0 views
-
Reporting Services is a Web service-based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain information from virtually any data source.
How To Process MySQL Timestamp in PHP - 0 views
-
Many of us do not realize that MySQL's Timestamp is not the timestamp which PHP date() understands. In fact if you try to use MySQL timestamp directly in php date() function then you will get totally wrong dates. There is a simple way to use MySQL timestamp data in php.
MySQL 5.5 Milestone 2 improves replication and stored procedures - 0 views
-
The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010. The new milestone release incorporates semi-synchronous replication in MySQL 5.5 based on patches to InnoDB developed by Google.
MariaDB 5.1.44b Released - 0 views
-
MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download.
Stored Procedures in MySQL 5.0 - 0 views
-
MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.
MySQL 5.0 New Features: Triggers - 0 views
-
Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.
MySQL 5.0 New Features: Data Dictionary - 0 views
-
Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.
MySQL 5.0 New Features - 0 views
-
MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". The long answer is the MySQL 5.0 New Features series, and this book is the third in that series.
How to start/stop MySQL server on Linux - 0 views
-
This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously:
Structured Query Language: Integration Services - 0 views
-
SQL Server Integration Services (SSIS) is Microsoft's new enterprise class data Extract, Transform, and Load (ETL) tool.
Analysis Services - 0 views
-
Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications.
What is SQL Server 2008/RDBMS? - 0 views
-
SQL Server 2008 can be more accurately described as an Enterprise Data Platform.
SQL Server Security - 0 views
-
There are several levels of security to SQL Server. At the a base level, in order to be granted get access to a SQL Server, a user is required to have a login account.
Top 10 PostgreSQL Performance Optimization Tips - 0 views
-
PostgreSQL performance optimization is a widely discussed issue on the most forums. Although PostgreSQL is shipped with a solid default configuration aimed to fit most setups, it requires fair amount of performance optimization to offer the best.
‹ Previous
21 - 36 of 36
Showing 20▼ items per page