Working with Database
Introduction to MySQL
Creating Tables
Altering Tables
Dropping Tables
Queries
• Database can be created in two way:
– Using PHPMyAdmin
– Using SQL command
1 __________________________ 2 _________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
Introduction to MySQL
Introduction to MySQL
• Using PHPMyAdmin
• Using SQL command
1. Type the database name and
2. Click the create button
– Syntax:
CREATE {DATABASE | SCHEMA}
[IF NOT EXIST] db_name
[create_specification
[, create_specification]…]
– Create specification:
[DEFAULT] CHARACTER SET charset_name
[DEFAULT] COLLATE collate_name
:
CREATE DATABASE DBLibrary
Example
3 __________________________ 4 _________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
Introduction to MySQL
Creating Tables
• Using SQL command
• Database can be DROP in two ways:
– Using PHPMyAdmin
5 __________________________ 6 _________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
Creating Tables
Creating Tables
• Database can be DROP in two ways:
• Using PHPMyAdmin
– Using SQL command
• syntax:
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
Example:
DROP DATABASE DBLibrary
1. Type the table name and the starting number of fields for the table,
2. Click the GO button,
1
2
• Example:
DROP DATABASE DBLibrary
7 __________________________ 8 _________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
Creating Tables
Creating Tables
• Using PHPMyAdmin
• Using SQL query command
3. Supply the information to the given fields attributes,
4. Add more fields if necessary and click GO button.
3
3
4
– The create table command is used to create tables inside a database. The CREATE TABLE command has the following syntax: CREATE TABLE <table_name> (
<column_name> <column_type> <column_attribute>,
<column_name> <column_type> <column_attribute>,
<column_name> <column_type> <column_attribute>,
…
PRIMARY KEY (<column_name>),
INDEX index_name (<column_name>))
TYPE=<table_type>;
9 __________________________ 10 ________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________
____________________________ ___________________________