Introduction The LAMP stack (Linux, Apache, MySQL, PHP) is a group of open source software that is typically installed together to enable a server to host dynamic PHP websites and web apps. This guide includes Read more…
Introduction The LAMP stack (Linux, Apache, MySQL, PHP) is a group of open source software that is typically installed together to enable a server to host dynamic PHP websites and web apps. This guide includes Read more…
DOMAIN NAME SYSTEM What is DNS? Internet Directory Service A client-server application that maps host names into their corresponding IP addresses Mapping host names into their corresponding IP addresses is called name resolution or name Read more…
MySQL: Introduction and How it Works MySQL Installation MySQL replication The Top MySQL 10 Design Tips MySQL Performance Tuning: The stages of Tuning MySQL Indexing How to create an index How MySQL and PHP Work Read more…
This article is a fraction of a Number of Articles on MySQL, to access them click here. Step 1 :Download MySQL 5.0 Community Edition to your Desktop from https://dev.mysql.com/downloads/mysql/5.6.html Make sure you always download the Read more…
This article is a fraction of a Number of Articles on MySQL, to access them click here. This article describes the basic constraints that can be specified in SQL as part of table creation. These Read more…
This article is a fraction of a Number of Articles on MySQL, to access them click here. Handling MySQL Errors You use the mysqli functions of the PHP language, such as mysqli_connect and mysqli_query, to Read more…
This article is a fraction of a Number of Articles on MySQL, to access them click here. You interact with the database by passing messages to the MySQL server. The messages are composed in the Read more…
This article is a fraction of a Number of Articles on MySQL, to access them click here. SQL CREATE INDEX Syntax Creates an index on a table. Duplicate values are allowed: CREATE INDEX index_name ON Read more…
This article is a fraction of a Number of Articles on MySQL, to access them click here. MySQL Indexing MySQL documentation says: The best way to improve the performance of SELECT operations is to Read more…
