Skip to main content

Home/ Software Tutorials for Visual Learners/ Group items tagged sql programming

Rss Feed Group items tagged

adie afton

How To Export MS Access Database To MySQL Database - 0 views

  •  
    Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL
adie afton

Getting all stored procedures from a database - 0 views

  •  
    Here how you can get all the stored procedure from a database. Hey not only the name but the stored procedures definitions also.
adie afton

MySQL 5.0 New Features: Data Dictionary - 0 views

  •  
    MySQL now has a new "database" named INFORMATION_SCHEMA. It is a virtual database only; there will never be a need to create a file by that name, and the MySQL server itself creates and populates the tables therein.
adie afton

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".
adie afton

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.
adie afton

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.
adie afton

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.
adie afton

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.
adie afton

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases - 0 views

  •  
    Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:
adie afton

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:
adie afton

How To Export MS Access Database To MySQL Database - 0 views

  •  
    Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL.
adie afton

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.
adie afton

Analysis Services - 0 views

  •  
    Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications.
adie afton

Top 7 Free Open Source Database Server - 0 views

  •  
    After an extensive research we sorted out the top 7 Open Source Server based database management systems, have a look.
adie afton

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.
adie afton

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.
‹ Previous 21 - 36 of 36
Showing 20 items per page