retrieving the data in mysql with certain conditions and for inputting data.

select a query that is used to retrieve data or display data. The data have been taken or may be displayed in the application that we created or used to control the program.

Basic syntax

In this tutorial we will discuss the basics of the SELECT statement in Oracle. To use the SELECT statement is advanced, we will discuss in the next tutorial.

Below is the basic syntax of the SELECT statement in Oracle:

Explanation syntax:

Implementation of the sql statement include DDL, DML and DCL

Previously had little in the pillowcase on what it DDL, DML and DCL.

Here everything will be discussed in more detail:

1. DDL (Data Definition Language)

DDL is the SQL command associated with defining a database structure that is used to create, modify and delete metadata structures and definitions of database objects.

Some basic commands that include DDL include:

A. CREATE

This command is used to create, including creating a new database, the new table, new view, and column.

Fields and Records in Sql with Each Character.

FIELD

Field is a column of a table. Field has the size of a particular data type that determines how the data will be saved.

The properties of the field is as follows: 

      1.        As the Primary key 

             attribute of Primary is the least that can distinguish each row of data in a table is uniquely     selected based on frequently used as a reference, more concise, and more guarantee a unique key.

Example: NIM students is the primary key of the table student. Nim has the function to be

The basic elements of SQL with MySQL implementations include statements, names, data types, constants, expressions and innate function.

After knowing the history of MySQL, now we are to the base in mysql.

Do you know about the basic elements that exist in mysql?

Answer :

1.   Statement

      Command of SQL is used to request an action to the DBMS. Basic SQL statements, among        others:

STATEMENT	DESCRIPTION
ALTER	Changing the table structure
COMMIT	Ending the execution of the transaction
CREATE	Create table, indexes
DELETE	Deletes the rows in a table
DROP	Deletes table, index
GRANT	Assigning rights to the database to the user
INSERT	Adding rows in the table
REVOKE	Cancel the rights to the database
ROLLBACK	Restoring the original state if the transaction fails to be implemented
SELECT	Select the rows and columns in a table
UPDATE	Change the value in a table row

  
   

Introducing sql programming for beginners of history, the excess until sql communities in Indonesia with mysql

Before introducing mysql, the first time i  will explain SQL (Structured Query Language)

What do you know about SQL?

According to wikipedia

SQL is a language...

that is used to access data in a relational database. That described herein relational database management system (RDBMS) or for stream processing in a relational data stream management (system RDSMS).