HOME
MYSQL
MYSQL
Introduction
MYSQL
Table Create
MYSQL
Retrive
MYSQL Insert
MYSQL Delete
MYSQL Update
MYSQL Sort
|
MYSQL Database
MYSQL is the most widely used database language.
Weather you are application developer, database administrator, web application developer a good working knowledge of
database is an important part of interacting with databases.
What is database?
Database is a collection of data stored in some organized fashion. The simplest way is to think of it is to imagine a database as a filling cabinet.
What are tables in the database?
When you want to store some file with information you just can’t toss it in the drawer. Rather you create file within the filling cabinets and then add related file in a specific files.
In the database language we call files as tables. Ale is a structured file that can store data of a specific type. A table might contain a list of customers, name, ID or any other list of information.
What are columns and data types?
Tables are made up of columns. A column contains a particular piece of information within a table. Column is single field in a table. All the tables are made up of one or more columns.
Rows
Data in a table is stored in rows; each record saved is stored in its own row. Row is a record in a table
Keys
Every row in a table should have some column that uniquely identifies it. Table containing student information might use student roll number for this purpose.
What is SQL?
SQL is an abbreviation for Structured Query Language. SQL is a language designed mainly for communicating with databases. SQL is easy to learn. The statements are all made up of descriptive English word. SQL is designed to do only one work that is communicating with database in a simple and efficient way.
|
|
|