Archive:PHP and MySQL Programming/Creating a Database - Revision history

wikademia>Wikademia: moved PHP and MySQL Programming/Creating a Database to Archive:PHP and MySQL Programming/Creating a Database over redirect

2009-06-12T07:37:50Z

← Older revision	Revision as of 07:37, 12 June 2009
(No difference)

2009-05-18T21:04:19Z

← Older revision	Revision as of 21:04, 18 May 2009
(No difference)

2009-05-18T20:23:30Z

← Older revision	Revision as of 20:23, 18 May 2009
(No difference)

2009-04-18T19:26:25Z

15 revisions

← Older revision	Revision as of 19:26, 18 April 2009
(No difference)

2008-02-17T02:41:34Z

Introduction

← Older revision		Revision as of 02:41, 17 February 2008
Line 5:		Line 5:
	Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective.		Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective.

	In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a ~~Database~~.		In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a database.

	== SQL Code ==		== SQL Code ==

2008-02-17T02:40:55Z

SQL Code

← Older revision		Revision as of 02:40, 17 February 2008
Line 10:		Line 10:

	The code for creating such a database in SQL (Sequential Query Language) is a simple query :		The code for creating such a database in SQL (Sequential Query Language) is a simple query :
			<br>
	mysql> CREATE DATABASE `database_name`;		mysql> CREATE DATABASE `database_name`;

2008-02-17T02:40:05Z

Using the Database

← Older revision		Revision as of 02:40, 17 February 2008
Line 15:		Line 15:
	== Using the Database ==		== Using the Database ==

	After a database has been created, you have to tell ~~MySQ~~ that to make it the active database before you can start running further queries on it. You do this as follows :		After a database has been created, you have to tell MySQL that to make it the active database before you can start running further queries on it. You do this as follows :

	mysql> USE `database_name`;		mysql> USE `database_name`;

2007-10-03T05:10:57Z

Introduction

← Older revision		Revision as of 05:10, 3 October 2007
Line 2:		Line 2:

	MySQL is a relational database. In a relational database, data is stored as a collection of fields called a row. Like fields, rows are in turn collectively stored as a table. Tables are stored collectively in a database. One MySQL server can store multiple databases, and have users who have various rights to each database.		MySQL is a relational database. In a relational database, data is stored as a collection of fields called a row. Like fields, rows are in turn collectively stored as a table. Tables are stored collectively in a database. One MySQL server can store multiple databases, and have users who have various rights to each database.

			Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective.

	In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a Database.		In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a Database.

2007-10-03T05:09:29Z

Using the Database

← Older revision		Revision as of 05:09, 3 October 2007
Line 13:		Line 13:
	== Using the Database ==		== Using the Database ==

	After a database has been created, you have to tell ~~MySQL~~ to make it the active database before you can start running further queries on it. You do this as follows :		After a database has been created, you have to tell MySQ that to make it the active database before you can start running further queries on it. You do this as follows :

	mysql> USE `database_name`;		mysql> USE `database_name`;

2007-04-02T14:23:12Z

recat sort

← Older revision		Revision as of 14:23, 2 April 2007
Line 19:		Line 19:
	[[../Introduction to MySQL/\|Previous: Introduction to MySQL]] \| [[../\|TOC]] \| [[../Creating a Table/\|Next: Creating a Table]]		[[../Introduction to MySQL/\|Previous: Introduction to MySQL]] \| [[../\|TOC]] \| [[../Creating a Table/\|Next: Creating a Table]]

	[[Category:PHP]]		[[Category:PHP and MySQL Programming\|{{SUBPAGENAME}}]]
	~~[[Category:~~MySQL]]