0
Membuat Database dan Tabel
Posted by jujur
on
5:29 AM
Bab 24
Membuat Database dan Tabel
Membuat Database
CREATE DATABASE database_name
|
Program24-1.php
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_close($con);
?>
|
Membuat Tabel
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
.......
)
|
Program24-2.php
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
// Create table in my_db database
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Person
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);
mysql_close($con);
?>
|
Tipe Data di MySQL
|
Numeric Data Types
|
Description
|
|
int(size)
smallint(size) tinyint(size) mediumint(size) bigint(size) |
Hold integers only. The maximum number of digits can be
specified in the size parameter
|
|
decimal(size,d)
double(size,d) float(size,d) |
Hold numbers with fractions. The maximum number of digits can be
specified in the size parameter. The maximum number of digits to the right of
the decimal is specified in the d parameter
|
|
Textual Data Types
|
Description
|
|
char(size)
|
Holds a fixed length string (can contain letters, numbers, and
special characters). The fixed size is specified in parenthesis
|
|
varchar(size)
|
Holds a variable length string (can contain letters, numbers,
and special characters). The maximum size is specified in parenthesis
|
|
tinytext
|
Holds a variable string with a maximum length of 255 characters
|
|
text
blob |
Holds a variable string with a maximum length of 65535
characters
|
|
mediumtext
mediumblob |
Holds a variable string with a maximum length of 16777215
characters
|
|
longtext
longblob |
Holds a variable string with a maximum length of 4294967295
characters
|
|
Date Data Types
|
Description
|
|
date(yyyy-mm-dd)
datetime(yyyy-mm-dd hh:mm:ss) timestamp(yyyymmddhhmmss) time(hh:mm:ss) |
Holds date and/or time
|
|
Misc. Data Types
|
Description
|
|
enum(value1,value2,ect)
|
ENUM is short for ENUMERATED list. Can store one of up to 65535
values listed within the ( ) brackets. If a value is inserted that is not in
the list, a blank value will be inserted
|
|
set
|
SET is similar to ENUM. However, SET can have up to 64 list
items and can store more than one choice
|
Primary Keys dan Auto Increment Fields
$sql = "CREATE TABLE Person
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);
|
