Posts Tagged "Database"

• Creating An Event In MySQL

  Monday, 30th April 2012

  Executing scheduled task(s) in MySQL can be done by creating events. In this tutorial I show you how to create an event. Events in MySQL are tasks which run according to a schedule.The concept of events in MySQL is similar to the concept of cron jobs in the unix environment or task scheduler in the...Read More

                Tweet       
  Category: PHP / MYSQL   •   Tags: Database, MYSQL

• Exporting MySQL Database With PHPMyAdmin

  Monday, 26th March 2012

  Learn how to export MySQL databases with PHPMyAdmin. In this software tutorial exporting MySQL databases with PHPMyAdmin is demonstrated to show you how you can do database backup or moving of a MySQL database from one server to another or copying a MySQL...Read More

                Tweet       
  Category: Software   •   Tags: Database, MYSQL

• Characteristics Of Database Tables

  Thursday, 22nd March 2012

  Learn the characteristics of database tables (tables in the database). Knowing the characteristics of database tables will help you greatly to get an excellent understanding of what database table are. Furthermore you will get to know what a valid database table should comprise...Read More

                Tweet       
  Category: PHP / MYSQL   •   Tags: Database, MYSQL, SQL

• Renaming A MYSQL Database

  Thursday, 1st March 2012

  Renaming a MYSQL database. Never use the RENAME DATABASE statement because it may cause loss of database content. Get to know some of the alternative methods you can use to achieve something similar to database...Read More

                Tweet       
  Category: PHP / MYSQL   •   Tags: Database, MYSQL

• Using PHP To Search A MYSQL Database

  Monday, 19th December 2011

  Learn how to perform a search on a MYSQL database using PHP. You can perform a search on content in database tables using PHP by setting a MYSQL query that looks up content. Get to know the use of the wildcard character '%' when performing a database...Read More

                Tweet       
  Category: PHP / MYSQL   •   Tags: Database, MYSQL, PHP

• Storing Media Files In The Database Versus File System

  Thursday, 29th September 2011

  Storing media files in the database versus file system. A media file refers to any video or image or audio file. Learn about the disadvantages and advantages of using database or file system to store media...Read More

                Tweet       
  Category: Good Programming Practice   •   Tags: Database, Programming

• Solving Database Anomalies

  Thursday, 8th September 2011

  Learn about the various database anomalies and how you can solve each of them. There are three database anomalies i.e. delete anomaly, update anomaly and update anomaly....Read More

                Tweet       
  Category: PHP / MYSQL   •   Tags: Database, MYSQL

• Selecting Random Records From A MYSQL Database

  Saturday, 6th August 2011

  Learn how to retrieve / select records from a MYSQL database in a random order....Read More

                Tweet       
  Category: PHP / MYSQL   •   Tags: Database, MYSQL

• Connecting To A MYSQL Database In PHP

  Friday, 29th July 2011

  Learn how to connect to a MYSQL database using PHP functions like mysql_connect, mysql_select_db, mysqli_connect. Open connection to the...Read More

                Tweet       
  Category: PHP / MYSQL   •   Tags: Database, MYSQL, PHP