MySQL Archive

Foreign Keys Made Simple with MySQL by examples

In plain English : A FOREIGN KEY in one table points to a PRIMARY KEY in another table. A foreign key places constraints on data in the related tables to ensure and guarantee data referential integrity as well as consistency. Foreign Key Syntax: create table abc( abc_id int not null ..... ... ...Read More

SQL Simple Exercises using MySQL and phpMyAdmin

[info]If you have not installed MySQL/phpMyAdmin, Follow this tutorial to install EasyPHP[/info] 1 Open phpMyAdmin. Click : Databases to create a new database with the name : ecommerce, Click Create 2 Click on the database ecommerce on the left side. 3 Download the database ecommerce.sql file. [info]Click here Download the ecommerce.sql file ...Read More

SQL SELECT Tutorial : Searching & Querying the database

The most commonly used SQL command is SELECT statement. The SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must ...Read More