nah kali ini saya akan share tutorial pemrograman web PHP MySQL..
silahkan langsung download aja tanpa ribet..
selamat belajar :)
silahkan langsung download aja tanpa ribet..
selamat belajar :)
CREATE DATABASE database_name
|
DROP DATABASE database_name
|
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
.......
)
|
CREATE TABLE Person
(
LastName varchar,
FirstName varchar,
Address varchar,
Age int
)
|
CREATE TABLE Person
(
LastName varchar(30),
FirstName varchar,
Address varchar,
Age int(3)
)
|
Untuk menambah field baru :
ALTER TABLE table_name
ADD column_name datatype (size)
Untuk menghapus field yang sudah ada :
ALTER TABLE table_name
DROP COLUMN column_name
|
DROP TABLE table_name
|
SELECT column_name_1, column_name_2, dst
FROM table_name
|
SELECT * FROM table_name
|
Company
|
OrderNumber
|
Sega
|
3412
|
W3Schools
|
2312
|
Trio
|
4678
|
W3Schools
|
6798
|
SELECT Company FROM Orders
|
Company
|
Sega
|
W3Schools
|
Trio
|
W3Schools
|
SELECT DISTINCT Company FROM Orders
|
Company
|
Sega
|
W3Schools
|
Trio
|
SELECT column FROM table
WHERE column operator value
|
Operator
|
Description
|
=
|
Equal
|
<> atau !=
|
Not equal
|
>
|
Greater than
|
<
|
Less than
|
>=
|
Greater than or equal
|
<=
|
Less than or equal
|
BETWEEN
|
Between an inclusive range
|
LIKE
|
Search for a pattern |
LastName
|
FirstName
|
Address
|
City
|
Year
|
Hansen
|
Ola
|
Timoteivn 10
|
Sandnes
|
1951
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
1978
|
Svendson
|
Stale
|
Kaivn 18
|
Sandnes
|
1980
|
Pettersen
|
Kari
|
Storgt 20
|
Stavanger
|
1960
|
SELECT * FROM Persons WHERE City='Sandnes'
|
LastName
|
FirstName
|
Address
|
City
|
Year
|
Hansen
|
Ola
|
Timoteivn 10
|
Sandnes
|
1951
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
1978
|
Svendson
|
Stale
|
Kaivn 18
|
Sandnes
|
1980
|
Untuk nilai berupa text :
Syntax yang benar :
SELECT * FROM Persons WHERE FirstName='Tove'
Syntax yang salah :
SELECT * FROM Persons WHERE FirstName=Tove
Untuk nilai berupa angka :
Syntax yang benar :
SELECT * FROM Persons WHERE Year>1965
Syntax yang salah :
SELECT * FROM Persons WHERE Year>'1965'
|
SELECT column FROM table_name
WHERE column LIKE conditions
|
SELECT * FROM Persons
WHERE FirstName LIKE 'O%'
|
SELECT * FROM Persons
WHERE FirstName LIKE '%a'
|
SELECT * FROM Persons
WHERE FirstName LIKE '%la%'
|
SELECT column_1, column_2, dst FROM table_name
ORDER BY column_1, column_2, dst ASC/DESC
|
SELECT column_1, column_2, dst FROM table
WHERE column_2 LIKE conditions ORDER BY column_1 ASC
|
Company
|
OrderNumber
|
Sega
|
3412
|
ABC Shop
|
5678
|
W3Schools
|
2312
|
W3Schools
|
6798
|
SELECT Company, OrderNumber FROM Orders
ORDER BY Company
|
Company
|
OrderNumber
|
ABC Shop
|
5678
|
Sega
|
3412
|
W3Schools
|
6798
|
W3Schools
|
2312
|
SELECT Company, OrderNumber FROM Orders
ORDER BY Company DESC, OrderNumber ASC
|
Company
|
OrderNumber
|
W3Schools
|
2312
|
W3Schools
|
6798
|
Sega
|
3412
|
ABC Shop
|
5678
|
LastName
|
FirstName
|
Address
|
City
|
Hansen
|
Ola
|
Timoteivn 10
|
Sandnes
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
Svendson
|
Stephen
|
Kaivn 18
|
Sandnes
|
SELECT * FROM Persons
WHERE FirstName='Tove'
AND LastName='Svendson'
|
LastName
|
FirstName
|
Address
|
City
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
SELECT * FROM Persons
WHERE firstname='Tove'
OR lastname='Svendson'
|
LastName
|
FirstName
|
Address
|
City
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
Svendson
|
Stephen
|
Kaivn 18
|
Sandnes
|
SELECT * FROM Persons WHERE
(FirstName='Tove' OR FirstName='Stephen')
AND LastName='Svendson'
|
LastName
|
FirstName
|
Address
|
City
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
Svendson
|
Stephen
|
Kaivn 18
|
Sandnes
|
UPDATE table_name
SET column_name = new_value
WHERE column_name = old_value
|
LastName
|
FirstName
|
Address
|
City
|
Nilsen
|
Fred
|
Kirkegt 56
|
Stavanger
|
Rasmussen
|
Ani
|
Storgt 67
|
|
UPDATE Person SET FirstName = 'Nina'
WHERE LastName = 'Rasmussen'
|
LastName
|
FirstName
|
Address
|
City
|
Nilsen
|
Fred
|
Kirkegt 56
|
Stavanger
|
Rasmussen
|
Nina
|
Storgt 67
|
|
INSERT INTO table_name (column1, column2, dst)
VALUES (column1_value, column2_value, dst)
|
LastName
|
FirstName
|
Address
|
City
|
Pettersen
|
Kari
|
Storgt 20
|
Stavanger
|
INSERT INTO Persons (LastName, FirstName, Address, City)
VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')
|
INSERT INTO Persons
VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')
|
LastName
|
FirstName
|
Address
|
City
|
Pettersen
|
Kari
|
Storgt 20
|
Stavanger
|
Hetland
|
Camilla
|
Hagabakka 24
|
Sandnes
|
LastName
|
FirstName
|
Address
|
City
|
Pettersen
|
Kari
|
Storgt 20
|
Stavanger
|
Hetland
|
Camilla
|
Hagabakka 24
|
Sandnes
|
INSERT INTO Persons (LastName, Address)
VALUES ('Rasmussen', 'Storgt 67')
|
LastName
|
FirstName
|
Address
|
City
|
Pettersen
|
Kari
|
Storgt 20
|
Stavanger
|
Hetland
|
Camilla
|
Hagabakka 24
|
Sandnes
|
Rasmussen
|
|
Storgt 67
|
|
DELETE FROM table_name
WHERE column_name = value
|
LastName
|
FirstName
|
Address
|
City
|
Nilsen
|
Fred
|
Kirkegt 56
|
Stavanger
|
Rasmussen
|
Nina
|
Stien 12
|
Stavanger
|
DELETE FROM Person WHERE LastName = 'Rasmussen'
|
LastName
|
FirstName
|
Address
|
City
|
Nilsen
|
Fred
|
Kirkegt 56
|
Stavanger
|
DELETE FROM table_name
atau
DELETE * FROM table_name
|