MySQL Archive
Foreign Keys Made Simple with MySQL by examples
SQL
Nov 16, 2013
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
Databases
Nov 07, 2013
[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